Hello,
I'm learning Oracle. I currently have 2 database instances running. I wanted to log into one of the instances and used the following command from the command line:
sqlplus system as sysdba/abc123@ocp11gsid
where 1234 is the password for the system user in the ocp11gsys instance.
when I issue the command above, SQL*Plus still asks me for the password. I don't understand why it is asking me for the password since I've supplied it on the command line.
What is the proper command line so it doesn't ask me for the password ? (without setting the ORACLE_SID environment variable - basically I want to learn how to specify the user, his/her password and the sid, all in the sqlplus command line, without being prompted for the password which I have already specified.)
Thank you for your help,
John.