Ora 1254:Tns: no listner

[kzn]

Hi

I am new to oracle. I have installed oracle on a server 2003 box. After the installation I decided to create a database using the Database Configuration Assistant. When I tried to connect using the Enterprise Manager console I got the error Ora 1254:Tns: no listner.

The book I have purchased makes no mention of the error. It is a new installation. Below is a copy of the tnsnames.ora.

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

WH92_MYORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myoracle)(PORT = 1521))
)
(CONNECT_DATA =
(SID = wh92)
(SERVER = DEDICATED)
)
)


Thanks in advance

 

[hoinz]

Hi,

in your post you did not tell us if your listener is started.
As you perhaps know, or perhaps don't know, the listener is a service that has to be running in addition to your database.

And furthermore, I doubt the error you got is ORA-1254. I guess there are 5 digits, and you missed one? The exact error number may be helpful.

hope this helps

 

[PGoRule]

It should be ORA-12541:TNS:No Listener

Sharing the best from my side...

--Prashant--

 

[kzn]

Hi

Sorry it should have been
ORA-12541:TNS:No Listener

Having a look at the oracle services
OracleMTSRecoveryService Started
OracleOraHome92Agent Started
OracleOraHome92HTTPServer Started

I hope this what you were asking
Thanks

 

[hoinz]

there should something like:
Oracle<Name>TNSListener Started

....

 

[kzn]

Hi hoinz

no there is nothing listed or started

Thanks

 

[hoinz]

So it seems there went something wrong with your installation.
And by the way, I am not good at Windows, neither at the Database Configuration Assistant. Usually I am working with Oracle on Unix. Someone else may be more helpful here.

But it seems your database is not started (or installed) either, I am missing something like
Oracle<Name>Service Started

You might want to check your installation log files,
or maybe consider reinstalling from scratch, or dropping and creating a database once again, or at least reinstalling the network components (aka TNS).
But as I said before, this is the advice from guy who is not good at Windows...

hope this helps nevertheless

 

[kzn]

Hi Thanks for the reply. I had no luck, I even recreated the database. I busy download patch 9.2.0.7 to see if that makes a difference. At the moment the installation is on 9.2.0.1.

Thanks for your help

 

[SantaMufasa]

Sorry that I didn't see this thread earlier, KZN. Re-installing Oracle will not necessarily work. On windows, following the Oracle install, if the LISTENER service does not exist, you:

Start -> Programs -> (Oracle - OraHome92, or something similar) -> Configuration and Migration Tools -> Net Configuration Assistant.

[o] Listener Configuration [Next]
[o] Add [Next]
(Listener Name) "LISTENER" [Next]
(Selected Protocols) "TCP" (most likely) [Next]
[o] Use the standard port number of 1521
"Would you like to configure another listener?"
[o] No [Next]

Let us know if this gives you more joy.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]