Errors after system copy ...

[Former Member]

Dear all,

envi--- AIX 5.3 & oracle 10.2 -

---

ECC 6.0SR1 ABAP ........only

I have restored a backup of PRD to QAS successfully ... for system copy...

I have created ops$ users with following statments..

create user ops$qlyadm identified externally default tablespace PSAPSR3USR temporary tablespace PSAPTEMP quota unlimited on PSAPSR3USR ( sidadm)

create user ops$oraqly identified externally default tablespace PSAPSR3USR temporary tablespace PSAPTEMP quota unlimited on PSAPSR3USR ( orasid )

Successfully created control file & managed to take the database up...

***************************************************************************************************

Enter user-name: / as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1728053248 bytes

Fixed Size 2071840 bytes

Variable Size 872415968 bytes

Database Buffers 838860800 bytes

Redo Buffers 14704640 bytes

Database mounted.

Database opened.

SQL>

after the following action when i tried to startsap. with user sidadm the following is the message..

Checking QLY Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

Start of saposcol failed

Running /usr/sap/QLY/SYS/exe/run/startdb

Trying to start QLY database ...

Log file: /home/qlyadm/startdb.log

/usr/sap/QLY/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

athomedev:qlyadm 26>

As a result when i checked startdb.log the following is the message.......

-

---

Fri May 29 16:03:32 IST 2009

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Fri May 29 16:03:32 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORA-10997: another startup/shutdown operation of this instance inprogress

ORA-09967: unable to create or open lock file

IBM AIX RISC System/6000 Error: 13: Permission denied

Disconnected

-

---

Fri May 29 16:03:32 IST 2009

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/QLY/SYS/exe/run/startdb: Terminating with error code 12

Request to advice me on the following & also advice me the way i created ops$ users is that right way or not..

rgds,

rahul...

Edited by: Rahul on May 29, 2009 4:21 PM

[Former Member]

Dear all,

thanx for sharing,, I have actually odnea mistake after system copy. I tried to make the system up with out creating ops$ suer.

I have followed notes

361641 Creating OPS$ users on UNIX & created ops$ created ops$ user with automated script & from attchment provided in Note 50088 - Creating OPS$ users on Windows NT/Oracle

after that

alter sytem sapr3 account unlock;

system is up & runnig.

regards

ravi kiran

[former_member524429]

Hi Rahul,

Start the Oracle Database from SQLPLUS Level, as it is successful in your case,as per as your post contents.

Once the database is started exit and run R3trans -d. Also do it as <sid>adm user. And, place the contents of the trans.log file that is created as a result....

This log will contain the Database connection issues that R3trans is encountering.

Regards

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Jun 1, 2009 11:19 AM

[Former Member]

Please check thei Note for the creation of the Ops $ user

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Thanks

Rishi Abrol

[Former Member]

ORA-10997: another startup/shutdown operation of this instance inprogress ORA-09967: unable to create or open lock file IBM AIX RISC System/6000 Error: 13: Permission denied

May be two processes are trying to start oracle. Check your alert.log file too. Are you starting with <sid>adm?