Make dedicated connection to MTS database without TNSNAMES
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Make dedicated connection to MTS database without TNSNAMES

  1. #1

    Wink Make dedicated connection to MTS database without TNSNAMES

    We have a database running in MTS mode but, in order to perform a trace on a specific session, we want to connect to the database as a DEDICATED session. The problem is the client does not use TNSNAME to connect. Where can I specify the connetion mode as DEDICATED?

    Queyon
    Queyon Zeng

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I am assuming you are using JDBC. Take the description of the alias from the tnsnames.ora file and put it into your JDBC Connect string. Make sure you add the (SERVER=DEDICATED). Actually, I would put an entry in your tnsnames.ora file with SERVER=DEDICATED and test it before I c&p into my java program...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3

    DBI

    Thanks for your reply, Marist89.
    So what if they connect to the database using DBI?

    Queyon
    Queyon Zeng

  4. #4
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Then read the documentation of DBA to find the location of the connect string. I believe that it must have a way to modify it, just take your time.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

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