- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- OCI or SQL return code 12541 TNS:no:listner
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
OCI or SQL return code 12541 TNS:no:listner
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 09-16-2011 5:50 PM
Dear Experts
I am installing solution manager 7.0ehp1 on RHEL5.4 64bit with Oracle 10G.I am getting this error when trying to connect to DB using R3trans -d this installation is still not complete stuck on start instance phase.I am pasting the trans.log and tnsnames.ora,sqlnet.ora files for your refernece.
Trans.log 4 ETW000 R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 15.09.2011 - 23:44:01
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Thu Sep 15 23:44:01 2011 235 0.000235
4 ETW000 [dev trc ,00000] db_con_init called 41 0.000276
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 85 0.000361
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/RIC/SYS/exe/run/dboraslib.so' ...
4 ETW000 61 0.000422
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/RIC/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 18958 0.019380
4 ETW000 [dev trc ,00000] Library '/usr/sap/RIC/SYS/exe/run/dboraslib.so' loaded
4 ETW000 46 0.019426
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/RIC/SYS/exe/run/dboraslib.so
4 ETW000 61 0.019487
4 ETW000 [dev trc ,00000] Version of '/usr/sap/RIC/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.25)
4 ETW000 119 0.019606
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/RIC/SYS/exe/run/dboraslib.so
4 ETW000 41 0.019647
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/RIC/SYS/exe/run/dboraslib.so
4 ETW000 69 0.019716
4 ETW000 [dev trc ,00000] New connection 0 created 48 0.019764
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 61 0.019825
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 44 0.019869
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 39 0.019908
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 44 0.019952
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 610 0.020562
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 46 0.020608
4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 4285 0.024893
4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'
4 ETW000 88 0.024981
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 31 0.025012
4 ETW000 [dev trc ,00000] Connecting as /@RIC on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
4 ETW000 43 0.025055
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 59 0.025114
4 ETW000 [dev trc ,00000] 0 UTF8 0 0x1c92fa30 0x1c937480 0x1c947b78
4 ETW000 81 0.025195
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 53 0.025248
4 ETW000 [dev trc ,00000] Allocating server context handle 33 0.025281
4 ETW000 [dev trc ,00000] Attaching to DB Server RIC (con_hdl=0,svchp=0x1c947aa8,srvhp=0x1c94ae08)
4 ETW000 89 0.025370
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541
4 ETW000 4582 0.029952
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 47 0.029999
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 41 0.030040
4 ETW000 [dev trc ,00000] Try to connect with default password 116 0.030156
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@RIC on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
4 ETW000 46 0.030202
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 49 0.030251
4 ETW000 [dev trc ,00000] 0 UTF8 0 0x1c92fa30 0x1c937480 0x1c947b78
4 ETW000 44 0.030295
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x1c94ae08)
4 ETW000 42 0.030337
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1c947aa8,srvhp=0x1c94ae08)
4 ETW000 44 0.030381
4 ETW000 [dev trc ,00000] Deallocating server context handle 0x1c94ae08 54 0.030435
4 ETW000 [dev trc ,00000] Allocating server context handle 55 0.030490
4 ETW000 [dev trc ,00000] Attaching to DB Server RIC (con_hdl=0,svchp=0x1c947aa8,srvhp=0x1c94ae08)
4 ETW000 58 0.030548
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541
4 ETW000 1332 0.031880
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 45 0.031925
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 28 0.031953
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12541 performing CON [dblink#3 @ 431]
4 ETW000 184 0.032137
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#3 @ 431]
4 ETW000 42 0.032179
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RIC'"
- SAP Managed Tags:
- SAP Solution Manager
Accepted Solutions (1)
Accepted Solutions (1)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello,
Did you try to start the listener manually yet ?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Answers (9)
Answers (9)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Closing Thread
Thanks to all for the help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Thanks guys for all the support will start a fresh.
Closing this thread now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
/usr/sap/RIC/SYS/exe/run/R3load: START OF LOG: 20110914232349
/usr/sap/RIC/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP
/usr/sap/RIC/SYS/exe/run/R3load: version R7.01/V1.4 [UNICODE]
Compiled Feb 24 2009 21:39:36
/usr/sap/RIC/SYS/exe/run/R3load -ctf I /sapdump/51036442_2/51036442_2/DATA_UNITS/EXP4/DATA/SAPSSEXC.STR /tmp/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/DDLORA.TPL SAPSSEXC.TSK ORA -l SAPSSEXC.log
/usr/sap/RIC/SYS/exe/run/R3load: job completed
/usr/sap/RIC/SYS/exe/run/R3load: END OF LOG: 20110914232349
/usr/sap/RIC/SYS/exe/run/R3load: START OF LOG: 20110914232349
/usr/sap/RIC/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP
/usr/sap/RIC/SYS/exe/run/R3load: version R7.01/V1.4 [UNICODE]
Compiled Feb 24 2009 21:39:36
/usr/sap/RIC/SYS/exe/run/R3load -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.log -stop_on_error
DbSl Trace: ORA-1403 when accessing table SAPUSER
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) INFO: WDY_WINDOWT~0 created #20110915004252
(DB) INFO: disconnected from DB
/usr/sap/RIC/SYS/exe/run/R3load: job completed
/usr/sap/RIC/SYS/exe/run/R3load: END OF LOG: 20110915004252
Would it be better to go for a fresh installation to avoid any future problems because i don't have much time.
One more thing that i need to ask where can i find SAPSSEXC.TSK on my Oracle pathch cd.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Well on the front end i did not get any warnings or errors however their are few logs that suggest otherwise.I am pastings those logs please advice as i think there might be some issue with my export cd's.
/usr/sap/RIC/SYS/exe/run/R3load: START OF LOG: 20110914232349
/usr/sap/RIC/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP
/usr/sap/RIC/SYS/exe/run/R3load: version R7.01/V1.4 [UNICODE]
Compiled Feb 24 2009 21:39:36
/usr/sap/RIC/SYS/exe/run/R3load -ctf I /sapdump/51036442_1/51036442_1/DATA_UNITS/EXP2/DATA/DD03L.STR /tmp/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/DDLORA_LRG.TPL DD03L.TSK ORA -l DD03L.log
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
/usr/sap/RIC/SYS/exe/run/R3load: job completed
/usr/sap/RIC/SYS/exe/run/R3load: END OF LOG: 20110914232349
/usr/sap/RIC/SYS/exe/run/R3load: START OF LOG: 20110914232349
/usr/sap/RIC/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP
/usr/sap/RIC/SYS/exe/run/R3load: version R7.01/V1.4 [UNICODE]
Compiled Feb 24 2009 21:39:36
/usr/sap/RIC/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: ORA-1403 when accessing table SAPUSER
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) INFO: DD03L created #20110914232351
(IMP) INFO: import of DD03L completed (1773953 rows) #20110914233224
(DB) INFO: DD03L~0 created #20110914233352
(DB) INFO: DD03L~1 created #20110914233942
(DB) INFO: DD03L~2 created #20110914234126
(DB) INFO: DD03L~3 created #20110914234321
(DB) INFO: DD03L~4 created #20110914234507
(DB) INFO: DD03L~5 created #20110914234731
(DB) INFO: DD03L~6 created #20110914234837
(DB) INFO: DD03L~7 created #20110914234936
(DB) INFO: disconnected from DB
/usr/sap/RIC/SYS/exe/run/R3load: job completed
/usr/sap/RIC/SYS/exe/run/R3load: END OF LOG: 20110914234937
Environment for Oracle
TERM=xterm
DISPLAY=:0.0
HOME=/oracle/RIC
SHELL=/bin/csh
USER=oraric
LOGNAME=oraric
PATH=/oracle/RIC/102_64/bin:.:/oracle/RIC:/usr/sap/RIC/SYS/exe/run:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin
HOSTTYPE=x86_64-linux
VENDOR=unknown
OSTYPE=linux
MACHTYPE=x86_64
SHLVL=1
PWD=/oracle/RIC
GROUP=dba
HOST=ashish
MAIL=/var/spool/mail/oraric
HOSTNAME=ashish
INPUTRC=/etc/inputrc
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:.cmd=00;32:.exe=00;32:.com=00;32:.btm=00;32:.bat=00;32:.sh=00;32:.csh=00;32:.tar=00;31:.tgz=00;31:.arj=00;31:.taz=00;31:.lzh=00;31:.zip=00;31:.z=00;31:.Z=00;31:.gz=00;31:.bz2=00;31:.bz=00;31:.tz=00;31:.rpm=00;31:.cpio=00;31:.jpg=00;35:.gif=00;35:.bmp=00;35:.xbm=00;35:.xpm=00;35:.png=00;35:.tif=00;35:
G_BROKEN_FILENAMES=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
SAPSYSTEMNAME=RIC
DIR_LIBRARY=/usr/sap/RIC/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/RIC/SYS/exe/run:/oracle/RIC/102_64/lib
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=RIC
dbs_ora_schema=SAPSR3
ORACLE_SID=RIC
DB_SID=RIC
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/RIC/102_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/RIC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Thanks for the reply this is the trans.log after the db and listner both were up
4 ETW000 R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 17.09.2011 - 18:48:08
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Sat Sep 17 18:48:08 2011 215 0.000215
4 ETW000 [dev trc ,00000] db_con_init called 36 0.000251
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 81 0.000332
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/RIC/SYS/exe/run/dboraslib.so' ...
4 ETW000 67 0.000399
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/RIC/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 16557 0.016956
4 ETW000 [dev trc ,00000] Library '/usr/sap/RIC/SYS/exe/run/dboraslib.so' loaded
4 ETW000 45 0.017001
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/RIC/SYS/exe/run/dboraslib.so
4 ETW000 61 0.017062
4 ETW000 [dev trc ,00000] Version of '/usr/sap/RIC/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.25)
4 ETW000 104 0.017166
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/RIC/SYS/exe/run/dboraslib.so
4 ETW000 42 0.017208
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/RIC/SYS/exe/run/dboraslib.so
4 ETW000 70 0.017278
4 ETW000 [dev trc ,00000] New connection 0 created 41 0.017319
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 60 0.017379
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 42 0.017421
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 39 0.017460
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 44 0.017504
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.4.0' 571 0.018075
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 44 0.018119
4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 3734 0.021853
4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'
4 ETW000 55 0.021908
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 31 0.021939
4 ETW000 [dev trc ,00000] Connecting as /@RIC on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
4 ETW000 43 0.021982
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 58 0.022040
4 ETW000 [dev trc ,00000] 0 UTF8 0 0x1c7553e0 0x1c75ce80 0x1c76d578
4 ETW000 81 0.022121
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 50 0.022171
4 ETW000 [dev trc ,00000] Allocating server context handle 33 0.022204
4 ETW000 [dev trc ,00000] Attaching to DB Server RIC (con_hdl=0,svchp=0x1c76d4a8,srvhp=0x1c7705f8)
4 ETW000 97 0.022301
4 ETW000 [dev trc ,00000] Sat Sep 17 18:48:09 2011 46388 0.068689
4 ETW000 [dev trc ,00000] Assigning server context 0x1c7705f8 to service context 0x1c76d4a8
4 ETW000 52 0.068741
4 ETW000 [dev trc ,00000] Allocating user session handle 83 0.068824
4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x1c76d4a8, srvhp=0x1c7705f8, usrhp=0x1c7afe40)
4 ETW000 67 0.068891
4 ETW000 [dev trc ,00000] Assigning user session 0x1c7afe40 to service context 0x1c76d4a8
4 ETW000 12084 0.080975
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=53, stmth_p=0x1c77a1a8)
4 ETW000 97 0.081072
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1); END;
4 ETW000 26 0.081098
4 ETW000 [dev trc ,00000] CbApplInfoGet() failed! Ignore, but uninstall callback to avoid more erroneous calls
4 ETW000 145 0.081243
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=54, stmth_p=0x1c77b200)
4 ETW000 23 0.081266
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;
4 ETW000 23 0.081289
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x1c77b200)
4 ETW000 1103 0.082392
4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2
4 ETW000 26 0.082418
4 ETW000 [dev trc ,00000] Connected to session 139. 620 0.083038
4 ETW000 [dev trc ,00000] Now '/@RIC' is connected: con_hdl=0, nls_hdl=0, session_id=139.
4 ETW000 31 0.083069
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x1c77b200)
4 ETW000 31 0.083100
4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY
4 ETW000 32 0.083132
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x1c77b200)
4 ETW000 302 0.083434
4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)
4 ETW000 25 0.083459
4 ETW000 [dev trc ,00000] OCI-call failed with -1=OCI_ERROR 1558 0.085017
4 ETW000 [dev trc ,00000] SQL error 942: 'ORA-00942: table or view does not exist'
4 ETW000 38 0.085055
4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-942 when accessing table SAPUSER
4 ETW000 45 0.085100
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 22 0.085122
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 56 0.085178
4 ETW000 [dev trc ,00000] Rolling back transaction ... 29 0.085207
4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x1c76d4a8,usrhp=0x1c7afe40)
4 ETW000 222 0.085429
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 604 0.086033
4 ETW000 [dev trc ,00000] Try to connect with default password 20 0.086053
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@RIC on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
4 ETW000 25 0.086078
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 27 0.086105
4 ETW000 [dev trc ,00000] 0 UTF8 0 0x1c7553e0 0x1c75ce80 0x1c76d578
4 ETW000 24 0.086129
4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0x1c7afe40
4 ETW000 30 0.086159
4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0x1c7afe40
4 ETW000 40 0.086199
4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0x1c76d4a8, srvhp=0x1c7705f8, usrhp=0x1c7afe40)
4 ETW000 235 0.086434
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017
4 ETW000 4167 0.090601
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 27 0.090628
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 15 0.090643
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 431]
4 ETW000 106 0.090749
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 431]
4 ETW000 24 0.090773
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RIC'"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello,
So here is the problem,
SQL error 942: 'ORA-00942: table or view does not exist'
ORA-942 when accessing table SAPUSER
ORA-01017: invalid username/password; logon denied
You will have to go through the Note 400241 - Problems with ops$ or sapr3 connect to Oracle. Via 'sqlplus' try to check whether the table sapuser exist or not. Re-check all the environment variables for oracle.
Did you face any other problem before in any previous phases in this installation ? It weird that installation couldn't setup OPS$ mechanism yet.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
This is the trans.log , please suggest
4 ETW000 R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 15.09.2011 - 23:44:01
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Thu Sep 15 23:44:01 2011 235 0.000235
4 ETW000 [dev trc ,00000] db_con_init called 41 0.000276
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 85 0.000361
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/RIC/SYS/exe/run/dboraslib.so' ...
4 ETW000 61 0.000422
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/RIC/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 18958 0.019380
4 ETW000 [dev trc ,00000] Library '/usr/sap/RIC/SYS/exe/run/dboraslib.so' loaded
4 ETW000 46 0.019426
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/RIC/SYS/exe/run/dboraslib.so
4 ETW000 61 0.019487
4 ETW000 [dev trc ,00000] Version of '/usr/sap/RIC/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.25)
4 ETW000 119 0.019606
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/RIC/SYS/exe/run/dboraslib.so
4 ETW000 41 0.019647
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/RIC/SYS/exe/run/dboraslib.so
4 ETW000 69 0.019716
4 ETW000 [dev trc ,00000] New connection 0 created 48 0.019764
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 61 0.019825
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 44 0.019869
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 39 0.019908
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 44 0.019952
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 610 0.020562
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 46 0.020608
4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 4285 0.024893
4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'
4 ETW000 88 0.024981
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 31 0.025012
4 ETW000 [dev trc ,00000] Connecting as /@RIC on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
4 ETW000 43 0.025055
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 59 0.025114
4 ETW000 [dev trc ,00000] 0 UTF8 0 0x1c92fa30 0x1c937480 0x1c947b78
4 ETW000 81 0.025195
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 53 0.025248
4 ETW000 [dev trc ,00000] Allocating server context handle 33 0.025281
4 ETW000 [dev trc ,00000] Attaching to DB Server RIC (con_hdl=0,svchp=0x1c947aa8,srvhp=0x1c94ae08)
4 ETW000 89 0.025370
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541
4 ETW000 4582 0.029952
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 47 0.029999
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 41 0.030040
4 ETW000 [dev trc ,00000] Try to connect with default password 116 0.030156
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@RIC on connection 0 (nls_hdl 0) ... (dbsl 700 151208)
4 ETW000 46 0.030202
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 49 0.030251
4 ETW000 [dev trc ,00000] 0 UTF8 0 0x1c92fa30 0x1c937480 0x1c947b78
4 ETW000 44 0.030295
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x1c94ae08)
4 ETW000 42 0.030337
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1c947aa8,srvhp=0x1c94ae08)
4 ETW000 44 0.030381
4 ETW000 [dev trc ,00000] Deallocating server context handle 0x1c94ae08 54 0.030435
4 ETW000 [dev trc ,00000] Allocating server context handle 55 0.030490
4 ETW000 [dev trc ,00000] Attaching to DB Server RIC (con_hdl=0,svchp=0x1c947aa8,srvhp=0x1c94ae08)
4 ETW000 58 0.030548
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541
4 ETW000 1332 0.031880
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 45 0.031925
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 28 0.031953
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12541 performing CON [dblink#3 @ 431]
4 ETW000 184 0.032137
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#3 @ 431]
4 ETW000 42 0.032179
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RIC'"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Thanks for the quick reply.
yes i am able to start and stop listner manually even the DB as well how ever when i do R3trans -d i get return code 12 which indicates an error or when i continue with the installation it is not able to connect to the DB because of which it is not able to start or stop DB.The installation then gives error every time.I even tried to change the TNS_ADMIN env variable to /oracle/SID/102_64/network/admin and then try still no joy.
Thanks for the reply paul
However i am using linux 64 bit not windows platform.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Paul_Babier
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello
The Oracle Listener Service may not have started.
In Windows it is in your Service MMC
Something like:
OracleOraDb911.g_HOME1_TSNListener
Regards,
Paul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
tnsnames.ora
################
Filename......: tnsnames.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#1 $
################
RIC.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = ashish)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = RIC)
(GLOBAL_NAME = RIC.WORLD)
)
)
Listner.ora
################
Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#1 $
################
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = RIC.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = RIC)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = ashish)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = RIC)
(ORACLE_HOME = /oracle/RIC/102_64)
)
)
SqlNet.ora
################
Filename......: sqlnet.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/SQLNET.ORA#1 $
################
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
NAMES.DEFAULT_DOMAIN = WORLD
05.01.06 unsorported parameter now
#NAME.DEFAULT_ZONE = WORLD
05.01.06 set the default to 10
SQLNET.EXPIRE_TIME = 10
05.01.06 set to default
#TCP.NODELAY=YES
05.01.06 set to 32768
DEFAULT_SDU_SIZE=32768
Hoping for a quick response thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Enabling Support for Existing CAP Projects in SAP Build Code in Technology Blogs by Members
- Re Generate Co files and data files in Technology Q&A
- Convert multiple xml's into single Xlsx(MS Excel) using groovy script in Technology Blogs by Members
- SAP B1 Service layer: windows service permissions in Technology Q&A
- Error getting value from 'ReadTimeout' in Technology Q&A
| User | Count |
|---|---|
| 93 | |
| 10 | |
| 10 | |
| 9 | |
| 9 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.