Problems with sqlplus (Oracle)
magic_rooter
magic.rooter at gmail.com
Tue Feb 13 09:29:08 CET 2007
Hello. I have just installed sqlplus in order to write my own perl
plugin to check oracle db.
But I have the following errorw while connecting and I don't know what to do:(
[root at nagios libexec]# sqlplus user/pass@//server/test_db
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Feb 13 11:21:58 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
______________________
I made strace of sqlplus and saw that I have no tnsnames.ora and
sqlplus.ora files. I have made it and put to /root/.sqlplus.ora and
/etc/tnsnames.ora
Here are these files:
tnsnames.ora
TEST =
(DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SID=TEST)
)
)
sqlnet.ora
names.directory_path= (tnsnames)
sqlnet.expire_time = 30
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
::: Messages without supporting info will risk being sent to /dev/null
More information about the Users
mailing list