OraFAQ Forum: Server Administration » Encounter problem during Oracle Database Post Clone activity

Home » RDBMS Server » Server Administration » Encounter problem during Oracle Database Post Clone activity

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

Encounter problem during Oracle Database Post Clone activity [message #195675]

Sat, 30 September 2006 23:52

tychee
Messages: 4
Registered: March 2006
Location: Malaysia

Junior Member

Hi,
I'm need your help on resolve below errors which I got when perform post clone on Oracle Database:
$ vi /apps/testdb/8.1.7/appsutil/log/TEST_hr/ApplyDBTier_09301159.log

CREATE CONTROLFILE REUSE SET DATABASE "TEST"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01189: file is from a different RESETLOGS than previous files
ORA-01110: data file 379: '/datahr2/testdata/tools01.dbf'

alter database open resetlogs
*

$ vi /apps/testdb/8.1.7/admin/TEST_hr/bdump/alert*.log
Sat Sep 30 12:03:47 2006
ORA-1503 signalled during: CREATE CONTROLFILE REUSE SET DATABASE "TEST" LOGFI...
Sat Sep 30 12:03:47 2006
alter database open resetlogs
ORA-1507 signalled during: alter database open resetlogs
...

Thank you.

Report message to a moderator

Re: Encounter problem during Oracle Database Post Clone activity [message #195745 is a reply to message #195675]

Mon, 02 October 2006 02:01

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

ORA-01189: file is from a different RESETLOGS than previous files

Cause: In a CREATE CONTROLFILE command either this file or all previous files were backups from before the last RESETLOGS. This may also occur if this is a file that is offline and has been offline since before the last RESETLOGS.

Action: If the file was taken offline normal before the last RESETLOGS, and is still offline, omit it from the CREATE CONTROLFILE command. Rename and online the file after the database is open. Otherwise find the version of the mentioned file consistent with the rest of the datafiles and resubmit the command.

Report message to a moderator

Re: Encounter problem during Oracle Database Post Clone activity [message #196189 is a reply to message #195675]

Wed, 04 October 2006 07:58

tychee
Messages: 4
Registered: March 2006
Location: Malaysia

Junior Member

Thank for the solution and I managed to solve this problem.
However, I encountered another problem i.e. I not able to access Oracle Portal after successful clone database and application; and complete modifying the configuration files to reflect old settings by referring x_* files generated from adchkcfg.sh.
I am getting below error when accessing Portal
----------------------------------------------------------------
Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Oracle HTTP Server Powered by Apache/1.3.19 Server at hr.xxx.com.my Port 8001
----------------------------------------------------------------

and below error in iAS/Apache/Apache/log/error_log file:
----------------------------------------------------------------
[Wed Oct 4 20:00:07 2006] [warn] mod_plsql: Stale Connection due to Oracle error
20001
[Wed Oct 4 20:00:07 2006] [error] mod_plsql: /pls/TEST_portal30/PORTAL30.wwsec_ap
p_priv.login HTTP-503 ORA-20001 <B>Call to WPG_SESSION API Failed.</B><BR>
[Wed Oct 4 20:00:07 2006] [error] mod_plsql: Cookie: portal30=3.0+en+us+AMERICA+F
5DD725F5F7E10D5F92537387CE32D5A4219A3C45B2EDA152449C6587A6E172CB3D9B707E32677D421B
492EF0BD0A0713F37120A432052675613F8C67BD0B4BD9A97F5BFEAAEBD25622BAFDDDEFD57259D42F
B6A4BC677CC8AEEFB9A51DC927E; portal30_sso=3.0+en+us+AMERICA+202287A6C1826FC83F743D
43029A6189BF3906131613ECB0C4219691ED698068151160DBD6C69673427C3020799F033E63D9E712
50A700877D75BF104B755AE74980B55D28D7C5844A84A45F4DC5E4E8DCEB041BB8C4C66F
----------------------------------------------------------------
Please advice. Thank you.

Report message to a moderator

Previous Topic:	ORA-01652 unable to extend temp segment
Next Topic:	Inside redo logs and Logminer (merged 3 cross-posts)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:44:10 CDT 2024