Skip to Content
0
Former Member
May 29, 2009 at 10:50 AM

Errors after system copy ...

199 Views

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