Re: Problem installing Oracle 9i

Try to merge all tnsnames.ora to the "FINAL ONE" and copy it to all $ORACLE_HOME/network/admin Directories....

Joshua wrote:

> 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 - 17:19:33 CDT