Sample Header Ad - 728x90

ORA-12154 TNS: could not resolve the connect identifier specified with SQLPLUS

5 votes
3 answers
27866 views
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 Steps: 1. Opened command promt 2. Reach to the path of SQLPLUS (*C:\programs\Oracle\Ora11g\BIN*) 3. C:\programs\Oracle\Ora11g\BIN\sqlplus username@schema_name 4. Enter Password : ERROR: ORA-12154 TNS: could not resolve the connect identifier specified 5. But when i open this with the owner of the schema ,it works for me 6. C:\programs\Oracle\Ora11g\BIN\sqlplus schema_name@schema_name 7. Enter Password: 8. 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 My TNSNAME.ORA is under TNS_ADMIN folder Please help me out of this .
Asked by Gaurav Soni (276 rep)
Feb 18, 2013, 03:04 PM
Last activity: Sep 11, 2024, 01:40 PM