Problems with sqlplus (Oracle)

[Carsten Koop]

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 = <insert instancename/SID here>)
    )
   )

save the file and try: sqlplus user/pass at test.oracle - should work - even 
under 10.1
I'm working with Oracle 9 and 10.


Mit freundlichen Grüßen / best regards

      Carsten Koop




" magic_rooter" <magic.rooter at gmail.com> 
Gesendet von: nagios-users-bounces at lists.sourceforge.net
13.02.2007 09:29

An
nagios-users at 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:(

[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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20070213/ecc780fd/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
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
-------------- next part --------------
_______________________________________________
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