Home » RDBMS Server » Server Administration » Upgraded Oracle from 11.2.0.1 to 11.2.0.3 using DBUCA, alert_sid.log doesn't move to new home (Oracle, 11g, windows 2008R2)
Upgraded Oracle from 11.2.0.1 to 11.2.0.3 using DBUCA, alert_sid.log doesn't move to new home [message #617582] Wed, 02 July 2014 01:02 Go to next message
Subbu19
Messages: 15
Registered: July 2014
Location: Chennai
Junior Member
Hi DBA's,
I have Upgraded oracle from 11.2.0.1 to 11.2.0.3 using database upgrade configuration assistant. Now Oracle is running fine and version is 11.2.0.3, but alert_Sid.log is resides in the old home. Moreover, it writes the log in the old home location itself

Old Home: C:\Oracle\diag\rdbms\wind\wind\trace\alert_wind.log
New Home: C:\Ora11g\diag\rdbms\(empty).

Can you please suggest me, how to move the alert.log file to new home.

Steps Reproduced:
1. Installed Oracle 11.2.0.3 as a separate home.
2. Configured Listener
3. Ran DBUCA from 11.2.0.3 home
4. Completed Upgrade.

[Updated on: Wed, 02 July 2014 09:38] by Moderator

Report message to a moderator

Re: pgraded Oracle from 11.2.0.1 to 11.2.0.3 using DBUCA, alert_sid.log doesn't move to new home [message #617584 is a reply to message #617582] Wed, 02 July 2014 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post result of:
show parameter diag
show parameter dump

Re: pgraded Oracle from 11.2.0.1 to 11.2.0.3 using DBUCA, alert_sid.log doesn't move to new home [message #617585 is a reply to message #617584] Wed, 02 July 2014 01:38 Go to previous messageGo to next message
Subbu19
Messages: 15
Registered: July 2014
Location: Chennai
Junior Member
Hi Michel,

SQL> show parameter diag;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string C:\ORACLE
SQL> show parameter dump;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string C:\ORACLE\diag\rdbms\wind\wind
\trace
core_dump_dest string C:\ORACLE\diag\rdbms\wind\wind
\cdump
max_dump_file_size string unlimited
shadow_core_dump string none
user_dump_dest string C:\ORACLE\diag\rdbms\wind\wind
\trace
Re: pgraded Oracle from 11.2.0.1 to 11.2.0.3 using DBUCA, alert_sid.log doesn't move to new home [message #617591 is a reply to message #617585] Wed, 02 July 2014 02:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So change these parameters to point to the new location you want.

Forgot:
Please read How to use [code] tags and make your code easier to read.

[Updated on: Wed, 02 July 2014 02:03]

Report message to a moderator

Re: pgraded Oracle from 11.2.0.1 to 11.2.0.3 using DBUCA, alert_sid.log doesn't move to new home [message #617592 is a reply to message #617585] Wed, 02 July 2014 02:09 Go to previous messageGo to next message
Subbu19
Messages: 15
Registered: July 2014
Location: Chennai
Junior Member
Tks.... Michel

[Updated on: Wed, 02 July 2014 02:10]

Report message to a moderator

Re: pgraded Oracle from 11.2.0.1 to 11.2.0.3 using DBUCA, alert_sid.log doesn't move to new home [message #617623 is a reply to message #617592] Wed, 02 July 2014 05:33 Go to previous messageGo to next message
Subbu19
Messages: 15
Registered: July 2014
Location: Chennai
Junior Member
Hi Michel,
Thanks a lot, I made changes for those parameters to the new location. Now Oracle writes alert.log under new location.
Re: pgraded Oracle from 11.2.0.1 to 11.2.0.3 using DBUCA, alert_sid.log doesn't move to new home [message #617644 is a reply to message #617623] Wed, 02 July 2014 08:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Indeed, Oracle assistant does not change these parameters as they are yours and can point anywhere, most often outside the Oracle home.
I advise you to do so to prevent from having to change them when you change the Oracle home for an upgrade.
Do not mix up what is about the databases and what is about Oracle binaries.

icon14.gif  Re: pgraded Oracle from 11.2.0.1 to 11.2.0.3 using DBUCA, alert_sid.log doesn't move to new home [message #617658 is a reply to message #617644] Wed, 02 July 2014 10:00 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Michel Cadot wrote on Wed, 02 July 2014 08:18


Do not mix up what is about the databases and what is about Oracle binaries.



+1
Previous Topic: issue admin login
Next Topic: ORA-02019
Goto Forum:
  


Current Time: Tue Mar 19 03:29:19 CDT 2024