Home » RDBMS Server » Enterprise Manager » Instance Not starting (Oracle 10g, Rel 2, Linux AS4)
Instance Not starting [message #292332] Tue, 08 January 2008 09:56 Go to next message
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 11714 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 Go to previous messageGo to next message
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
Re: Instance Not starting [message #292463 is a reply to message #292332] Wed, 09 January 2008 00:29 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You do NOT need any listener or OEM to start Oracle.
Re: Instance Not starting [message #292466 is a reply to message #292463] Wed, 09 January 2008 00:35 Go to previous messageGo to next message
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.
Re: Instance Not starting [message #292468 is a reply to message #292332] Wed, 09 January 2008 00:40 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: Instance Not starting [message #292469 is a reply to message #292468] Wed, 09 January 2008 00:41 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Yes, if we use "tns_entry" with username/password.
Re: Instance Not starting [message #292474 is a reply to message #292332] Wed, 09 January 2008 00:47 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: Instance Not starting [message #292488 is a reply to message #292474] Wed, 09 January 2008 01:13 Go to previous message
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).
Previous Topic: Enterprise Manager Java Console cannot connect
Next Topic: To recover the space been used by deleted rows of a table
Goto Forum:
  


Current Time: Fri Dec 09 02:26:09 CST 2016

Total time taken to generate the page: 0.07986 seconds