External hard drive for both Mac and PC

I've been using external hard drives for a while now. Recently i switched to Mac, I was able to use these hard disks and retrieve documents and files. However i was not able to write to them with "Not recognizing the external hard drive".  Here is how i got around:

1. Remember that you loose all data while doing this, so back up on another hard drive
2. Connect your hard drive to a windows O/S computer with either vista or windows 7
3. Open windows explorer and right mouse click and select format
4. Pick exFAT format and 32 kb file block size
5. Format the disk

now it is ready to use. Remember that all data that you have on teh disk is lost and back it up on a different disk before you do any of this.

webcenter 10gR3 SSO with Portal Infra 10.1.4.2

Webcenter Installation - port 7780
Oracle Portal IM Installation - port 7777
Oracle Portal MT Installation - port 7778


Export ORACLE_HOME=/orclportal/ora/im
EXPORT ORACLE_SID=oradb10

[localhost oracle /orclportal/ora/im/sso/bin]$ ./ssoreg.sh -oracle_home_path /orclportal/ora/im -config_mod_osso TRUE -site_name localhost.localdomain:7780 -remote_midtier -config_file /orclportal/ora/im/Apache/Apache/conf/osso/myosso.conf

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))
    )
  )

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;

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