connecting to the DB server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: connecting to the DB server

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Exclamation

    I am just a student so I know that the following question might sound easy to some of you.

    1.I am trying to connect to the DB server from the client machine for the first time. I just finished installing Oracle on the client machine. Assuming I want to connect to the database called PROD on the DB server. How do I connect from client machine to the DB server as soon I turn on the client machine?
    Do I connect to the client just like it's done on the DBserver to get into SQL*PLUS e.g. on the client I type:

    USERNAME
    PASSWORD
    HOST STRING

    and it will connect to the DB server?

    or there is something else need to do?

    2. Is the DB server supposed to be up and running when connecting from the client machine or both the client machine and the DB sever are supposed to be on?


    thanks

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    1. Use Net8 Easy Config to configure the tnsnames.ora file. Create a service to the db. It will prompt you to enter the db_name, protocol, port (leave to 1521), hostname. Then connect to the server.
    2. Yes the db has to be running.

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