Re: Connection from Oracle Developer Suite 10g 9.0.4.0.1 to Oracle DB 10g Release 10.1.0.2.0

From: <asdi2k_at_gmail.com>
Date: 30 Jun 2005 10:06:36 -0700
Message-ID: <1120151196.724047.218200_at_o13g2000cwo.googlegroups.com>

Hello Frank,

Thanks for your suggestion. I tried copying TNSNAMES.ora from DB home to DEV home but no luck. Here is some more info about my system and .ora files.

Out of frustration I Deinstalled and re-installed both database items in this following order:

DEVELOPER SUITE first
and DB 10g Second

Please reveiw them and recommend any new ideas. I appreciate it.

Regads,
AKA C:\>tnsping orcl10g

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 30-JUN-2005 05:31:55 Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.1.0\10g_DB\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = **********.***.**.***)(PORT
= 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl10g)))
OK (20 msec)

C:\>lsnrctl status orcl10g

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 30-JUN-2005 05:33:45 Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=**********.***.**.***)(PORT=1521))(CONNECT_D ATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl10g))) STATUS of the LISTENER

---

Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version
10.1.0.2.0 - Production
Start Date                30-JUN-2005 04:16:40
Uptime                    0 days 1 hr. 17 min. 7 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF

Listener Log File
C:\oracle\product\10.1.0\Db_1\network\log\listener.log Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=**********.***.**.***)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=**********.***.**.***)(PORT=8080))(Presentation=HTTP)(Se ssion=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=**********.***.**.***)(PORT=2100))(Presentation=FTP)(Ses sion=RAW))
Services Summary...
Service "orcl10g" has 1 instance(s).
  Instance "orcl10g", status READY, has 1 handler(s) for this service...
Service "orcl10gXDB" has 1 instance(s).
  Instance "orcl10g", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\>

*****************************TNSNAME.ora for oracle DB 10g Release

10.1.0.2.0*****
# tnsnames.ora Network Configuration File:
C:\oracle\product\10.1.0\10g_DB\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL10G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = **********.***.**.***)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl10g)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     )
    (CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

****************************sqlnet.ora for Oracle DB 10g Rel

10.1.0.2.0*********
# sqlnet.ora Network Configuration File:
C:\oracle\product\10.1.0\10g_DB\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

********************listener.ora for Oracle DB 10g *******************

# listener.ora Network Configuration File:
C:\oracle\product\10.1.0\10g_DB\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.1.0\10g_DB)
      (PROGRAM = extproc)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = **********.***.**.***)(PORT
= 1521))
      )

    )
  )

*******************tnsnames.ora for Oracle Devloper Suite 10g

9.0.4.0.1***
# TNSNAMES.ORA Network Configuration File:
C:\oracle\product\10.1.0\oradevdb\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL10G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = **********.***.**.***)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl10g)

    )
  )

EXTPROC_CONNECTION_DATA.***.**.*** =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))     )
    (CONNECT_DATA =
      (SID = PLSExtProc)
    )
  )

****************************sqlnet.ora for Oracle Developer Suite 10g

9.0.4.0.1*******
# SQLNET.ORA Network Configuration File:
C:\oracle\product\10.1.0\oradevdb\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = ***.**.*** SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, ONAMES, HOSTNAME,EZCONNECT) DEFAULT_SDU_SIZE = 8761 Received on Thu Jun 30 2005 - 19:06:36 CEST