First off I want to say I am a novice when it comes to oracle, but here is my issue I have a remote oracle database that I need to get into and reset my password. I was told by the DBA that in order for me to change the password I would need the oracle 11 client, before I was using oracle 10 client. Well after installing the client and ensuring my TNSNames.ora file has the proper network configuration. I did the following:
1. opened up a command prompt and set my oracle home
2. set the oracle sid
3. typed SQLPLUS /NOLOG
4. typed: my firstname.lastname@example.org [enter] password
Once that is entered I get the following:
ORA-12537: TNS:connection closed
What am I doing that is wrong I need help to resolve this.
Thanks in advance.