CASE sqlplus Connect thru SQL*Net failing even Directly from DB Server , after migration to Oracle 8.1.7 from 7.3.4
$ sqlplus tbaadm/tbaadm@bor (Directly on DB Server) SQL*Plus: Release 8.1.7.0.0 - Production on Sun Apr 14 17:48:36 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-12154: TNS:could not resolve service name Enter user-name: $ tnsping bor (Directly on DB Server) TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production on 14-APR-2002 17:05:22 (c) Copyright 1997 Oracle Corporation. All rights reserved. TNS-03506: Failed to create address binding Qs Can any Events be Set in init.ora to find the Cause ? Qs Should Listener Tracing be Enabled ? Qs Any Advice on Cause & resolution ? NOTE :- - Checking if Listener process Listening on the respective Port 1890 on DB Server (Defined in listener.ora) $ netstat -a | grep 1890 tcp4 0 0 *.1890 *.* LISTEN - Issued Following Command :- $ telnet 10.2.1.1 1890 ( Directly on DB Server) Trying... Connected to 10.2.1.1. Escape character is '^]'. Listener.ora :- # LISTENER.ORA Network Configuration File: /oracle8/ora817/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = database)(PORT = 1890)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = bor) (ORACLE_HOME = /oracle8/ora817) (PROGRAM = extproc) ) ) tnsnames.ora (in DB Server ) # TNSNAMES.ORA Network Configuration File: /oracle8/ora817/network/admin/tnsnames.ora # Generated by Oracle configuration tools. bor = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(host=10.2.1.1)(PORT = 1890))) (CONNECT_DATA = (SID = bor))) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
