I am taking a few notes as I set up ArcSDE 9.2 backed by Oracle 10.0.2 ...

Table of Contents

Oracle Installation

Seems straight forward enough ... except

Oracle Tweaks for ArcSDE

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

It seems that Oracle has moved on past what ESRI supports by way of letting management application hack away and add tables. We need to go into an internal file and add a couple of lines to listener.ora

No Format
(SID_DESC = (GLOBAL_DBNAME = ORCL.WORLD) (ORACLE_HOME = C:\oracle\product\10.1.0\Db_1) (SID_NAME = ORCL) )

Basically ArcSDE needs to use this GLOBAL_DBNAME setting in order to know what database to add an SDE user to and set up its tables. GLOBAL_DBNAME is no longer used by others to the point Oracle has stopped having it around by default.

On windows the file will look something like this when you are done:

No Format

# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\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\Db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL.WORLD)
      (ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
      (SID_NAME = ORCL)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = chicken)(PORT = 1521))
      )
    )
  )

After you have added these lines you need to kick the listener to notice the file:

Panel

C:\Documents and Settings\Administrator> lsnrctl stop

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 18-APR-2008 16:45:07

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully

Panel

C:\Documents and Settings\Administrator> lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 18-APR-2008 16:46:29

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production
System parameter file is C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
Log messages written to C:\oracle\product\10.1.0\Db_1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=chicken)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 18-APR-2008 16:46:31
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
Listener Log File C:\oracle\product\10.1.0\Db_1\network\log\listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=chicken)(PORT=1521)))
Services Summary...
Service "ORCL.WORLD" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Panel

C:\Documents and Settings\Administrator> lsnrctl reload

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 18-APR-2008 16:47:33

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully

ArcSDE Installation Notes on Windows

Versions Compared

Old Version 4

New Version Current

Key

Oracle Installation

Oracle Tweaks for ArcSDE

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

ArcSDE Installation