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