ora-12203 can't connect from form builder to local database

From: Jacek <rowla.WYTNIJ.TO_at_I.TO.o2.pl>
Date: Sat, 3 Jan 2004 23:29:10 +0100
Message-ID: <bt7fnv$7cv$1_at_sunflower.man.poznan.pl>

hello,
[Quoted] I have database 9i and developer 6i installed on my computer. when trying to connect from form builder to database I get ORA-12203:TNS:unable to connect to destination SQL Plus, isqlplus work fine.
here are some of the configuration files:

$ORACLE_HOME = E:\oracle
$DEV_HOME=E:\dev
$SID=jac
$GLOBAL_DBNAME=jac
-----------------------------------------------------

$ORACLE_HOME\network\admin\listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )


      (ADDRESS_LIST =


        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )

    )

#    (DESCRIPTION =
#      (PROTOCOL_STACK =
#        (PRESENTATION = GIOP)
#        (SESSION = RAW)
#      )
#      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 2481))
#    )

  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = jac)
(ORACLE_HOME = E:\oracle)
(SID_NAME = jac)

    )
  )

LOG_FILE_LISTENER = lsnr
LOG_DIRECTORY_LISTENER = E:\oracle\network\log

---

$ORACLE_HOME\network\admin\sqlnet.ora:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

names.default_domain = world
names.default_zone = world
names.directory_path= (TNSNAMES, HOSTNAME, ONAMES)

------------------------------------------------------------

$ORACLE_HOME\network\admin\tnsnames.ora

jac.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jac)
(SID = jac)

    )
  )

#INST1_HTTP =
#  (DESCRIPTION =
#    (ADDRESS_LIST =
#      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
#    )
#    (CONNECT_DATA =
#      (SERVER = SHARED)
#      (SERVICE_NAME = MODOSE)
#      (PRESENTATION = http://HRService)
#    )
#  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

---

$DEV_HOME\net80\admin\sqlnet.ora

NAMES.DEFAULT_ZONE = world
NAMES.DEFAULT_DOMAIN = world

#SQLNET.EXPIRE_TIME = 0
#SQLNET.ENCRYPTION_SERVER = requested
#SQLNET.ENCRYPTION_CLIENT = requested

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)

---

$DEV_HOME\net80\admin\tnsnames.ora

JAC.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1526))
    )
    (CONNECT_DATA = (SID = jac))
  )

---

here are also logs:

---

$DEV_HOME\forms60\sqlnet.log:

Fatal NI connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=152 6))(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=j ac)(CID=(PROGRAM=E:\dev\BIN\ifbld60.EXE)(HOST=MOJA)(USER=jacek))))

  VERSION INFORMATION:
 TNS for 32-bit Windows: Version 8.0.6.0.0 - Production   Time: 03-STY-04 23:06:33
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12538
    TNS-12538: TNS:no such protocol adapter     ns secondary err code: 12560
    nt main err code: 508
    TNS-00508: No such protocol adapter
    nt secondary err code: 0
    nt OS err code: 0

---

lsnrctl status gives:
Service "PLSExtProc" has a number of instances 1.

  Instancja "PLSExtProc", state UNKNOWN
Service "jac" has a number of instances 2.
  Instancja "jac", state UNKNOWN
  Instancja "jac", state READY

Service "jacXDB" has a number of instances 1.   Instancja "jac", state READY

I will be very greatful for any help.

--

best regards,
jacek

Received on Sat Jan 03 2004 - 23:29:10 CET