Re: Problem installing Oracle 9i

From: Joshua <a.j.van.rooijen_at_bluevision.nl>
Date: 13 Jul 2002 12:11:43 -0700
Message-ID: <30a9426a.0207131111.598b3c45@posting.google.com>

You're right, Here are the clues:

I have stopped and started the listener each time i changed my configuration files.
The files reside all in the directory specified by TNS_ADMIN.

When i tnsping CAMELOT1 (my database service) i get:

Used parameterfiles:
E:\oracle\isuites\network\admin\sqlnet.ora

...............................\tnsnames.ora

TNS-03505 failed to resolve name

When using sqlplus system/arthur_at_camelot1 i get:

ORA-12154 couldn't resolve service name

When using the sqlplus from the orahome92 directory i can connect to the database only when i don't give the hoststring camelot1. After connecting checking the database name from V$database i get CAMELOT1.

I did mention that the service ORACLEORAHOME92AGENT failed to start. Anything to do with my problem or do i get others problems from that?

TNSNAMES.ORA: # Internal mame for local Oracle8i Cache. ora_icache =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = icache))     )
(CONNECT_DATA = (SERVICE_NAME = taurus-icache )
    )
  )

# Descriptive name to connect to cache via OEM performance monitor. taurus-icache =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = icache))     )
(CONNECT_DATA = (SERVICE_NAME = taurus-icache )
    )
  )

# Support for external procedures within Oracle8i cache.
#extproc_connection_data =
#  (DESCRIPTION =
#    (ADDRESS = (PROTOCOL = ipc)(KEY = icache)
#    )
#    (CONNECT_DATA = (SID = iCache_extproc)(SERVER = #DEDICATED)
#    )
#  )

# Oracle8i Cache's origin database.
ora_icache_origin =
  (DESCRIPTION =
(ADDRESS_LIST =

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

    )
(CONNECT_DATA =

      (SERVICE_NAME = camelot1)
    )
  )

# Support for mod_ose over normal TCP connections.
#inst1_http = 
#  (DESCRIPTION =
#    (ADDRESS =
#      (PROTOCOL = TCP) 
#      (HOST = taurus) 
#      (PORT = 1521)
#    )
#    (CONNECT_DATA =
#      (SERVICE_NAME = MODOSE)
#      (SERVER = shared)
#      (PRESENTATION = http://admin)
#    )
#  )

# To support mod_ose over TCP with SSL connections, uncomment
# the following lines.
#
#inst1_https = 
#  (DESCRIPTION =
#    (ADDRESS =
#      (PROTOCOL = TCPS) 
#      (HOST = taurus) 
#      (PORT = 2484)
#    )
#    (CONNECT_DATA =
#      (SERVICE_NAME = MODOSE)
#      (SERVER = shared)
#      (PRESENTATION = http://admin)

# )
# )

# TNSNAMES.ORA Network Configuration File: E:\oracle\ora92\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

CAMELOT1 =
  (DESCRIPTION =
(ADDRESS_LIST =

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

      (SERVER = DEDICATED)
      (SERVICE_NAME = Camelot1)

    )
  )

INST1_HTTP =
  (DESCRIPTION =
(ADDRESS_LIST =

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

      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
(ADDRESS_LIST =

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

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

# net8

Beq-local.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = BEQ)
          (PROGRAM = oracle80)
          (ARGV0 = oracle80ORCL)
          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )
Tcp-loopback.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )
TcpExample.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = Production1)
          (Port = 1521)
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )
SpxExample.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = SPX)
          (Service = Server_lsnr)
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )
NmpExample.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = NMP)
          (Server = FinanceServer1)
          (Pipe = ORAPIPE)
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )
CMExample.world =
  (DESCRIPTION=(address_list=

      (ADDRESS=
          (PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))
      (ADDRESS=
          (PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))
      (CONNECT_DATA=(SID=ORCL))
         (SOURCE_ROUTE=yes)

  )

#extproc_connection_data.world =
#  (DESCRIPTION =
#    (ADDRESS =
#        (PROTOCOL = IPC)
#        (KEY = EXTPROC1)
#    )
#    (CONNECT_DATA = (SID = extproc)
#    )
#  )

Rep60_TAURUS,Rep60_TAURUS.world=(ADDRESS=(PROTOCOL=tcp)(HOST=TAURUS)(PORT=1950))

SQLNET.ORA: NAMES.DEFAULT_DOMAIN = TAURUS SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) LISTENER.ORA: LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =

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

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\ora92)
      (PROGRAM = extproc)

    )
(SID_DESC =

      (GLOBAL_DBNAME = Camelot1)
      (ORACLE_HOME = E:\oracle\ora92)
      (SID_NAME = Camelot1)

    )
  )

TRACE_LEVEL_LISTENER = USER Received on Sat Jul 13 2002 - 14:11:43 CDT