on 02-21-2006 2:57 AM
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:
SQLNET.ORA Network Configuration File: E:\ORACLE\IDS\920\network\admin\sqlnet.ora
Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Here is the dump of my listner:
LISTENER.ORA Network Configuration File: E:\ORACLE\IDS\920\network\admin\listener.ora
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
Hi Leonardo,
Can you supply a copy of your listener.log?
There sould be some more info about the error there.
Regards,
Alexander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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!
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)
Did you have backup copies of the tnsnames.ora and listener.ora?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Change the SID name in ur listener.ora file. that is
(SID_NAME = PLSExtProc) to (SID_NAME = XBC)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've tried SID = ids920 and SID = IDS.
Remember, this is what I have in TNSNAMES...
TNSNAMES.ORA Network Configuration File: E:\ORACLE\IDS\920\network\admin\tnsnames.ora
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)
)
)
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here is my TNSNAMES.ORA:
TNSNAMES.ORA Network Configuration File: E:\ORACLE\IDS\920\network\admin\tnsnames.ora
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!
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.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
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.