Up sqlplus can connect to the oracle database, but PLSQLDeveloper sometimes can successfully log in, sometimes Tns listener service cannot connect descriptor the request service, turn to the great god

CodePudding user response:

Up sqlplus can connect to the oracle database, because you are local and listeners dispensable,
PLSQLDeveloper login error that is a listener configuration has a problem,
Check respectively listener. Ora and tnsnames. Ora configuration,

CodePudding user response:

Use up sqlplus is how connection? In PLSQL dev how connection, hair figure

CodePudding user response:

reference 1/f, faint blue water fountain response:

up sqlplus can connect to the oracle database, because of who you are, but because the local login, listeners dispensable,
PLSQLDeveloper login error that is a listener configuration has a problem,
Check respectively listener. Ora and tnsnames. Ora configuration,

Plsqldeveloper sometimes can connect the success sometimes may not be a how to change the configuration

CodePudding user response:

First see if Oracle server is not open to view mode control panel - management tools - service - find the lead for the first and the second from bottom of Oracle server is open, and then look at the listener. Ora configuration file whether to have this code, you can add up, if not yet check tnsnames ora file whether the HOST=the IP address and native server address,
(SID_DESC=
(GLOBAL_DBNAME=former)
(ORACLE_HOME=D: \ oracle \ product \ 10.2.0 \ db_1)
(SID_NAME=former)
)
)

CodePudding user response:

The listener. Ora and tnsnames. Ora file configuration is stuck, beat you up sqlplus and PLSQL connection string out look, LSNRCT and see the results of the status