Home » RDBMS Server » Networking and Gateways » how to connet without listener ...frank ,mahesh, smartin ,any one...pls help me
how to connet without listener ...frank ,mahesh, smartin ,any one...pls help me [message #117156] Mon, 25 April 2005 08:38 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Hi,

to every one my question is as below ....

I want to connect to my database as DBA .... and my listener is not working i m on server on which there are total 5 database including my database suppose database is A , B , C , D, E...... now i want to connect to the database A and my listener is not working and i dont want to create listener ? is it possible if yes then how.


From :-- Sunil
Re: how to connet without listener ...frank ,mahesh, smartin ,any one...pls help me [message #117161 is a reply to message #117156] Mon, 25 April 2005 09:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
if you have access to the server,
then do this. by default, you will login to specified SID.
set ORACLE_SID=SID
sqlplus dba/password
Re: how to connet without listener ...frank ,mahesh, smartin ,any one...pls help me [message #117178 is a reply to message #117161] Mon, 25 April 2005 10:45 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi ,

thank you very much for your reply .. mahesh ...

from:- sunil
Re: how to connet without listener ...frank ,mahesh, smartin ,any one...pls help me [message #117264 is a reply to message #117178] Tue, 26 April 2005 03:07 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Can you tell me where i can get oracle_sid parameter that i have to set ....in which file ...

thanks for your reply in advance

sunil


Re: how to connet without listener ...frank ,mahesh, smartin ,any one...pls help me [message #117265 is a reply to message #117264] Tue, 26 April 2005 03:09 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

how i will set oracle_sid=sid ... i know what i m asking is spoon feeding but please cope with me

sunil
Re: how to connet without listener ...frank ,mahesh, smartin ,any one...pls help me [message #117282 is a reply to message #117265] Tue, 26 April 2005 05:07 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
In your command prompt
bash-2.03$ set ORACLE_SID=mutation
bash-2.03$ sqlplus scott/tiger

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Apr 26 05:00:58 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

scott@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
Previous Topic: TNS-12574 Help, funny problem
Next Topic: VB Oracle(UNIX) connectivity
Goto Forum:
  


Current Time: Sat May 04 21:28:11 CDT 2024