OraFAQ Forum: Enterprise Manager » No Listener.ora or tnsnames.ora files!!!!!! (2 Merged)

Home » RDBMS Server » Enterprise Manager » No Listener.ora or tnsnames.ora files!!!!!! (2 Merged) (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

No Listener.ora or tnsnames.ora files!!!!!! (2 Merged) [message #523676]

Mon, 19 September 2011 15:52

soldierfc
Messages: 7
Registered: September 2011

Junior Member

Shocked

Sad

I installed Oracle 10g. Then I created an instance. After the instance was created, I went to OEM to look at the instance, and noticed it wasn't turned on. I went to the network folder and noticed I only had sqlnet.ora; no Listener.ora or tsnames.ora. I put the files there, but when I try to startup the instance, the password and usernames I created with the database don't work.
Agent Connection to Instance failed
Listener down Shocked

Shocked

Report message to a moderator

No Listener.ora or tnsnames.ora files!!!!!! [message #523677 is a reply to message #523676]

Mon, 19 September 2011 16:06

soldierfc
Messages: 7
Registered: September 2011

Junior Member

Sad

I installed 10 g and I cannot see listener.ora or tnsnames.ora in the network folder. I also cannot get my instance to start. The Listner is down, and none of the usernames and passwords work.

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523680 is a reply to message #523677]

Mon, 19 September 2011 17:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>I installed 10 g
post COPY & PASTE proof Oracle DB exists.
post excerpt from alert_SID.log file that show DB stop/start were successful.

With V10 no listener.ora file is required to start the listener.

[Updated on: Mon, 19 September 2011 17:08]

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523730 is a reply to message #523677]

Tue, 20 September 2011 03:24

Michel Cadot
Messages: 68166
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

soldierfc wrote on Mon, 19 September 2011 23:06

I installed 10 g and I cannot see listener.ora or tnsnames.ora in the network folder. I also cannot get my instance to start. The Listner is down, and none of the usernames and passwords work.

Neither tnsnames.ora not sqlnet.ora are mandatory.
Default installation does not create them.
So you have what is expected.

You don't need none of this file to start your instance, just connect locally "/ as sysdba".

Regards
Michel

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523780 is a reply to message #523730]

Tue, 20 September 2011 07:15

soldierfc
Messages: 7
Registered: September 2011

Junior Member

They weren't created when the database was created after installation.

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523790 is a reply to message #523780]

Tue, 20 September 2011 07:46

Michel Cadot
Messages: 68166
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is expected.

Regards
Michel

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523810 is a reply to message #523790]

Tue, 20 September 2011 08:05

soldierfc
Messages: 7
Registered: September 2011

Junior Member

Even after I create the database? I thought These two files would be created upon creation. They were in the past.

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523812 is a reply to message #523810]

Tue, 20 September 2011 08:08

soldierfc
Messages: 7
Registered: September 2011

Junior Member

I can connect to Sqlplus, but how do I start the instance? I am new to oracle.

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523823 is a reply to message #523812]

Tue, 20 September 2011 08:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I can connect to Sqlplus, but how do I start the instance? I am new to oracle.

sqlplus
/ as sysdba
startup
exit

COPY commands & results from above then PASTE all back here

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523830 is a reply to message #523810]

Tue, 20 September 2011 09:04

Michel Cadot
Messages: 68166
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I thought These two files would be created upon creation. They were in the past.

No never unless you used dbca.

Regards
Michel

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523845 is a reply to message #523830]

Tue, 20 September 2011 10:42

soldierfc
Messages: 7
Registered: September 2011

Junior Member

I did. I typed dbca in the comand prompt and created the instance with the Database configuartion assistant wizard.

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523846 is a reply to message #523845]

Tue, 20 September 2011 10:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

so what can we do for you now?

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523848 is a reply to message #523846]

Tue, 20 September 2011 11:26

soldierfc
Messages: 7
Registered: September 2011

Junior Member

I uninstalled oracle. Whenever you create a database there has to be a listener. There are no listeners with my databases.

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523849 is a reply to message #523848]

Tue, 20 September 2011 11:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Whenever you create a database there has to be a listener.
Statement above is 100% WRONG! See below

bcm@bcm-laptop:~$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-SEP-2011 09:31:51

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
bcm@bcm-laptop:~$ sqlplus user1/user1

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 20 09:32:02 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from user_objects;

  COUNT(*)
----------
       188

SQL>

besides you can start listener when no listener.ora file exists.
Try it for yourself.

Report message to a moderator

Re: No Listener.ora or tnsnames.ora files!!!!!! [message #523851 is a reply to message #523848]

Tue, 20 September 2011 11:53

Michel Cadot
Messages: 68166
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

soldierfc wrote on Tue, 20 September 2011 18:26

I uninstalled oracle. Whenever you create a database there has to be a listener. There are no listeners with my databases.

You don't read or don't want to understand what we write you:

Michel Cadot wrote on Tue, 20 September 2011 10:24

soldierfc wrote on Mon, 19 September 2011 23:06
I installed 10 g and I cannot see listener.ora or tnsnames.ora in the network folder. I also cannot get my instance to start. The Listner is down, and none of the usernames and passwords work.

Neither tnsnames.ora not sqlnet.ora are mandatory.
Default installation does not create them.
So you have what is expected.

You don't need none of this file to start your instance, just connect locally "/ as sysdba".

Regards
Michel

Report message to a moderator

Previous Topic:	OEM Grid - Current Logon Counts - Where is this info coming from
Next Topic:	OC4J Configuration issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 22 23:34:59 CDT 2022