cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 12c upgrade

Former Member
0 Kudos

Hi All,

I am in the process of upgrading oracle 11g to 12c on AIX platform.  I am following the sapnote 1915317 - Migrating Software Owner to 'oracle' to migrate current software owner

Step 7 says "Log on as 'oracle', '<sapsid>adm' and 'ora<dbsid>' and verify that environment variables ORACLE_BASE, ORACLE_HOME and ORACLE_SID are set identical."

After executing the scripts i changed the owner , however when i login using user "oracle" i don't find any environmental variables ORACLE_BASE, ORACLE_HOME and ORACLE_SID set for user "oracle" . Not sure if i am missing something in here.

Do i copy the env's from user ora<sid> to oracle and then proceed further?

Any information on this is greatly appreciated.

Thanks

Arun

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi James/Ram,

Yes , i followed the Note you mentioned and ran the script "oraenv"  and set the SID . However i was not able to view any env's assigned to user "oracle" .

The other option was to copy the env's from old user "ora<sid>" and replace them to "oracle" , only then i was able to start listener and database.

I raised a message with SAP , I think the script were not working in my case.

Thanks

Arun

JamesZ
Advisor
Advisor
0 Kudos

Hi Arun,

Have you run the scripts as mentioned in note 1554661?

Best regards,
James

Former Member
0 Kudos

Hi Arun,

apart from the script. You need to always run .oraenv for switching to new environment and then Provide the SID for your DB to start working on it.

And do check if you have changed the .dbenv<serverNAme>.sh /.csh files for the new Oracle homes.

Regards,

Ram