Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL Error 12500 and TNS error

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
Not what you were looking for? View more on this topic or Ask a question