OraFAQ Forum: Server Administration » Upgraded Oracle from 11.2.0.1 to 11.2.0.3 using DBUCA, alert

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post result of:

show parameter diag
show parameter dump

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 #617585 is a reply to message #617584]

Wed, 02 July 2014 01:38

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

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 #617591 is a reply to message #617585]

Wed, 02 July 2014 02:03

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

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.

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 #617644 is a reply to message #617623]

Wed, 02 July 2014 08:18

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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.

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 #617658 is a reply to message #617644]

Wed, 02 July 2014 10:00

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.

Report message to a moderator

Previous Topic:	issue admin login
Next Topic:	ORA-02019

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 17:03:57 CST 2025