OraFAQ Forum: Enterprise Manager » Instance Not starting

Home » RDBMS Server » Enterprise Manager » Instance Not starting (Oracle 10g, Rel 2, Linux AS4)

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

Instance Not starting [message #292332]

Tue, 08 January 2008 09:56

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello All,

I'm just working on Oracle 10g rel 2 on Linux AS4. I've create my database using dbca and I've also opted for OEM while creating.

But after the successful creation of my database , I can't access my database . It's showing Instance is down due to

ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)

Attached is the file regarding that.

Please help me out I'm a newbie on OEM.

Regards,
Raj

Attachment: repDown.html
(Size: 18.85KB, Downloaded 13317 times)

[Updated on: Tue, 08 January 2008 09:57]

Report message to a moderator

Re: Instance Not starting [message #292461 is a reply to message #292332]

Wed, 09 January 2008 00:24

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

>ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)

Did you check listener is start ?
CMD>LSNRCTL START

Report message to a moderator

Re: Instance Not starting [message #292463 is a reply to message #292332]

Wed, 09 January 2008 00:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You do NOT need any listener or OEM to start Oracle.

Report message to a moderator

Re: Instance Not starting [message #292466 is a reply to message #292463]

Wed, 09 January 2008 00:35

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

> I can't access my database
OP try to access (connect) to database.

Report message to a moderator

Re: Instance Not starting [message #292468 is a reply to message #292332]

Wed, 09 January 2008 00:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

One does require any listener to access Oracle;
as long as you can login to the system hosting the Oracle DB.

Report message to a moderator

Re: Instance Not starting [message #292469 is a reply to message #292468]

Wed, 09 January 2008 00:41

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Yes, if we use "tns_entry" with username/password.

Report message to a moderator

Re: Instance Not starting [message #292474 is a reply to message #292332]

Wed, 09 January 2008 00:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Yes, if we use "tns_entry" with username/password.
NO! does not use TCP/IP but BEQ & can be done as
SQL> connect / as sysdba
WITHOUT any TNS entry.

Report message to a moderator

Re: Instance Not starting [message #292488 is a reply to message #292474]

Wed, 09 January 2008 01:13

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

>WITHOUT any TNS entry.
Yes, right, but i say WITH TNS entry we can't connect to database when listener is down(stop).

Report message to a moderator

Previous Topic:	Enterprise Manager Java Console cannot connect
Next Topic:	To recover the space been used by deleted rows of a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:30:44 CDT 2024