ORA-12154 connecting to 9i on XP

From: news.west.cox.net <tom_holden_at_cox.net>
Date: Tue, 16 Nov 2004 22:19:33 -0700
Message-ID: <JbBmd.123118$cJ3.103224@fed1read06>

Hi All:

I installed 9.2.0.3 on XP Home Edition SP2 - THE DBCA had trouble completing... so i created a database manually from a DOS Window and also installed the example schemas - At that point i was able to connect from a DOS Window to all schemas - And then i either changed the tnsnames and listener.ora

Now when i try to connect i'm getting a ORA-12154 TNS:could not resolve service name

The home pc is connected to the internet through a cable modem - When i ping to the server i get the router IP address.

When i tnsping it never returns and the computer becomes extremely slow. I finally have to cancel out.

C:\ora_base\ora92\admin\SB9205\scripts>tnsping SB9205

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-NOV-20
04 01:02:28

Used parameter files:
C:\ora_base\ora92\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = F85DV51))(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = SB9205)) ^C -- Hangs - has to cancel out

Thanks for any suggestions.

Tom

---------- SQLNET.ORA ---------------------

# SQLNET.ORA Network Configuration File: C:\ora_base\ora92\network\admin\sqlnet.ora # Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

LISTENER.ORA ----------------------- # LISTENER.ORA Network Configuration File: C:\ora_base\ora92\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = F85DV51)(PORT = 1521))
      )

)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\ora_base\ora92)
      (PROGRAM = extproc)

)
(SID_DESC =

      (GLOBAL_DBNAME = SB9205)
      (ORACLE_HOME = C:\ora_base\ora92)
      (SID_NAME = SB9205)

)
)

TNSNAMES.ORA ----------------------- # TNSNAMES.ORA Network Configuration File: C:\ora_base\ora92\network\admin\tnsnames.ora # Generated by Oracle configuration tools. 192.168.1.101 F85DV51

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) )
(CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

)
)

SB9205 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = F85DV51))(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = SB9205)
    )
  )

Received on Tue Nov 16 2004 - 23:19:33 CST