Database: > ORA-12154: TNS:could not resolve service name

[LeonardoAraujo]

I've just finished installation of Webas 640 for IDES 2004 and I am about to start post install activities. I cant start the system.

I get an error in STRDBS.CMD (COULD NOT BE STARTED)

In SAPMMC I get the following sequence of errors:

1 - WARNING Database: SQL error 12154 occurred (possible network problems?). Work process is stopped

2 - ERROR Database: Database error 12154 at CON

3 - Database: > ORA-12154: TNS:could not resolve service name

As per OSS notes, I've checked the system variables, but It looks fine.

Here is what I have:

Running on Win XP PRO SP2

System Variables:

SYSID: IDS

DBS_ORA_SCHEMA: SAPIDS

dbs_ora_tnsname: IDS

SAPDATA_HOME: E:\ORACLE\IDS

SAPLOCALHOST: SERVER2

ORACLE_SYSID: IDS

PATH: G:\usr\sap\IDS\SYS\exe\run

E:\ORACLE\IDS\920\jre\1.4.2\bin\client;E:\ORACLE\IDS\920\jre\1.4.2\bin;E:\ORACLE\IDS\920\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem

NLS_LANG: AMERICAN_AMERICA.WE8DEC

Oraclehome:E:\ORACLE\IDS\920

DBMS_TYPE: ORA

Here is the dump of SQLNET.ORA:

1. SQLNET.ORA Network Configuration File: E:\ORACLE\IDS\920\network\admin\sqlnet.ora

2. Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

Here is the dump of my listner:

1. LISTENER.ORA Network Configuration File: E:\ORACLE\IDS\920\network\admin\listener.ora

2. Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER2)(PORT = 1521))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = E:\ORACLE\IDS\920)

(PROGRAM = extproc)

)

)

Any help is greatly appreciated.

Message was edited by: Leonardo De Araujo

[Former Member · Accepted solution]

Hi Leonardo,

Can you supply a copy of your listener.log?

There sould be some more info about the error there.

Regards,

Alexander

[LeonardoAraujo · Accepted solution]

here it is:

TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 18-FEB-2006 18:16:31

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is E:\ORACLE\IDS\920\network\admin\listener.ora

Log messages written to E:\ORACLE\IDS\920\network\log\listener.log

Trace information written to E:\ORACLE\IDS\920\network\trace\listener.trc

Trace level is currently 0

Started with pid=2036

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\EXTPROC0ipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SERVER2)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

18-FEB-2006 18:16:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Leonardo))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * status * 0

TNSLSNR for 32-bit Windows: Version 9.2.0.6.0 - Production on 19-FEB-2006 09:16:40

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is E:\ORACLE\IDS\920\network\admin\listener.ora

Log messages written to E:\ORACLE\IDS\920\network\log\listener.log

Trace information written to E:\ORACLE\IDS\920\network\trace\listener.trc

Trace level is currently 0

Started with pid=1600

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\EXTPROC0ipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SERVER2)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

TNSLSNR for 32-bit Windows: Version 9.2.0.6.0 - Production on 20-FEB-2006 13:29:16

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is E:\ORACLE\IDS\920\network\admin\listener.ora

Log messages written to E:\ORACLE\IDS\920\network\log\listener.log

Trace information written to E:\ORACLE\IDS\920\network\trace\listener.trc

Trace level is currently 0

Started with pid=1592

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\EXTPROC0ipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SERVER2)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

TNSLSNR for 32-bit Windows: Version 9.2.0.6.0 - Production on 20-FEB-2006 16:40:10

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is E:\ORACLE\IDS\920\network\admin\listener.ora

Log messages written to E:\ORACLE\IDS\920\network\log\listener.log

Trace information written to E:\ORACLE\IDS\920\network\trace\listener.trc

Trace level is currently 0

Started with pid=1716

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\EXTPROC0ipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SERVER2)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

20-FEB-2006 17:07:07 * (CONNECT_DATA=(SID=ids920)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1311)) * establish * ids920 * 12505

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

21-FEB-2006 07:23:12 * (CONNECT_DATA=(SID=ids920)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1126)) * establish * ids920 * 12505

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

21-FEB-2006 07:24:51 * (CONNECT_DATA=(SERVICE_NAME=IDS920)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1127)) * establish * IDS920 * 12514

TNS-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

21-FEB-2006 07:25:19 * (CONNECT_DATA=(SERVICE_NAME=IDS)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1128)) * establish * IDS * 12514

TNS-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

21-FEB-2006 07:25:34 * (CONNECT_DATA=(SID=ids920)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1129)) * establish * ids920 * 12505

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

21-FEB-2006 07:27:32 * (CONNECT_DATA=(SID=ids920)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1130)) * establish * ids920 * 12505

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

21-FEB-2006 07:27:37 * (CONNECT_DATA=(SID=ids920)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1131)) * establish * ids920 * 12505

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

21-FEB-2006 07:33:14 * (CONNECT_DATA=(SID=ids920)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1132)) * establish * ids920 * 12505

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

21-FEB-2006 09:24:16 * (CONNECT_DATA=(SID=ids920)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1194)) * establish * ids920 * 12505

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

21-FEB-2006 09:27:09 * (CONNECT_DATA=(SID=ids920)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1221)) * establish * ids920 * 12505

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

21-FEB-2006 09:29:03 * (CONNECT_DATA=(SID=ids920)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=SERVER2)(USER=idsadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.108)(PORT=1252)) * establish * ids920 * 12505

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

[LeonardoAraujo · Accepted solution]

Any ideas?

[Former Member · Accepted solution]

Hi Leonardo,

Try using these configuration for you files:

Listener.ora

LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= IDS.world)
        )
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= IDS)
        )
        (ADDRESS =
          (COMMUNITY = sap.world)
          (PROTOCOL = TCP)
          (Host = SERVER2)
          (Port = 1521)
        )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SDU = 32768)
      (SID_NAME = IDS)
      (ORACLE_HOME = /oracle/IDS/920)
      (PRESPAWN_MAX = 10)
    )
  )

tnsnames.ora:

IDS.world =
  (DESCRIPTION =
    (SDU = 32768)
    (ADDRESS_LIST =
      (ADDRESS =
        (COMMUNITY = SAP.WORLD)
        (PROTOCOL = TCP)
        (HOST = SERVER2)
        (PORT = 1521)
      )
    )
    (CONNECT_DATA =
      (SID = IDS)
      (GLOBAL_NAME = IDS.WORLD)
    )
  )

Good luck,

Alexander

[LeonardoAraujo · Accepted solution]

I've tried all these options and still didn't work.

Important:

1 - I don't have a domain set up in that machine. It works as a workgroup.

2 - Only the CI is installed nto the DB instance yet. I don't understand why this could affect since even Oracle Net assistant give me errors.

Is it mandatory to have a domain installed?

Is it necessary to continue with DB instance?

Thanks for your help so far!

[Former Member · Accepted solution]

Leonardo,

At which step are you exactly?

If you haven't installed a database yet then you will not be able to connect.

Alexander

[LeonardoAraujo · Accepted solution]

Alexander,

-I've installed the Oracle database 920, Server and client;

-Pacthed them as per the installation master guide;

-I have sucessfully installed the ABAP ERP 2004 CI.

-I have not started to install the DB instance yet. I was just doing some tests in the oracle side and I tried to start the SAP instance...

What do you recommend now?

Remember, my SQLNET looks like this:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

[Former Member · Accepted solution]

Ok now I understand it better.

You DO need to install the dbinstance installation as well. Only then will everything work properly.

Let me know how things go when you have done this.

Best of luck,

Alexander Webster

[LeonardoAraujo · Accepted solution]

Alexander,

Thanks for your info.

I am installing the DB and now I get an error message in one of the final steps (create RFC jobs).

Looks like I have a network problem.

Since the problme seems different, I've opened a new thread. Please visit:

Thanks

[Former Member]

Did you have backup copies of the tnsnames.ora and listener.ora?

[former_member184385]

Leonardo,

please concentrate on getting a functional oracle install, which means, that the commands:

- tnsping IDS

- sqlplus scott/tiger@IDS

should work

Unless the above commands work, there is not point to proceed with any SAP install tasks, which use the db!

Regards

Gregor

[former_member184385]

Hi,

change in tnsnames.ora the service def. to

IDS =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))

)

(CONNECT_DATA =

(SID = IDS)

(SERVER = DEDICATED)

)

)

Stop listener and server and start listener server (in this sequence).

Then use the command tnsping IDS to check, if the service is available. If yes, try to connect to oracle using sqlplus and then proceed with the sap install again.

Regards

Gregor

[Former Member]

hi,

see if the TNSLISTENER SERVICE is started. change the start settings to automatic and start it now, if its not running.

Regards

Arun.

[Former Member]

Hi,

Change the SID name in ur listener.ora file. that is

(SID_NAME = PLSExtProc) to (SID_NAME = XBC)

[LeonardoAraujo]

I've just changed it and it still doesn't work.

I get the same errors.

Why XBC though? Shouldn't it be IDS?

[LeonardoAraujo]

I've tried SID = ids920 and SID = IDS.

Remember, this is what I have in TNSNAMES...

1. TNSNAMES.ORA Network Configuration File: E:\ORACLE\IDS\920\network\admin\tnsnames.ora

2. Generated by Oracle configuration tools.

IDS920_SERVER2 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))

)

(CONNECT_DATA =

(SID = ids920)

(SERVER = DEDICATED)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

[Former Member]

The SID value in your tnsnames.ora refers to the actual database name. In your post Feb 21, 2006 7:15 AM, it is showing as ids920, while in your initial post, you never list out the ORACLE_SID value, but you list out oracle_sysid=ids. I believe you manually enter the value, and wrongly type the variable name.

I can't trust the environment variables which you have posted in your initial post.

Let me tell you the precise steps to take.

First, tell us the ORACLE_SID by refering to Windows Services. You should find a server call OracleServiceIDS, if ORACLE_SID=IDS, or OracleServiceIDS92, if ORACLE_SID=IDS92

Secondly, provide the content of init<SID>.ora in E:\ORACLE\IDS\920\database. Oracle service name can be specify inside init.ora, and not necessary must be configure in listener.ora

Thirdly, restore back your listener.ora to the original version, which does not has entry for IDS.

Fourthly, ensure in init<SID>.ora has a line specify "SERVICE_NAMES=ids" assuming your ORACLE_SID=ids

Please remember that Oracle parameter can be either spfile<SID>.ora or init<SID>.ora. If both files exists, then spfile<SID>.ora is the file being used by database.

Create a new copy of init<SID>.ora file by login to database as SYSTEM or any other dba user, and type "create pfile 'C:\TEMP\initids.ora' from spfile;'

This will create a text file in C:\Temp\initids.ora. Post this initids.ora file.

The domain does not affect listener operation.

You can always use tnsping command to check from command prompt. If the TNS name is ids, then type "tnsping ids" This will be faster than using those Java wizard

If you want to test direct connection to database, use sqlplus. Following is the step

Approach 1

set oracle_sid=ids (this is database name, not TNS name)

sqlplus system/***

Approach 2

set local=ids (this is TNS listener name)

sqlplus system/***

Please take note that the TNS name configure in the tnsnames.ora is a nickname for the database. Only using approach 1, you can by pass listener, but SAP use listener to connect.

Below are the test sequence:

- listener running

- database Windows Service is running

- database is running

- sqlplus login using approach 1

- tnsping must be success if everything are configure properly

[Former Member]

Hi

Make the following checks and correct the error:

-Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.

- Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.

- Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable.

[LeonardoAraujo]

Here is my TNSNAMES.ORA:

1. TNSNAMES.ORA Network Configuration File: E:\ORACLE\IDS\920\network\admin\tnsnames.ora

2. Generated by Oracle configuration tools.

IDS920_SERVER2 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))

)

(CONNECT_DATA =

(SID = ids920)

(SERVER = DEDICATED)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

This is what I have under PATH variable: E:\ORACLE\IDS\920\jre\1.4.2\bin\client;E:\ORACLE\IDS\920\jre\1.4.2\bin;E:\ORACLE\IDS\920\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem

PLUS...

G:\usr\sap\IDS\SYS\exe\run

TNSNAMES.ORA is located at E:\ORACLE\IDS\920\network\admin so I am not quite sure what you mean by being "accessible". Am I missing something?

Thanks!

[LeonardoAraujo]

Here is what happened when I started Oracle NET Configuration Assitant:

Select TEST

The NET service that pops up is IDS920_SERVER2

Result:

Connecting ORA-12505 TNS Listner could not resolve SID given in connector descriptor.

The test did no succeed.

Some of the information you provided may be incorrect. Press Back to review the information provided for Net service name, or change login to change user name.

The user name I was using was the default: system

Are these problems related? Looks like it.