- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Output: ORA-12154: TNS:could not resolv...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-10-2008 10:47 AM
тАО09-10-2008 10:47 AM
Oracle Output: ORA-12154: TNS:could not resolve the connect
I have 2 instance in the same server, but i don't knows if its possible.Configure 2 instance of SAP in Data Protector 6.0 in the same server.
The client server is Windows server
I think so , that the problem is Enviromen Variables
Someone can help me with this problem
Thank you very
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-10-2008 11:16 AM
тАО09-10-2008 11:16 AM
Re: Oracle Output: ORA-12154: TNS:could not resolve the connect
Confirm your tns file is correct.
Then...., it may be the problem is just resolution. I'd be looking to do a reverse lookup from a client station and ensure it resolves correctly first using 'nslookup
See if you get the correct results...
Just a thought,
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-10-2008 05:05 PM
тАО09-10-2008 05:05 PM
Re: Oracle Output: ORA-12154: TNS:could not resolve the connect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-11-2008 09:48 AM
тАО09-11-2008 09:48 AM
Re: Oracle Output: ORA-12154: TNS:could not resolve the connect
Remember that I have 2 instances on the same server, so I have 2 tnsname.ora and sqlnet.ora.
The files are correct.
When I run the nslookup appear :
C:\Documents and Settings\pdiadm>nslookup 192.168.40.18
Server: pssw2dc01.netpolar.com
Address: 200.5.129.5
Name: pssw2ap128.netpolar.com
Address: 192.168.40.18
the server pssw2ap28 is who has the 2 instances
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2008 01:08 AM
тАО09-12-2008 01:08 AM
Re: Oracle Output: ORA-12154: TNS:could not resolve the connect
The ORA-12154 is a very common error, always related to your local copy of the tnsnames.ora file, your listener configuration and your database name aliases.
* Make sure that your listener is listening for the same service name that you are using.
* Your service name might have an alias, so check for global (world) entries and local entries. Check $ORACLE_HOME/network/admin/tnsnames.ora.
* Check your global_name
******** We can install multiple SID in a single server, as I am using two SAP System in a single machine.
Please put information of your both server detail in listener file.
You can check the listener status for Both SID.
Regards,
Gokul Chandola
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2008 02:25 PM
тАО09-12-2008 02:25 PM
Re: Oracle Output: ORA-12154: TNS:could not resolve the connect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-09-2008 08:50 AM
тАО10-09-2008 08:50 AM
Re: Oracle Output: ORA-12154: TNS:could not resolve the connect
Its the listener for the instances:
Instance: PDI
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $
################
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = PDI.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = PDI)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = pssw2ap128)
(PORT = 1528)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
LOG_DIRECTORY_LISTENER= Q:\oracle\PDI\102\network\log
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PDI)
(ORACLE_HOME = Q:\oracle\PDI\102)
)
)
Instance: PDM
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $
################
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = PDM.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = PDM)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = pssw2ap128)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PDM)
(ORACLE_HOME = H:\oracle\PDM\102)
)
(SID_DESC =
(SID_NAME = PDM)
(ORACLE_HOME = H:\oracle\PDM\102)
)
)
The problem continue.
I'm verified
*Hosts
*Listener
*tnsname
I think that the files are fine
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2008 01:33 PM
тАО10-15-2008 01:33 PM
Re: Oracle Output: ORA-12154: TNS:could not resolve the connect
yes with windows this is a tricky setup.
Since under Windows the dataprotector Service needs to run as the SAPServiceSID account you'll have at least trouble with the other SID not belonging to this Service User.
Configure one System first straight forward according to the book. When this runs fine, you configure the second System. During this configuration you'll need to provide the ORACLE_HOME and ORACLE_SID of the second system. I'd assume this is where your fault is located. May be you just gave the second ORACLE_SID, but the first ORACLE_HOME and therefore only the tnsnames.ora of the first system is found and the second one can not be resolved.
As for brbackup and brarchive, you'll need to set
SAPDATA_HOME
SAPBACKUP
SAPARCH
SAPREORG
SAPTRACE
for the second system in addition, because the defaults from your SAPServiceSID-User point to the first system.
Good luck
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2008 01:09 PM
тАО10-23-2008 01:09 PM
Re: Oracle Output: ORA-12154: TNS:could not resolve the connect
PDM = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=pssw2ap128)(PORT=1527))
(CONNECT_DATA=(SID=PDM)(SERVER=DEDICATED))
)
PDM.WORLD = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=pssw2ap128)(PORT=1527))
(CONNECT_DATA=(SID=PDM)(SERVER=DEDICATED))
)
=========================================
Your SQLNET.ORA should have something like this
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)