connecting thro sql*plus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: connecting thro sql*plus

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    78
    Hai friends,
    I have created a new database (name db_new) and the sid is orcl.I am able to connect thro server manager without any difficulty.I want to access the database from forms builder/reports builder/sql*plus.What should I enter in the listener and tnsnames.ora files.Please let me know.
    Is it necessary that the sid name and database sh' be same.

    Thanks and regards

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    You will be better off using Net 8 Assistant.
    On the server, drill down to listener- your_listener node, go to database services in the drop down menu and Click on Add Database. Now give the Global database name, Oracle home directory and SID in the appropriate text boxes.

    On the client, you can configure tnsnames using Net8 Assistant again. Drill down to the Network|Services node and click on the Add button. Net8 will guide you further.

    Is it necessary that the sid name and database sh' be same
    It is not necessary, but generally preferred.

  3. #3
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    well...i think if u hv Net8 assistant it'll be gd but for a starter like this person
    its best to teach him/her the basic of configuring listener.ora and tnsnames.ora...
    for a start Listener.ora is configuration for database awaiting external connection whileas
    tnsnames.ora are configured at client side....for both cases there are sample in ur
    installed diectory such as $ORACLE_HOME/network/admin chk it out there
    ngwh,
    Singapore.

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