on 02-06-2009 8:40 AM
Dear Team,
When I start sap in my unix.
quality:qasadm 1> startsap
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
13:21:11 06.02.2009 LOG: Effective User Id is root
******************************************************************************
This is Saposcol Version COLL 20.90 700 - v2.05 for HP-UX - 28.7.2006
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
Starting collector (create new process)
******************************************************************************
saposcol on host quality started
Running /usr/sap/QAS/SYS/exe/run/startdb
Trying to start QAS database ...
Log file: /home/qasadm/startdb.log
QAS database started
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
It start sucessfully.
But at start why it is giving messege
ABAP Database is not available via R3trans
My listner start sucessfully.
Thanks
Login as <sid>adm and execute
R3trans -d
then check the resulting trans.log
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do not cross post.
Read the "Rules of Engagement" in detail before posting any further.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please do not duplicate posts across multiple forums.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The following will explain how SAP connect to the database:
1- It use the user OPS$SIDADM to connect to the DB to get SAPSR3 password stored in table OPS$SIDADM.SAPUSER.
2- If the user OPS$SIDADM can't connect to the database (because the user does not exist or is not created properly for example), or if the table OPS$SIDADM.SAPUSER does not exist, SAP will try to connect with the default password of SAPSR3 which is 'sap'.
What I can see in your log is:
- Your OPS$SIDADM user can't connect to the database (so maybe it does not exist or is not created properly)
- The password for SAPSR3 is not the default password.
So the easiest thing to do right now is to change the password of SAPSR3 at the database level:
ALTER USER SAPSR3 IDENTIFIED BY sap;
After that it should work (if your user SAPSR3 is unlocked).
Regards
Hi.
Could be password problem inside Oracle for the sap, or for older system user sapr3.
Try to set a new password with:
1. The Unix SIDadm user owns a table called sapuser.
You can check this with sql command:
desc ops$SIDadm.sapuser; select * from ops$SIDadm.sapuser;
If the table exist it contains the encrypted password for sapr3.(older system)
2. To set a new password for sapr3 in the database:
alter user sapr3 identified by kalle; (in sqlplus)
and as Unix user SIDadm enter command:
brconnect -u / -c -f chpass -o sapr3 -p kalle
3. Test connection R3trans -d
If the database user ops$SIDadcreaym does not exist,
typically after a database refresh,You need to create it:
Regards
Björn Malström,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This was not a problem, since your DB is not yet started by the time u specified startsap command, so it first starts checks if DB is already running if not then it starts SAPOSCOL and then DB and then up's the SAP application.
In case if your DB is up and running already u dont see that message whn u execute startsap command.
Think this clarified u.
Regards,
Raju.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My startdb.log is
quality:qasadm 6> more startdb.log
-
Thu Feb 19 10:11:50 IST 2009
LOGFILE FOR STARTING ORACLE
Trying to start QAS database ...
-
Thu Feb 19 10:11:50 IST 2009
checking required environment variables
ORACLE_HOME is >/oracle/QAS/102_64<
ORACLE_SID is >QAS<
-
Thu Feb 19 10:11:50 IST 2009
check initora
-
Thu Feb 19 10:11:50 IST 2009
check initora
-
Thu Feb 19 10:11:50 IST 2009
checking V2 connect
TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 19-FEB-2009 10:11:50
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/usr/sap/QAS/SYS/profile/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = quality) (PORT =
A = (SID = QAS) (GLOBAL_NAME = QAS.WORLD)))
OK (0 msec)
tnsping: V2 connect to QAS
-
Thu Feb 19 10:11:50 IST 2009
Connect to the database to check the database state:
R3trans: connect check finished with return code: 12
Database not available
-
Thu Feb 19 10:11:50 IST 2009
Shutdown database
First trying to shutdown the database - May be,
the database is in the nomount or mount state
-
Thu Feb 19 10:11:57 IST 2009
starting database
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 19 10:11:57 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 4714397696 bytes
Fixed Size 2050336 bytes
Variable Size 2365589216 bytes
Database Buffers 2332033024 bytes
Redo Buffers 14725120 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
-
Thu Feb 19 10:12:04 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/QAS/SYS/exe/run/startdb: Terminating with error code 12
hi,
After startsap should be created a couple of logs (trans.log and startsap.log)
please, post both
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi.
Are there more than one system running on this machine?
Which database is connected when you run R3trans -x or R3trans -x. Is this the correct one?
What else you can do is to check the profiles and the environment variables of <sid>adm. Maybe there is a wrong setting.
Check iy the listener of the database is running on the correct port!
I think standard port is something like 17421 (that is not a save info). It there are more DBs, they have to use other ports too...
regards,
Martin
Dear martin,
When I was first installing SAP . It was giving error. So I was again fresh Installed SAP . But that time i was unable to delete DVEBMGS00 . So I rename to DVEBMGS00 to DVEBMGS02. and then start installation of SAP.
I check the log.
quality:oraqas 11> more startsap_.log
Checking QAS Database
-
ABAP Database is running
Starting SAP-Collector Daemon
-
saposcol already running
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
saposcol on host quality started
Running /usr/sap/QAS/SYS/exe/run/startdb
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
saposcol already running
Running /usr/sap/QAS/SYS/exe/run/startdb
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
saposcol already running
Running /usr/sap/QAS/SYS/exe/run/startdb
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
saposcol on host quality started
Running /usr/sap/QAS/SYS/exe/run/startdb
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
saposcol already running
Running /usr/sap/QAS/SYS/exe/run/startdb
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
Starting SAP-Collector Daemon
-
saposcol already running
Running /usr/sap/QAS/SYS/exe/run/startdb
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
saposcol already running
Running /usr/sap/QAS/SYS/exe/run/startdb
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
saposcol on host quality started
Running /usr/sap/QAS/SYS/exe/run/startdb
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
saposcol already running
Running /usr/sap/QAS/SYS/exe/run/startdb
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
saposcol already running
Running /usr/sap/QAS/SYS/exe/run/startdb
/usr/sap/QAS/SYS/exe/run/startdb completed successfully
Can I delete now DVEBMGS02 now?
Thanks
Manu
Dear karan,
I am senidng my trans Log and Startdb Log.
plesae check and suggest me....what to do.
quality:qasadm 3> more trans.log
4 ETW000 R3trans version 6.14 (release 700 - 25.01.08 - 14:11:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 19.02.2009 - 11:40:46
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Thu Feb 19 11:40:46 2009 240 0.000240
4 ETW000 [dev trc ,00000] db_con_init called 31 0.000271
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 78 0.000349
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' ...
4 ETW000 76 0.000425
4 ETW000 [dev trc ,00000] Thu Feb 19 11:40:47 2009 49064 0.049489
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/QAS/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 69 0.049558
4 ETW000 [dev trc ,00000] Library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' loaded
4 ETW000 54 0.049612
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 101 0.049713
4 ETW000 [dev trc ,00000] Version of '/usr/sap/QAS/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.144)
4 ETW000 390 0.050103
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 54 0.050157
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so
4 ETW000 75 0.050232
4 ETW000 [dev trc ,00000] New connection 0 created 58 0.050290
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_o
= 255, occ = NO
4 ETW000 57 0.050347
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 113 0.050460
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 46 0.050506
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_op
= 255, occ = NO
4 ETW000 60 0.050566
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 519 0.051085
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 50 0.051135
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 7733 0.058868
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 78 0.058946
4 ETW000 [dev trc ,00000] Connecting as /@QAS on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 58 0.059004
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 96 0.059100
4 ETW000 [dev trc ,00000] 0 UTF8 1 0x60000000010789e0 0x6000000001080310 0x600000000109
88
4 ETW000 59 0.059159
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 94 0.059253
4 ETW000 [dev trc ,00000] Allocating server context handle 39 0.059292
4 ETW000 [dev trc ,00000] Attaching to DB Server QAS (con_hdl=0,svchp=0x60000000010909b8,srvhp=0x6000000001092cc8)
4 ETW000 55 0.059347
4 ETW000 [dev trc ,00000] Assigning server context 0x6000000001092cc8 to service context 0x60000000010909b8
4 ETW000 106774 0.166121
4 ETW000 [dev trc ,00000] Allocating user session handle 140 0.166261
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x60000000010909b8,srvhp=0x6000000001092cc8,usrhp=0x6000000001080b28)
4 ETW000 60 0.166321
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
4 ETW000 8531 0.174852
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 59 0.174911
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 40 0.174951
4 ETW000 [dev trc ,00000] Try to connect with default password 128 0.175079
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@QAS on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 66 0.175145
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 53 0.175198
4 ETW000 [dev trc ,00000] 0 UTF8 1 0x60000000010789e0 0x6000000001080310 0x600000000109
88
4 ETW000 51 0.175249
4 ETW000 [dev trc ,00000] Assigning username to user session 0x6000000001080b28
4 ETW000 46 0.175295
4 ETW000 [dev trc ,00000] Assigning password to user session 0x6000000001080b28
4 ETW000 88 0.175383
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x60000000010909b8,srvhp=0x6000000001092cc8,usrhp=0x6000000001080b28)
4 ETW000 60 0.175443
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=28000
4 ETW000 3442 0.178885
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x6000000001092cc8)
4 ETW000 48 0.178933
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x60000000010909b8,srvhp=0x6000000001092cc8)
4 ETW000 60 0.178993
4 ETW000 [dev trc ,00000] Deallocating server context handle 0x6000000001092cc8
4 ETW000 482 0.179475
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '28000'
4 ETW000 95 0.179570
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 28000 33 0.179603
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 28000 performing CON [dblink#5 @ 431]
4 ETW000 401 0.180004
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-28000: the account is locked [dblink#5 @ 431]
4 ETW000 100 0.180104
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"
and
STARTDB LOG
quality:qasadm 6> more startdb.log
-
Thu Feb 19 12:17:21 IST 2009
LOGFILE FOR STARTING ORACLE
Trying to start QAS database ...
-
Thu Feb 19 12:17:21 IST 2009
checking required environment variables
ORACLE_HOME is >/oracle/QAS/102_64<
ORACLE_SID is >QAS<
-
Thu Feb 19 12:17:21 IST 2009
check initora
-
Thu Feb 19 12:17:21 IST 2009
check initora
-
Thu Feb 19 12:17:21 IST 2009
checking V2 connect
TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 19-FEB-2009 12:17:21
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/usr/sap/QAS/SYS/profile/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = quality) (PORT = 1527))) (CONNECT_DAT
A = (SID = QAS) (GLOBAL_NAME = QAS.WORLD)))
OK (10 msec)
tnsping: V2 connect to QAS
-
Thu Feb 19 12:17:21 IST 2009
Connect to the database to check the database state:
R3trans: connect check finished with return code: 12
Database not available
-
Thu Feb 19 12:17:22 IST 2009
Shutdown database
First trying to shutdown the database - May be,
the database is in the nomount or mount state
-
Thu Feb 19 12:17:27 IST 2009
starting database
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 19 12:17:27 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 4714397696 bytes
Fixed Size 2050336 bytes
Variable Size 2365589216 bytes
Database Buffers 2332033024 bytes
Redo Buffers 14725120 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
-
Thu Feb 19 12:17:35 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/QAS/SYS/exe/run/startdb: Terminating with error code 12
My SAP is not starting . Please suggest.
Manu
Thanks for your reply,
I have unlock the user . SQL> alter user SAPSR3 ACCOUNT UNLOCK;
User altered.
but problem is same,
Startdb log
quality:qasadm 9> more startdb.log
-
Thu Feb 19 15:32:39 IST 2009
LOGFILE FOR STARTING ORACLE
Trying to start QAS database ...
-
Thu Feb 19 15:32:39 IST 2009
checking required environment variables
ORACLE_HOME is >/oracle/QAS/102_64<
ORACLE_SID is >QAS<
-
Thu Feb 19 15:32:39 IST 2009
check initora
-
Thu Feb 19 15:32:39 IST 2009
check initora
-
Thu Feb 19 15:32:39 IST 2009
checking V2 connect
TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 19-FEB-2009 15:32:39
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/usr/sap/QAS/SYS/profile/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = quality) (PORT = 1
A = (SID = QAS) (GLOBAL_NAME = QAS.WORLD)))
OK (0 msec)
tnsping: V2 connect to QAS
-
Thu Feb 19 15:32:39 IST 2009
Connect to the database to check the database state:
R3trans: connect check finished with return code: 12
Database not available
-
Thu Feb 19 15:32:39 IST 2009
Shutdown database
First trying to shutdown the database - May be,
the database is in the nomount or mount state
-
Thu Feb 19 15:32:47 IST 2009
starting database
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 19 15:32:47 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 4714397696 bytes
Fixed Size 2050336 bytes
Variable Size 2365589216 bytes
Database Buffers 2332033024 bytes
Redo Buffers 14725120 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
-
Thu Feb 19 15:32:55 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/QAS/SYS/exe/run/startdb: Terminating with error code 12
quality:qasadm 10>
what to do.
Thanks
manu
Hi Manu,
Start the database from the sql level..
log in as ora<SID>,
sqlplus /"as sysdba"
<startup;
After the log in as SIDadm and run startsap r3
Let me know is there any other instances are running on the same host or multiple database instances are installed?
If yes please check the listener.ora oand tnsnames.ora files of the both the instances...
Mahesh
Thanks for yours reply,
My lsnrctl is start sucessfully.
quality:oraqas 3> lsnrctl start
LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 20-FEB-2009 09:57:21
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /oracle/QAS/102_64/bin/tnslsnr: please wait...
TNSLSNR for HPUX: Version 10.2.0.2.0 - Production
System parameter file is /oracle/QAS/102_64/network/admin/listener.ora
Log messages written to /oracle/QAS/102_64/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=quality)(PORT=1527)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=QAS.WORLD))
STATUS of the LISTENER
-
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.2.0 - Production
Start Date 20-FEB-2009 09:57:21
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/QAS/102_64/network/admin/listener.ora
Listener Log File /oracle/QAS/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=quality)(PORT=1527)))
Services Summary...
Service "QAS" has 1 instance(s).
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
But WHEN I START SAP
quality:qasadm 1> startsap
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
10:05:22 20.02.2009 LOG: Effective User Id is root
***********************************************************************
This is Saposcol Version COLL 20.90 700 - v2.05 for HP-UX - 28.7.2006
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 25263) is already running .....
************************************************************************
saposcol already running
Running /usr/sap/QAS/SYS/exe/run/startdb
Trying to start QAS database ...
Log file: /home/qasadm/startdb.log
/usr/sap/QAS/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed
quality:qasadm 2>
uality:qasadm 2> R3trans -d
This is R3trans version 6.14 (release 700 - 25.01.08 - 14:11:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"
R3trans finished (0012).
BUT WHEN I START ONLY SAP
quality:qasadm 3> startsap r3
Checking QAS Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
10:07:30 20.02.2009 LOG: Effective User Id is root
***********************************************************************
This is Saposcol Version COLL 20.90 700 - v2.05 for HP-UX - 28.7.2006
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 25263) is already running .....
************************************************************************
saposcol already running
ABAP Database QAS must be started first
quality:qasadm 4>
I HAVE CHANGE THE PASSWORD VIA BRTOOLS.
quality:qasadm 4>
BR0280I BRTOOLS time stamp: 2009-02-20 10.03.54
BR0657I Input menu 59 - please check/enter input values
-
BRCONNECT options for changing password of database user
1 - BRCONNECT profile (profile) ............... [initQAS.sap]
2 - Database user/password (user) ............. [sapsr3/********]
3 ~ Database owner to change password (owner) . [sapsr3]
4 - Message language (language) ............... [E]
5 - BRCONNECT command line (command) .......... [-p initQAS.sap -l E -f chpass -o sapsr3]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2009-02-20 10.03.57
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
Its proper change.
I have checked vai SQL
SQL> desc OPS$QASadm.SAPSR3;
ERROR:
ORA-04043: object OPS$QASadm.SAPSR3 does not exist
SQL> select * from ops$QASadm.sapsr3;
select * from ops$QASadm.sapsr3
What other option should i checked and How?
Thanks
Manu
Hi Manu,
Is DEV & QAS instances are running on the same host. If yes check the listner.ora and tnsnames.ora files in the /oracle/SID/102_64/network/admin/ for both DEV and QAS. Compare both the Listener port nos, port no's has to different for each of the instances.
Try starting Database using sqlplus / as sysdba and startup command.
Thanks for your reply,
I have checked users in Oracle.
QL> SELECT username, lock_date, account_status expired_date from dba_users;
USERNAME LOCK_DATE EXPIRED_DATE
-
-
-
OPS$ORAPRD OPEN
OPS$SAPSERVICEPRD OPEN
OPS$PRDADM OPEN
SYS OPEN
SYSTEM OPEN
SAPSR3 OPEN
OUTLN 02-NOV-07 LOCKED
TSMSYS 02-NOV-07 EXPIRED & LOCKED
DIP 02-NOV-07 EXPIRED & LOCKED
DBSNMP 02-NOV-07 EXPIRED & LOCKED
10 rows selected.
In this It is showing all my PRD users. Because I have done clonning.
I thing I should change following user
OPS$ORAPRD to OPS$ORAQAS
OPS$SAPSERVICEPRD to OPS$SAPSERVICEQAS
OPS$PRDADM to OPS$QASADM
is it OK . if yes then How to change these user.in oracle.
Thanks
manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.