cancel
Showing results for 
Search instead for 
Did you mean: 

Error connecting Application server to CI Server

0 Kudos

Dear All,

I Installed one Application server to my existing CI Server 4.6C Oracle 8.1.7

I installed Oracle client as per note 303238 which say to copy the client car file from Kernel cd and uncar it in oracle home /oracle/PRD and ajust the env form sidadm and orasid all as per the document, when i run R3trans -x in trans.log file i get following error

4 ETW000 R3trans version 6.05 (release 46D - 12.07.06 - 16:40:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 date&time : 15.02.2007 - 16:52:34

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [developertra,00000] Thu Feb 15 16:52:34 2007 228 0.000228

4 ETW000 [developertra,00000] db_con_init called 14 0.000242

4 ETW000 [developertra,00000] create_con (con_name=R/3) 47 0.000289

4 ETW000 [developertra,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.sl' ...

4 ETW000 74 0.000363

4 ETW000 [developertra,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.sl), hdl 0

4 ETW000 9623 0.009986

4 ETW000 [developertra,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.sl' loaded

4 ETW000 23 0.010009

4 ETW000 [developertra,00000] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.sl

4 ETW000 47 0.010056

4 ETW000 [developertra,00000] Version of library '/usr/sap/PRD/SYS/exe/run/dboraslib.sl' is "46D.00", patchlevel (0.2186)

4 ETW000 208 0.010264

4 ETW000 [developertra,00000] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.sl

4 ETW000 27 0.010291

4 ETW000 [developertra,00000] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.sl

4 ETW000 53 0.010344

4 ETW000 [developertra,00000] New connection 0 created 24 0.010368

4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 80 0.010448

4 ETW000 [developertra,00000] find_con found the following connection for reuse:

4 ETW000 21 0.010469

4 ETW000 [developertra,00000] Got ORACLE_HOME=/oracle/PRD from environment 545 0.011014

4 ETW000 [developertra,00000] -->oci_initialize 28 0.011042

4 ETW000 [developertra,00000] Got ORACLE_SID=PRD from environment 53 0.011095

4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 39 0.011134

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's password 21 0.011155

4 ETW000 [developertra,00000] Connecting as /@PRD on connection 0 ... 21 0.011176

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='PRD') 33 0.011209

4 ETW000 [developertra,00000] Thu Feb 15 16:52:35 2007 169028 0.180237

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12537 27 0.180264

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537'

4 ETW000 27 0.180291

4 ETW000 [developertra,00000] Try to connect with default password 16 0.180307

4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@PRD on connection 0 ...

4 ETW000 23 0.180330

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='PRD')

4 ETW000 22 0.180352

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12537 19960 0.200312

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12537'

4 ETW000 30 0.200342

I also added in services file orasrv 1527/tcp oracle but no luck.

Is ther any thing i need to insert in listerner file for client server

I copied DB server Listerner file to client server

Can any one help

Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

hi!

take a look at this thread, perhaps it will help you out.

http://www.erpgenie.com/phpBB2/viewtopic.php?p=32391&sid=5253696f6bb799b84c0bba250b4d06a0

Former Member
0 Kudos

Check your TNSNAMES.ORA file.

This should point to your Database.

Listener only runs on DB Server, not on client.

You may also install tools, Net Manager or Net Assistant from Oracle CDs and try to configure connection to the Database.

It is easy, give it a try.