Home » RDBMS Server » Server Administration » Install base Conversion
Install base Conversion [message #147318] Thu, 17 November 2005 03:41 Go to next message
rishika
Messages: 5
Registered: July 2005
Location: bangalore
Junior Member
Hi

Can anyone provide the details and procedure to do the Install base conversion pls its very urgent


Thanks in Advance

Regards
Rishi
Re: Install base Conversion [message #147398 is a reply to message #147318] Thu, 17 November 2005 08:51 Go to previous messageGo to next message
Frank Naude
Messages: 4590
Registered: April 1998
Senior Member
What do you mean by "Install base conversion"? Do you want to upgrade a database?

Best regards.

Frank
Re: Install base Conversion [message #147489 is a reply to message #147318] Thu, 17 November 2005 19:00 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
I just did (today) an upgrade to 10.2.0.1 from 10.1.0.2.

The steps are:
do a full backup of source database
Analyze statistics on source database
create a new software owner for the new software
Find a new ORACLE_BASE
create directories in new ORACLE_BASE (ie. /u03/app/oracle/product/10.2/)

Setup your software owner's .profile to name new sid, $ORACLE_BASE, and $ORACLE_HOME

Install the new database software as a software only, custom install (pick the components you need)
run root.sh as root
update your /var/opt/oracle/oratab file

run netca to configure the listener(netca) and edit you tnsnames.ora
turn off dbconsole(emctl dbconsole stop from old $ORACLE_HOME/bin) and remove(emca -x from old $ORACLE_HOME/bin) it if you want dbua to reconfigure it
know your passwords for sys, system, sysman, old software owner, new software owner
run the upgrade assistant from the new software owner (dbua from new $ORACLE_HOME/bin)
choose to install OEM during upgrade if you want it
choose to backup to a directory you setup that has the space (important)
unlock user accounts you need because dbua locks all user accounts
test it, have a beer!

I am sure I left out a few steps. Check the manual for exact instructions.
Re: Install base Conversion [message #148393 is a reply to message #147398] Wed, 23 November 2005 23:41 Go to previous message
rishika
Messages: 5
Registered: July 2005
Location: bangalore
Junior Member
Thank you.

Install base is a module in Oracle application i just want to know the conversion of this module from legacy system to oracle application

Regards
Rishi
Previous Topic: 10g - found a way to do install at my desk
Next Topic: Database hangs during the night ......
Goto Forum:
  


Current Time: Thu Feb 13 16:55:04 CST 2025