connect to db with out listener? possible?? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: connect to db with out listener? possible??

  1. #11
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  2. #12
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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.

  3. #13
    Join Date
    Feb 2001
    Posts
    99
    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

  4. #14
    Join Date
    Feb 2001
    Posts
    99
    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
  •  


Click Here to Expand Forum to Full Width