Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 9i tns / listener problems
Not sure why your posting has lots of empty lines in it, but it does make
reading the files a bit difficult. In any case, let's start with the
basics. From an OS prompt type in lsnrctl stat - what's the result? May be
that you just haven't started the listener, in which case a listener start
is the resolution.
-- HTH. Additions and corrections welcome. Pete Author of "Oracle8i: Architecture and Administration Exam Cram" "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA "Joel Orcutt" <jorcutt_at_steelpoint.com> wrote in message news:a6bb8159.0202132029.1db96b5_at_posting.google.com...Received on Thu Feb 14 2002 - 10:40:06 CST
> I've just finished installing 9i enterprise on my RedHat 7.1 Server.
>
> (A very painful experience I might add)
>
>
>
>
>
> I believe that the installation was successful. I completed all of
> the install steps including net config and dbca.
>
>
>
>
>
>
>
> Here's my problem -
>
>
>
>
>
>
>
> While I'm pretty sure that everything was configured properly, I can
> not connect to the database.
>
>
>
>
>
> I can not tnsping successfully either. When I try bin/tnsping
> localhost from the oracle home I get error TNS-12541: TNS:no listener.
> (I realize that this uses HOSTNAME to resolve) When I try
> bin/tnsping ORADB_ORADB.REDSAND or bin/tnsping oradb or any other
> variation of tnsping that I can think of I get error TNS-03505: TNS:
> Failed to resolve name.
>
>
>
>
>
> I've included the vitals below.....
>
>
>
>
>
> My Linux Hostname + Domain:
>
>
> RedSand1.Sandboxes
>
>
>
>
>
> My listener.ora file is as follows:
>
>
> LISTENER =
>
>
>
> (DESCRIPTION_LIST =
>
>
>
> (DESCRIPTION =
>
>
>
> (ADDRESS_LIST =
>
>
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = RedSand1.Sandboxes)(PORT =
> 1521))
>
>
>
> )
>
>
>
> (ADDRESS_LIST =
>
>
>
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
>
>
>
> )
>
>
>
> )
>
>
>
> )
>
>
>
>
>
>
>
> SID_LIST_LISTENER =
>
>
>
> (SID_LIST =
>
>
>
> (SID_DESC =
>
>
>
> (SID_NAME = PLSExtProc)
>
>
>
> (ORACLE_HOME = /usr/oracle/OraHome)
>
>
>
> (PROGRAM = extproc)
>
>
>
> )
>
>
>
> (SID_DESC =
>
>
>
> (GLOBAL_DBNAME = oradb.redsand1)
>
>
>
> (ORACLE_HOME = /usr/oracle/OraHome)
>
>
>
> (SID_NAME = oradb)
>
>
>
> )
>
>
>
> )
>
>
>
>
>
>
>
> My tnsnames.ora file is as follows:
>
>
> INST1_HTTP.REDSAND1 =
>
>
> (DESCRIPTION =
>
>
> (ADDRESS_LIST =
>
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = RedSand1.Sandboxes)(PORT =
> 1521))
>
>
> )
>
>
> (CONNECT_DATA =
>
>
> (SERVER = SHARED)
>
>
> (SERVICE_NAME = MODOSE)
>
>
> (PRESENTATION = http://HRService)
>
>
> )
>
>
> )
>
>
>
>
>
> EXTPROC_CONNECTION_DATA.SANDBOXES =
>
>
> (DESCRIPTION =
>
>
> (ADDRESS_LIST =
>
>
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
>
>
> )
>
>
> (CONNECT_DATA =
>
>
> (SID = PLSExtProc)
>
>
> (PRESENTATION = RO)
>
>
> )
>
>
> )
>
>
>
>
>
> ORADB_ORADB.REDSAND =
>
>
> (DESCRIPTION =
>
>
> (ADDRESS_LIST =
>
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = RedSand1.Sandboxes)(PORT =
> 1521))
>
>
> )
>
>
> (CONNECT_DATA =
>
>
> (SID = oradb)
>
>
> (SERVICE_NAME = oradb.redsand)
>
>
> (SERVER = DEDICATED)
>
>
> )
>
>
> )
>
>
>
>
>
>
>
>
>
> I consider myself a novice with Oracle and would greatly appreciate
> any help.
>
>
>
>
>
> Thanks in advance.
>
>
>
>
>
> Joel