Local oracle, CMD command line can log in, can sketch the SQL query, PLSQL unable to login, connection timeout

CodePudding user response:

Look at listening launched,
There is a 64 - bit system? PLSQL in a 64 - bit complains,
TNS is correct,

CodePudding user response:

Local oracle, CMD command line can log in, can only say that your database installed correctly and open state, local up sqlplus without listening also can log in

CodePudding user response:

PL/dev is a 32-bit and 64 - bit distinguish
You can have a look at the listening state LSNRCTL status

CMD without service name is not through listening to visit
With the service name through listening to access the database

CodePudding user response:

A because oracle service or service did not open PLSQL, another is oracle packed to have a problem, or open the server listener? The client with the TNS?