I have three databases(9i) and I wanted to connect to this with out a listener.
Could any one tell whether this is possible. If so what changes I have to make.
I am working on W2k, Oracle 9i
Printable View
I have three databases(9i) and I wanted to connect to this with out a listener.
Could any one tell whether this is possible. If so what changes I have to make.
I am working on W2k, Oracle 9i
I listener is not required if the connections are server-side client connections you can use the Bequeath protocol.
Here the problem is on Win2K,Oracle 9i when listener is down, I won't be able to connect to database using sqlplus????
The question is whether you are running sqlplus "on the database server". Are you? If so, you can do this. If not, you need a listener.
Ya. am running this on the same server but my network is down.
Same scenario works fine in NT,Oracle7.x, I wonder why in Win2k,Oracle9i not possible to connect from the server itself when the network is down??
so what's the error message, and why does the network being down prevent the listener from running?
Do you mean that the box the server plugs into is dead or the server network card is dead or that the network configuration on the server is trashed?Quote:
Originally posted by sudheer_nm
. . . . when the network is down??
Can you ping the server name specified as HOST = xxxx in tnsnames.ora?
If you want to connect without a listener (assuming you are where the Db resides), the oracle_sid entrie in the registry must be set to the instance you want to connect to.
Nonsence. What if you have more than one instance under the same oracle_home? Would you manualy edit registry each time you want to connect to a particular instancve without the listener?Quote:
Originally posted by yanban
If you want to connect without a listener (assuming you are where the Db resides), the oracle_sid entrie in the registry must be set to the instance you want to connect to.
Simply set the ORACLE_SID env variable whichever way you want it (command line, user environment) and you'll have no problem connecting to your database without the listener, even if you don't have ORACLE_SID entry in your registry at all.
Yes, on the server where the instance is, make sure your oracle_sid variable is set to the instance you want. Is done at the command line or through the Enviroment tab in the control/system panels.
You also have to have tnsnames entry setup to do the BEQUEATH connection. this bypases the network and drops straight into the database. You have to be on the server where the instance is.
I use both sqlplus, and all the OEM apps using this method when I have to update my application backend. Shutdown my database, turn listener off, connect and restart database, then run my load scipts using my bequeath entry to connect. Keeps the users out until I am ready for them.
You don't need that either. In fact, you don't need any Oracle Net configuration files at all. You can delete your tnsnames.ora, listener.ora. sqlnet.ora and simmilar TNS stuff and you'll still have no problem connecting to your database. Simply set your ORACLE_SID and then run your application without specifying TNS service name. So for example instead of usingQuote:
Originally posted by DcsoBob
You also have to have tnsnames entry setup to do the BEQUEATH connection. this bypases the network and drops straight into the database. You have to be on the server where the instance is.
SQLPLUS SYSTEM/MANAGER@my_beq_entry
use
SQLPLUS SYSTEM/MANAGER
Is this still available in 9i? I thought it disappeared in 8.1.5 - replaced by IPC.Quote:
Originally posted by DcsoBob
You also have to have tnsnames entry setup to do the BEQUEATH connection.
Well, i just copied in the bequeath phrasing from my old 7.3 file and it worked just fine.
I need to try Jmodic's suggestion thought. I always thought that setting the oracle_sid merely identified the default instance in a connect statement, not the manner of connect. I had thought I had tested this awhile back. I disconnected my box from network and turned off the listener. Seem to recall not being able to connect.
If the sqlplus connect statment does not find a host or tns entry, how does it know what method to use to connect to the default instance?
The learning never stops!!
Bob
Okay J, I have attempted the process you replied. Simulated by editing my Tnsnames file to remove the reference to my instance.
I set my oracle_sid to the instance name. I then attempted a sqlplus connection. It hung up. I could never get a connection.
What should I be looking for here? All of the docs I have read say that a connection string has to exist within the names structure you utilize in order for a connection to occur.
Thanks!! I really want to understand this as it would help me with a small issue of upgrade.