I am using Toad to connect my database and its working fine for me . But when i try to connect with the same credential , i am getting the error message as shown below:
ORA-12154 TNS: could not resolve the connect identifier specified
- Opened command promt
- Reach to the path of SQLPLUS (C:\programs\Oracle\Ora11g\BIN)
- C:\programs\Oracle\Ora11g\BIN\sqlplus username@schema_name
Enter Password :
ERROR: ORA-12154 TNS: could not resolve the connect identifier specified
But when i open this with the owner of the schema ,it works for me
Connected to :......................
So,my question is why my username is not able to connect that particular schema ,while the owner of that schema can connect . Note:I can connect to that schema with my username with Toad ,but not with sqlplus
TNSNAME.ORA is under
Please help me out of this .