on 06-08-2009 9:41 AM
hi all,
our solution manager is installed on a window server.it was shut down for a regular maintenance.now when i'm starting it again its not starting.it shows "waiting for central instance SMS smsandbox01 01 to finish startup"..
with R3trans -d following error comes;
This is R3trans version 6.14 (release 700 - 24.04.08 - 14:09:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SMS'"
R3trans finished (0012).
please tell me how to proceed..i'm a fresher.
Login with <SIDADM> user into Windows and go to command prompt and execute
R3trans -d and then check the trans.log file it will tell you exact error.
Regards,
Subhash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the trans.log file shows following:
4 ETW000 R3trans version 6.14 (release 700 - 24.04.08 - 14:09:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 08.06.2009 - 14:40:21
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] Mon Jun 08 14:40:23 2009 0 0.000000
4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 1870 0.001870
4 ETW000 [dev trc ,00000] using "D:\usr\sap\SMS\SYS\exe\uc\NTI386\dboraslib.dll"
4 ETW000 56 0.001926
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 32 0.001958
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 49 0.002007
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.158)
4 ETW000 3779 0.005786
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 52 0.005838
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 70 0.005908
4 ETW000 [dev trc ,00000] New connection 0 created 48 0.005956
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , ti
meout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 163 0.006119
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 177 0.006296
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 52 0.006348
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , tim
eout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 63 0.006411
4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or
4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 1356 0.007767
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 22237 0.030004
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 38 0.030042
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 10640 0.040682
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 34 0.040716
4 ETW000 [dev trc ,00000] Connecting as /@SMS on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
4 ETW000 43 0.040759
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp Err
Hp ErrHpBatch
4 ETW000 308 0.041067
4 ETW000 [dev trc ,00000] 0 UTF8 1 0365D1E0 036628
14 0366209C
4 ETW000 165 0.041232
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 594 0.041826
4 ETW000 [dev trc ,00000] Allocating server context handle 49 0.041875
4 ETW000 [dev trc ,00000] Attaching to DB Server SMS (con_hdl=0,svchp=03661FE8,srvhp=0367385C)
4 ETW000 101 0.041976
4 ETW000 [dev trc ,00000] Mon Jun 08 14:40:39 2009 15544199 15.586175
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12560
4 ETW000 60 15.586235
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12560'
4 ETW000 55 15.586290
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12560 39 15.586329
4 ETW000 [dev trc ,00000] Try to connect with default password 108 15.586437
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@SMS on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
4 ETW000 56 15.586493
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp Err
Hp ErrHpBatch
4 ETW000 58 15.586551
4 ETW000 [dev trc ,00000] 0 UTF8 1 0365D1E0 036628
14 0366209C
4 ETW000 64 15.586615
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0367385C) 37 15.586652
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=03661FE8,srvhp=0367385C)
4 ETW000 55 15.586707
4 ETW000 [dev trc ,00000] Deallocating server context handle 0367385C 50 15.586757
4 ETW000 [dev trc ,00000] Allocating server context handle 50 15.586807
4 ETW000 [dev trc ,00000] Attaching to DB Server SMS (con_hdl=0,svchp=03661FE8,srvhp=0367385C)
4 ETW000 66 15.586873
4 ETW000 [dev trc ,00000] Mon Jun 08 14:40:54 2009 15545689 31.132562
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12560
4 ETW000 42 31.132604
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12560'
4 ETW000 47 31.132651
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12560 34 31.132685
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12560 performing CON [dblink#5 @ 431]
4 ETW000 764 31.133449
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12560: TNS:protocol adapter error [dblink#5 @ 431]
4 ETW000 50 31.133499
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SMS'"
thanx a lot to everybody...restarting my server again sorted out everything.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
start your listner if it not started already
> lsnrctl status
> lsnrctl start
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the listener is already started.and the database is in open status.
lsnrctl status shows;
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SMS.WORLD))
STATUS of the LISTENER
-
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Production
Start Date 06-JUN-2009 20:46:58
Uptime 1 days 18 hr. 7 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\SMS\102\network\admin\listener.ora
Listener Log File E:\oracle\SMS\102\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\SMS.WORLDipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\SMSipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SMSANDBOX01)(PORT=1527)))
Services Summary...
Service "SMS" has 1 instance(s).
Instance "SMS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Please check this link also. This might helpful
Regards,
Subhash
hi Priya
pls chekc your DB connectivity
Thx
Mysterious
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.