We test the library server you use at ordinary times including test library PLSQL and JDBC connection is no problem, but in the test library in command has been prompt protocol adapter error, really don't understand why PLSQL can connect, but can't use the command

CodePudding user response:

You should cut a figure,

Up sqlplus quote this wrong for many reasons, such as input error, TNS configuration errors, etc.

CodePudding user response:

Add screenshots, local and remote login PLSQL can but only use up sqlplus on the server can't

CodePudding user response:

The TNS_ADMIN, this environment variable configuration? Confirm it,

CodePudding user response:

What all configuration, other PLSQL and JDBC can be connected, not only at the corresponding level server up sqlplus

CodePudding user response:

The server install multiple versions?

CodePudding user response:

Two set the environment variable oracle_home and oracle_sid,

CodePudding user response:

Above these methods just this problem tried, no.

CodePudding user response:

Environment variable is not configured, can take a look

CodePudding user response:

Either the database instance is not up, or to monitor service didn't rise, is not that is the problem of the registry

CodePudding user response:

You can check your configuration has a problem

CodePudding user response:

Up sqlplus user/password @ instance name, a try, may be the default connection instance is not normal start

CodePudding user response:

According to the PL/SQL connection to connect to try to see

CodePudding user response:

Up sqlplus username/password @ services can be connected, but not you directly up sqlplus

CodePudding user response:

Check the path, look at the https://blog.csdn.net/songyundong1993/article/details/85003942 is the problem