OraFAQ Forum: Networking and Gateways » problem in connection

Home » RDBMS Server » Networking and Gateways » problem in connection

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

problem in connection [message #334303]

Wed, 16 July 2008 02:35

k.syed
Messages: 2
Registered: June 2008

Junior Member

hi all

i have to connect an user/password and the error is shown as 'oracle not available' but the database is open stage.can anyone tell solution to this.

Report message to a moderator

Re: problem in connection [message #334322 is a reply to message #334303]

Wed, 16 July 2008 03:42

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

Senior Member
Account Moderator

Start the database.

Regards
Michel

Report message to a moderator

Re: problem in connection [message #338035 is a reply to message #334303]

Sat, 02 August 2008 11:39

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

Senior Member

This is becuase of you trying to connect some other database.
I guess it is unix/linux.

for example:
Database name is "orcl" and during connection you export "oracle" then you get above mention message in your previous post.

Report message to a moderator

Re: problem in connection [message #338066 is a reply to message #338035]

Sat, 02 August 2008 22:58

jayarajkrishna
Messages: 7
Registered: August 2008
Location: Mumbai,India

Junior Member

hi
lets try this command in OS prompt
export ORACLE_SID=<sidname> in unix/linux
set ORACLE_SID=<sidname> if it is windows

and try to connect..

Report message to a moderator

Previous Topic:	ORA-12571: TNS:packet writer failure
Next Topic:	lsnrctl start error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 07:32:49 CDT 2024