Oracle Database Discussions

Hi,

I have oracle 10g database server on solaris 10 and I usually connect using my solaris account and run sqlplus on the server itself. this works !

I have downloaded and installed oracle instant client for solaris 64 and I can run sqlplus command but I am confused on what should be the syntax on the command to connect to remote solaris 10 databse server where I have both system and oracle account.

I have tried sqlplus help but still I could not get correct sysntax which could be used to authenticate myself to oracle server.

I tried

sqlplus user@hostname:1512/SID

then it asked for password but when I typed password and pressed enter, it gave some error

but it again asked for username so I type user@SID and then password prompt - typed password and this works!

so I don't understand what should be the correct syntax so that in the first attempt only I am able to connect.

if possible please give the exact command with realworld examples,(I have tried with sqlplus -help already)

Thanks in advance.