Thursday, July 29, 2010

Migrate Oracle Database from Enterprise Edition to Standard Edition


I have heard many DBA come across a situation where they are told to down grade the Oracle Database from Enterprise to Standard Edition. It might be due to cost cutting or some times it depends on the utilization that an organization takes from that db server.

So here I would like to share some of the basic steps that will help you in migrating your database(s).

- Oracle Standard Edition needs to be installed in different ORACLE_HOME.

- Take a cold/hot backup of your databases. (recommend to go for COLD backup)

- Shutdown database the database currently in use by 'shutdown immediate' or 'shutdown normal'

- Start setting up your new ORACLE_HOME, LIBPATH, LD_LIBRARY_PATH, SHLIB_PATH, TNS_ADMIN parameter and any other if required. Make sure that all this parameter is set to the new installation made (In our example it will be Standard Edition)

- If you are using _SYSTEM_TRIG_ENABLED OR JOB_QUEUE_PROCESS then request you to turn off before moving ahead.

- Start database under new Oracle Home.

Now if you observe properly you will find that the database will be running in Oracle Standard Edition but all the dictionary tables and packages are still of Enterprise Edition. So we need to migrate these objects to Standard Edition.

Hope you remember the step that we do when we do a upgrade. Yes!! Execution of cataproc and catlog sql files.

- Execute the below commands as SYSDBA

Command Prompt>sqlplus /nolog
SQL>connect internalOR
SQL>connect /as sysdba
SQL>@?/rdbms/admin/cataproc.sql
SQL>@?/rdbms/admin/catlog.sql

These scripts will re-create all the system and sys objects used by Oracle for Standard Edition.

- For RMAN Catalog upgrade we need to execute the below rman commands.
Command Prompt>rman
RMAN>connect target
RMAN>upgrade catalog;

- Shutdown the database and restart it.
- Post Migration we need to check if all the RMAN and other shell scripts are working properly because we might have entered the complete path of Oracle Home.

- As we are aware that Oracle Standard Edition supports 1 RMAN Channel so we need to make the changes to the backup and restore script as well by allocating 1 channel.

Please make sure that we update all the scripts correctly and don't forget to share your comments for this article.




Wednesday, July 28, 2010

Error Installing Oracle 10g 10.2.0.1 on HP-UX

Today, I was doing an installation of Oracle 10g Rel 2 Database on HP-UX B.11.31 and found the below error.

trying to install Oracle 10 G release 2 on HP-UX (HP-UX B.11.31) and it was giving me an error mentioned below.


Checking operating system version: must be B.11.23. Actual B.11.31


Failed

Here you are not missing any patch or u don't need to download the Oracle binary again for HP-UX 11.31.

Here is the solution you can try.

Just ignore this error and start executing with below command that will ignore system Pre-requisites check.

runInstaller -ignoreSysPreReqs

Friday, July 23, 2010

Less than 1 Year until the internet runs out of IP Version 4

As currently we are using IPV4 and as said by John Curran, President and CEO of the American Registry for Internet Numbers (ARIN) today that this is going to be a big issue in the coming year.


IPv4 address is limited to a 32-bit number, which means there are a maximum of just over 4 billion unique addresses assigned over the globe. IPv6 is the next generation Internet Protocol and it uses 128-bit address and can provide over 4 billion addresses to every person on the planet.


Check the below link that is available on Win7Vista.com that provides you more details 


http://win7vista.com/index.php?PHPSESSID=ae7c7efe2631ab7b823d867bd1990d45&topic=19481.0