|
|
|
|
| Re: How to connect to oracle9i server [message #56492 is a reply to message #56486] |
Thu, 03 April 2003 13:15  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
You can use any of these ways:
- Net8 protocol (SQL*PLus)
- with ODBC drivers
- with JDBC drivers
- with OCI drivers
The easiest one is with SQL*PLus. Add into %ORACLE_HOMEnetworkadmintnsnames.ora the TNS alias to the db where you want to connect to. Then start the SQL*PLus and provide the username, password and the TNS alias you already created. e.g.
c:>sqlplus /nolog
SQL>connect username@password@tnsname
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
