DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  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 Zeng

  2. #2
    Join Date
    Nov 2000
    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
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3


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

    Queyon Zeng

  4. #4
    Join Date
    Apr 2002
    Shenzhen, China
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.