Sunday, April 29, 2012

multiple oracle databases multiple listeners of one linux server

here are the db parameters
-------------------------------
db1 - port 1521
db2 - port 1526

listener.ora of db2 (named it exproc1 in listener tag)
----------------------
# listener.ora Network Configuration File: /wc1013/ora/wc1013db/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /wc1013/ora/wc1013db)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1526))
    )
  )

listener.ora of db1  (named EXTPROC0 in the listener tag)
-----------------------
# listener.ora Network Configuration File: /orclportal/ora/db10/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /orclportal/ora/db10)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = oradb10.thekpsoft.com)
      (ORACLE_HOME = /orclportal/ora/db10)
      (SID_NAME = oradb10)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )

Sunday, April 22, 2012

Pentaho BI Suite Installation on Linux

Download pentaho-bi-suite-4.1.0-GA-i386.bin
create pentaho user and add it to sudo
sudo useradd -s /bin/bash -m pentaho 

login as pentaho user

chmod u+x  pentaho-bi-suite-4.1.0-GA-i386.bin

./pentaho-bi-suite-4.1.0-GA-i386.bin

In the wizard select custom option and select a path where you want pentaho to be installed and it will install all pre-reqs. I installed JDK, Tomcat and MySQL already. But it appears everything comes with the install and could be used unless you are on production.

sample users created are:
admin/welcome1(for http://localhost:8088)
joe/password (administrator)
suzy/password (system user)

mysql startup issues

In this note, I will document all startup issues that i had with mysql. Downloaded mysql community edition rpm 5.5.23 server and client packages and installed the using rpm -ivh <package names>

i tried to start using commands with mysqld but there were issues.

login as root and start mysql as below:

service mysql start

it worked.

Some other commands;
1. create user 'pbiuser'@'localhost' identified by 'welcome1';
2. create database 'bankdb';
3. create database bankdb;
4. grant usage on *.* to pbiuser identified by 'welcome1';
5. grant all privileges on bankdb.* to pbiuser@localhost;

Monday, April 16, 2012

oracle portal 11g upgrade

Below are the steps for upgrading oracle portal 10.1.4.2 to 11.1.1.2

Db upgrade - 10.2.0.1 to 10.2.0.4 via patch 6810189
  • runInstaller -ignoreSysPrereqs
  • select ORACLE_HOME that needs to be upgraded
  • run root.sh as root at the end
  • export ORACLE_HOME, ORACLE_SID and PATH
  • dbua
  • select DB that you want to upgrade and run through the wizard
Install 10.3.5 weblogic server as 11.1.1.6 requires this
Install base version 11.1.1.2 (install software - do not configure option)
Install patchset 11.1.1.6 against 11.1.1.2 binaries
Run config.sh to create  instance and domain
  • yum install openmotif
  • yum install openmotif22 (for reports server) 

upgrade middle tier instance (ua)
  • select middle tier ORACLE_HOME of 10g portal instance
  • select asinst_1 or whatever your new ORACLE_HOME of 11g weblogic instance that you created in step before this
Getting some errors here... I will update this post in case i resolve these issues.....
upgrade portal schema (ua)

Virtualbox permission denied error on mac host and linux guest

if you shared folder on the vm settings -> shared folders, can access this as root and are getting a permission denied problem as any other user, below is the list of steps for you :)

find uid (500) and gid (52000) of the user on the guest linux

login as root and run the following commands:

sudo mount -t vboxsf -o uid=500 Downloads /mnt/Downloads_win

or edit /etc/fstab and add the following at the end:

Downloads /mnt/Downloads_win vboxsf uid=500,gid=52000 0 0

Hope it works