who to connect to another server using sqlplus 1

[zum]

Hi,

I'm trying to use sqlplus to connect to another server running Oracle. I'm doing this on a FreeBSD server.

I use the command,
#sqlplus
which then asks for my username and password.

I'm really just trying to make sure that the Freebsd server can talk to the Sun server that is running Oracle 9i.

FYI, I'm very new to Oracle.

Thanks.

 

[SantaMufasa]

Zum,

Yours are good questions, especially for a newbie to Oracle. There are several syntactical options for connecting with a user-name and password to Oracle via SQL*Plus:

Option 1: sqlplus <username>/<password>@<tns alias>

Option 2: sqlplus <return key>
          username: <username>/<password>@<tns alias>

Option 3: sqlplus <return key>
          username: <username>
          password: <password>@<tns alias>
          (in above option, "****" appear during pw entry)

Once you have connected successfully and you have an SQL> prompt, you can change log-in account with the following command:

SQL> connect <username>/<password>@<tns alias>

The "tns alias" is the "nickname" for the database to which you are trying to connect. The "nickname" appears in the tnsnames.ora file that resides in your Oracle Home directory, in the network\admin sub-directory.

Let us know of your success.


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[zum]

Mufasa,

Thanks for the help, that worked.