This content has been marked as final. Show 4 replies
i have a windows 2008r2 server [vm3]. i installed the Oracle 11gr2 on this server, the SID is [orclvm3]. (almost all default option)Now when i login the server [vm3], I can't access the database through sqlplus,
c:\>sqlplus sys/syspassword@orclvm3 as sysdba
error message: ORA-12154: TNS: could not resolve the connect identifier specified.
On the server, i tried to open page https://localhost:1158/em. i can login, but i can't see the server status in 'home' tab, it shows: agent unreachable. strange enough, in 'server' and 'schema' tab, i can see all the tables and users.
On another pc [pc1], i have no problem to query the tables through sqldeveloper!!! but same as open OEM from server locally, can't see server status in OEM page https://vm3:1158/em.
can anyone please tell me what's wrong? i was thinking tnsname.ora, but someone told me access db locally doesn't use tns.
There are two ways of access database on a server itself. One uses tnsames.ora and other don't.
If you do not want to use tnsnames.ora, you should not be using @
sqlplus sys as sysdba
If you want to use sys/syspassword@orclvm3 , then you have to create listener and tnsnames.ora.
You have to create a listener and tnsnames.ora files if you want to login as a client.
Listener on the server and tnsnames.ora on the client machine where you want to connect from.
Please mark your question answered if you got your solution.
new4oracle wrote:see: [url http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/] Help! I can’t connect to my database
i did what you said, it works. but i can't always login the server and do my stuff. can you please tell me how to make OEM work(locally and remotely), also be able to connect through sqlplus with @.
see: [url http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/] Help! I can’t connect to my database (part duex)
see: [url http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/] ora-12154 TNS:could not resolve the connect identifier specified
And NO network request of any kind that references 'localhost' or ip address 127.0.0.1 will ever leave the machine from which such request is made.