SQL Error 12500 and TNS error

[Former Member]

I am installing an R/3 4.7 system on windows/oracle 9.2.0.3. As it is loading the export files, it is giving me an error.

***LOG BY2=> sql error 12500 performing CON [dblink#1 @ 419] [dblink 0419 ]

***LOG BY0=> ORA-12500: TNS:listener failed to start a dedicated server process [dblink#1 @ 419] [dblink 0419 ]

(DB) ERROR: db_connect rc = 256

DbSl Trace: Logon as OPS$-user to get SAPDEV's password

DbSl Trace: Connecting as /@DEV on connection 0 ...

DbSl Trace: Attaching to DB Server DEV (con_hdl=0,svchp=030D61C4,svrhp=030F1A38)

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12500

DbSl Trace: CONNECT failed with sql error '12500'

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPDEV/<pwd>@DEV on connection 0 ...

DbSl Trace: Attaching to DB Server DEV (con_hdl=0,svchp=030D61C4,svrhp=0311B838)

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12500

DbSl Trace: CONNECT failed with sql error '12500'

(DB) ERROR: DbSlErrorMsg rc = 99

C:\usr\sap\DEV\SYS\exe\run/R3load.exe: job finished with 1 error(s)

C:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20110510162131

I also notice an error in the sqlnet.log:

Fatal NI connect error 12546, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracledev)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=dev)(CID=(PROGRAM=C:\oracle\ora92\bin\oradim.exe)(HOST=UPTRACK)(USER=SYSTEM))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 9.2.0.3.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.3.0 - Production

Time: 10-MAY-2011 16:08:40

Tracing not turned on.

Tns error struct:

nr err code: 0

ns main err code: 12546

TNS-12546: TNS:permission denied

ns secondary err code: 12560

nt main err code: 516

TNS-00516: Permission denied

nt secondary err code: 5

nt OS err code: 0

I've read the SAP notes 95061, 583861 and others (403004, 437362).

Please let me know if anyone else had has this problem and were able to resolve it.

thanks,

Peggy

[Former Member]

Thank you... I am closing this message.

[Former Member]

Can R/3 enterprise 4.7 run on Oracle 10.2?

thanks,

Peggy

[markus_doehr2]

> Can R/3 enterprise 4.7 run on Oracle 10.2?

Yes, see

Note 529076 - INST: SAP R/3 Enterprise 4.70 on Windows: Oracle

But Oracle 10.2 is running out of (general) support at 31st of july this year also.

but you can use Oracle 11:

Note 1478351 - Oracle 11g Support on UNIX: 6.40-Based SAP Systems

Markus

[markus_doehr2]

> I am installing an R/3 4.7 system on windows/oracle 9.2.0.3.

I would have installed the latest available patchset (9.2.0.8) plus the latest patches to avoid any known issues. 9.2.0.3 is really ancient.

Markus

[Former Member]

Here are the results of R3trans:

4 ETW000 R3trans version 6.08 (release 620 - 04.02.03 - 14:54:00).

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

4 ETW000

4 ETW000 date&time : 11.05.2011 - 05:09:08

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d -v

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

4 ETW000 [dev trc ,00000] Wed May 11 05:09:11 2011 11118 0.011118

4 ETW000 [dev trc ,00000] db_con_init called 254 0.011372

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 109 0.011481

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ...

4 ETW000 77 0.011558

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0

4 ETW000 11810 0.023368

4 ETW000 [dev trc ,00000] using "C:\usr\sap\DEV\SYS\exe\run\dboraslib.dll"

4 ETW000 23 0.023391

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded

4 ETW000 14 0.023405

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 16 0.023421

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "620.02", patchlevel (0.549)

4 ETW000 323 0.023744

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 15 0.023759

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 67 0.023826

4 ETW000 [dev trc ,00000] New connection 0 created 57 0.023883

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 20 0.023903

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3)

4 ETW000 14 0.023917

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

4 ETW000 13 0.023930

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 16 0.023946

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=C:\oracle\ora92 from environment

4 ETW000 5130 0.029076

4 ETW000 [dev trc ,00000] -->oci_initialize 43 0.029119

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC

4 ETW000 54312 0.083431

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPDEV's password

4 ETW000 90 0.083521

4 ETW000 [dev trc ,00000] Connecting as /@DEV on connection 0 ...

4 ETW000 14 0.083535

4 ETW000 [dev trc ,00000] Allocating service context handle

4 ETW000 6543 0.090078

4 ETW000 [dev trc ,00000] Allocating server context handle

4 ETW000 45 0.090123

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=002BD784,svrhp=03B53F84)

4 ETW000 129 0.090252

4 ETW000 [dev trc ,00000] Wed May 11 05:09:12 2011 1068706 1.158958

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

4 ETW000 28 1.158986

4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 130 1.159116

4 ETW000 [dev trc ,00000] Try to connect with default password

4 ETW000 37 1.159153

4 ETW000 [dev trc ,00000] Connecting as SAPDEV/<pwd>@DEV on connection 0 ...

4 ETW000 15 1.159168

4 ETW000 [dev trc ,00000] Allocating server context handle

4 ETW000 14 1.159182

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=002BD784,svrhp=03B58040)

4 ETW000 29 1.159211

4 ETW000 [dev trc ,00000] Wed May 11 05:09:13 2011 1091583 2.250794

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

4 ETW000 29 2.250823

4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 17 2.250840

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12541 performing CON [dblink#1 @ 419]

4 ETW000 5558 2.256398

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#1 @ 419]

4 ETW000 16 2.256414

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"

[Former Member]

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracledev)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA_**=(SID=dev)*_(*CID=(PROGRAM=C:\oracle\ora92\bin\oradim.exe)(HOST=UPTRACK)(USER=SYSTEM))))

can you check SID?? here its mentioned as dev..i guess it should be beq

Edited by: mohit gupta on May 11, 2011 7:43 AM

[Former Member]

Hello ,

Please execute R3trans -d and paste the log in trans.log.

Regards ,

Sibashis

[Former Member]

Hi Peggy,

Take the backup of your "tnsnames.ora" profile and change the configuration, as below;

<SID>.WORLD=
  (DESCRIPTION =
    (SDU = 32768)
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = SAP.WORLD)
          (PROTOCOL = TCP)
          (HOST = <hostname>)
          (PORT = <port>)
        )
    )
    (CONNECT_DATA =
       (SID = <SID>)
       (GLOBAL_NAME = <SID>.WORLD)
    )
  )

Then, restart the listener.

Best regards,

Orkun Gedik

[Former Member]

TNS-12546: TNS:permission denied
CONNECT failed with sql error '12500'

This issue seems to be with TNS error.I believe there is some issue with tns file. Please have a look at below SAP note::

Note 437362 - Composite note ORA-12500

Thanks..

Mohit