and check init.ora(Db_domain)
Main Topics
Browse All TopicsI have three systems 1 Windows 2000 and the other 2 running Linux. The ORACLE server is a LINUX server 192.168.1.220 (MDLITTLE). The other Linux system is a client that boot from a CD that is created from the server. For the oracle client I install the standard oracle9i client software into /home/oracle9i and then tar the information and move it into the CD directory.
I can access the ORACLE database without problem on the Linux server and from the Window 2000 system. Yet I receive an error from the Linux client. I have the following files.
Window 2000 client: tnsnames.ora
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\ad
# Generated by Oracle configuration tools.
PROACT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.220)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = proact.proactivemonitoring
)
)
Window 2000 client: sqlnet.ora
# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\ad
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERV
NAMES.DIRECTORY_PATH= (TNSNAMES)
On the Linux server that works I have:
/home/oracle9i/network/adm
# TNSNAMES.ORA Network Configuration File: /home/oracle9i/network/adm
# Generated by Oracle configuration tools.
PROACT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.220)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = proact.proactivemonitoring
)
)
/ home/oracle9i/network/admi
# SQLNET.ORA Network Configuration File: /home/oracle9i/network/adm
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Results from the test:
TNS Ping Utility for Linux: Version 9.2.0.1.0 - Production on 12-FEB-2003 11:48:20
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/home/oracle9i/network/adm
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.220)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = proact.proactivemonitoring
OK (10 msec)
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 12 11:48:48 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
The Linux client system that does not work has:
/home/oracle9i/network/adm
# TNSNAMES.ORA Network Configuration File: /home/oracle9i/network/adm
# Generated by Oracle configuration tools.
PROACT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.220)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = proact.proactivemonitoring
)
)
/ home/oracle9i/network/admi
# SQLNET.ORA Network Configuration File: /home/oracle9i/network/adm
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Results from the tests are:
TNS Ping Utility for Linux: Version 9.2.0.1.0 - Production on 12-FEB-2003 01:43:57
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/home/oracle9i/network/adm
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.220)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = proact.proactivemonitoring
OK (10 msec)
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 12 01:45:14 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve service name
Enter user-name: ERROR:
ORA-06413: Connection not open.
Enter user-name: ERROR:
ORA-06413: Connection not open.
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
On both Linux server and client I used the oracle user with the bash shell. Also in both cases I have a .bash_profile file with:
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_BASE=/home/oracle9i
ORACLE_HOME=/home/oracle9i
ORACLE_SID=proact; export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bi
LD_LIBRARY_PATH=$ORACLE_HO
unset USERNAME
From the above error ORA-12154 you would think that the tnsnames.ora file is not found. I do not understand why not since the tnsping can find the file.
Can anyone help?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Yes all have the same SERVICE_NAME of "proact.proactivemonitorin
After more research I found that you can skip the use of TNSNAMES in OCI by specifying the information in the form
(DESCRIPTION = (ADDRESS_LIST = (ADRESS = (PROTOCOL = TCP)(HOST = 192.168.1.220)(PORT = 1521)))(CONNECT = (SERVICE_NAME = proact.proactivemonitoring
Hence note need the TNSNAMES file. But this at first generated a new error ORA-06413. This was due to the fact the hostname was not set. Once set it all worked.
This question can not be considered closed.
Business Accounts
Answer for Membership
by: DanielztPosted on 2003-02-12 at 15:21:56ID: 7937698
Can you check your listener.ora,tnsnames.ora, init.ora(D B_name,ins tance_name , service_name ), make sure all the SERVICE_NAME is same as "proact.proactivemonitorin g.com"