INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- 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!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Feedback
"...If I'd only had resource like eng-tips when I was just getting started! I might have dazzled them with my brilliance instead of my BS..."
Geography
Where in the world do Tek-Tips members come from?
|
Oracle: Oracle release - 9i and earlier FAQ
|
Tips and Tricks
|
How to create a client connection to a database?
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: Oracle release - 9i and earlier FAQ Index
Back to Oracle: Oracle release - 9i and earlier Forum
|
|
 |
|
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:
Talk To Other Members- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close
