TNS problem

From: Sancho <joseharvey_at_my-deja.com>
Date: Sun, 03 Dec 2000 20:36:32 GMT
Message-ID: <90eash$gpg$1@nnrp1.deja.com>

ntwort-an-Adresse:

                   oracle-on-linux_at_egroups.com
            Betreff:
                   [oracle-on-linux] TNS problem


                 Adresse hinzufügen

Hi, I'm running Oracle 8.0.5 on a SuSe 7.0 machine. I (think I) have configured the listener correctly, but when I try to connect, I get an ORA-01034 message (Oracle not available). But, if I try it directly without TNS, I get a connection. These are my config files:

# listener.ora
LISTENER=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.71.149.116)(PORT= 1521)))

SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=BSJTT)(SID_NAME=BSJ TT)(ORACLE_HOME=/opt/oracle/)))

LOG_FILE_LISTENER = lsnr

TRACE_LEVEL_LISTENER = 16 # tnsnames.ora
BSJTT=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.71.149.116)(PORT=1521 ))(CONNECT_DATA=(SID=BSJTT))) The listener starts successfully:

STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.0.5.0.0 -
Production
Start Date                29-NOV-00 18:26:52
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               support
Security                  OFF
SNMP                      OFF
Listener Parameter File   /opt/oracle/network/admin/listener.ora
Listener Log File         /opt/oracle/network/log/lsnr.log
Listener Trace File       /opt/oracle/network/trace/listener.trc
Services Summary...
  BSJTT         has 1 service handler(s)

The command completed successfully

tnsping says OK:

oracle_at_ws1-3:~ >tnsping bsjtt
TNS Ping Utility for Linux: Version 8.0.5.0.0 - Production on 29-NOV-00 18:29:51

Attempting to contact
(ADDRESS=(PROTOCOL=TCP)(HOST=10.71.149.116)(PORT=1521))
OK (10 msec)

oracle_at_ws1-3:~ > sqlplus
SQL*Plus: Release 8.0.5.0.0 - Production on Wed Nov 29 18:34:44 2000
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Enter user-name: system/manager
Connected to:
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
-- This connects without TNS:
SQL> connect system/manager;
Connected.
SQL> select name from v$database;
NAME

BSJTT
-- This connects over the listener
SQL> connect system/manager_at_bsjtt
ERROR:
ORA-01034: ORACLE not available
Warning: You are no longer connected to ORACLE. SQL> OK, I could be glad I'm connected, but I get no access from another machine!
What am I doing wrong?

TIA

--
-=[ Sancho ]=-


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Sun Dec 03 2000 - 14:36:32 CST