-
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.
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 using
SQLPLUS SYSTEM/MANAGER@my_beq_entry
use
SQLPLUS SYSTEM/MANAGER
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Originally posted by DcsoBob
You also have to have tnsnames entry setup to do the BEQUEATH connection.
Is this still available in 9i? I thought it disappeared in 8.1.5 - replaced by IPC.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|