Need info on running sqlplus

[Pankajj]

Hi !

Can somebody tell me what is difference between

1. sqlplus system/manager@DELPHI

&

2. sqlplus < Hit Enter > Key in Login name & Password.

First one connect fine ! But second one gives error ORA-12545.

Trying to connect from client unix box to oracel instance.

What i have checked so far :

1. Host name is correct !

2. DNS settings are okay !

3. ORACLE_SID & ORACLE_HOME are correct.


Regards !
Pankaj Jain

[sambavan]

Are you trying to connect from the client machine, on that case, set the following in your env it it was a n Unix system

TWO_TASK=< service_name >

Then try to connect it. It should go through

Good luck.
Sam

[Dave_A]

If you are on UNIX (not sure about other OS), then if you can make it work, the second method is more secure - other users that can list processes can see the username and password in the process listing if you specify

sqlplus system/manager@database

If you can't make it work, try

sqlplus system@database

This will allow other users to see the username in a process listing, but not the password. You will then be prompted for the password.

HTH

David.

[Pankajj]

Hi sambavan !

I setted the TWO_TASK to INSTANCE_NAME it worked ! But if i set it to SERVICE_NAME , it doesn't like.

Thanks for your help.

Can u explain me what is TWO_TASK variable is for ? And differnece between running sqlplus and keying in password and user name on request rather then writing
sqlplus user/password@INSTANCE on command line

Regards
Pankaj


--------------------------------------------------------------------

Hi Dave_A ,

I appriciate your message reagarding the security. I will implement the way u said in your message .

Regards
Pankaj Jain

[sreddy]

The difference is:

You are setting your instance name locally (temporarily for that session) thru two_task parameter and connecting to SQL*Plus. So , it defaults to what you have set in TWO_TASK parameter.

You care connecting to whatever the service_name/database you wanted by explicitly specifying @xyz.

[url]http://www.dbasupport.com/forums/showthread.php?threadid=6208[/url]

[sambavan]

One other point I would like to make using sqlplus direct connection is as follows. If you are just planning to use the sql editor to execute the sqcripts or do query form the client manchine and would only be connecting to one perticular instance, then use TWO_TASK. But again you don't have to worry that you wouldn't be able to connect to the other systems, other than TWO_TASK, you can use

sqlplus user_name@service_name

Try to refrain from giving the

sqlplus sys/password@service_name

on Unix systems because, there you would be compromising your password. (i.e, any one who does the ps -ef would be able to see your username and password :confused: )

So one world of advice, don't use

sqlplus sys/password@servicename
or
sqlplus sys/password

Good luck,
Sam