OraFAQ Forum: Server Administration » can't logged as sysdba, why?

Home » RDBMS Server » Server Administration » can't logged as sysdba, why?

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

can't logged as sysdba, why? [message #123761]

Tue, 14 June 2005 14:39

cuimingtracy
Messages: 2
Registered: June 2005

Junior Member

HI, I installed the oracle 9i under Red_Hed, and at that time, I can log on as a sysdba.

But after a few days, when I logged on again (SYS as SYSDBA), it's said that ORA-12541: TNS:no listener

I wonder why? Could anyone tell me how to Solve it?

Thanks a lot!

Report message to a moderator

Re: can't logged as sysdba, why? [message #123764 is a reply to message #123761]

Tue, 14 June 2005 14:56

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Post your session.
If you are accessing a local database, Listener is not necessary.
If it is a remote database or use tnsconnectstrings then listener and tnsentries are necessary.

--
-- NO connect strings
--
bash-2.03$ sqlplus "sys/sys as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jun 14 14:46:17 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

sys@9i > exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
--
-- using connect strings 
--

bash-2.03$ sqlplus "sys/sys@mutation as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jun 14 14:46:31 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

sys@9i > exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

Report message to a moderator

Re: can't logged as sysdba, why? [message #123766 is a reply to message #123761]

Tue, 14 June 2005 15:04

cuimingtracy
Messages: 2
Registered: June 2005

Junior Member

hi, thanks a lot!

But I am just connecting to local one, it always says that there is no listener, so I can't log on. I wonder what is the listerner, and how can I find it?

thanks!

Report message to a moderator

Re: can't logged as sysdba, why? [message #123768 is a reply to message #123766]

Tue, 14 June 2005 15:12

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> I wonder what is the listerner, and how can I find it?

1. Please search this forum.
2. http://www.orafaq.com/faqnet.htm
3. http://www.csee.umbc.edu/help/oracle8/network.815/a67440/appa.htm

Report message to a moderator

Previous Topic:	Unable to see Trace file ?
Next Topic:	Looking for documentation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:21:29 CDT 2024