×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Oracle: All versions FAQ

Tips and Tricks

How to create a client connection to a database? by Michael42
Posted: 20 Apr 04

OVERVIEW
To make client connection to a database you need to create an Oracle Network Service entry.  This will create an appropriate entry in the tnsnames.ora file.  This example session uses dbsrv1 as the Oracle DB Server.

PROCEDURE
Sun
   cd /<ORACLE_HOME>/.../bin
   ./netmgr
Windows
  Start Menu->Programs->Oracle OraHome92->Configuration and Migration Tools->Net Manager
  Create ShortCut using:
  C:\oracle\ora92\bin\launch.exe "C:\oracle\ora92\network\tools" ..\network\tools\netmgr.cl

Expand + Local then select Service Naming
Select Add (+) button on left.
Enter:
   Service Name: dbsrv1.dev02
   Select Protocol: TCP/IP
   Enter Hostname and Port Number: dbsrv1
                                   1521
   Enter Service Name (as it is known on the server): dev02
   Select Connection Type: Dedicated Server

   Select: Test
   Exit Oracle Net Mgr and Select Yes to save.

   Entry will have been made in the tnsnames.ora

APPENDIX - tnsnames.ora Example
Common path to file: C:\<ORACLE_HOME>\network\admin\tnsnames.ora

dbsrv1.DEV02 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbsrv1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = dev02)
    )
  )


APPENDIX - SQLPlus Command Line
The SQLPlus command line from the client would be:
C:\oracle\ora92\bin\sqlplusw.exe scott/tiger@dbsrv1.DEV02



Back to Oracle: All versions FAQ Index
Back to Oracle: All versions Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close