Home » Infrastructure » Unix » TNS:could not resolve service name
TNS:could not resolve service name [message #97057] Tue, 06 November 2001 05:07 Go to next message
Jesús Pérez
Messages: 2
Registered: November 2001
Junior Member
$lsnrctl start

LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 06-NOV-01 15:17:19

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Starting /usr/local/oracle/product/8.0.5/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 8.0.5.0.0 - Production
System parameter file is /usr/local/oracle/product/8.0.5/network/admin/listener.ora
Log messages written to /usr/local/oracle/product/8.0.5/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=192.168.100.2)(PORT=1521))

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=leopoldo)(Port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 8.0.5.0.0 - Production
Start Date 06-NOV-01 15:17:24
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /usr/local/oracle/product/8.0.5/network/admin/listener.ora
Listener Log File /usr/local/oracle/product/8.0.5/network/log/listener.log
Services Summary...
extproc has 1 service handler(s)
ora8 has 1 service handler(s)
The command completed successfully

-----------------------ooo------------------------

host=leopoldo

$sqlplus system@leopoldo

SQL*Plus: Release 8.0.5.0.0 - Production on Tue Nov 6 15:17:51 2001

(c) Copyright 1998 Oracle Corporation. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve service name

Enter user-name:

------------------------ooo---------------------

¿ Que puedo hacer ?

----------------------------------------------------------------------
Re: TNS:could not resolve service name [message #97064 is a reply to message #97057] Fri, 09 November 2001 08:02 Go to previous message
robert malikian
Messages: 18
Registered: October 2001
Junior Member
You need to do;
export ORACLE_SID=leopoldo
sqlplus system/******

Is this a new database?
robert

----------------------------------------------------------------------
Previous Topic: files that grow
Next Topic: Re: Installing Oracle 8.1.7 on Redhat Linux 7.1
Goto Forum:
  


Current Time: Fri Apr 19 22:38:24 CDT 2024