Hi,
I'm using SQL Plus 10.2 - my tnsnames.ora looks like this:
test.oracle =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = < insert ip here>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = )
)
)
save the file and try: sqlplus user/[EMAIL PROTECTED] - should work - even
under 10.1
I'm working with Oracle 9 and 10.
Mit freundlichen Grüßen / best regards
Carsten Koop
" magic_rooter" <[EMAIL PROTECTED]>
Gesendet von: [EMAIL PROTECTED]
13.02.2007 09:29
An
nagios-users@lists.sourceforge.net
Kopie
Thema
[Nagios-users] Problems with sqlplus (Oracle)
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:(
[EMAIL PROTECTED] 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@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
-
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@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
