This problem is to install the Oracle database in PLSQL connection can be normal use, but I don't want to but the Oracle powered up for the service that was card while I put all the service is set to manual but I restart the computer after using PLSQL even no report on the wrong not look the other way on the Internet for a solution to want to know what reason can cause this way

CodePudding user response:

Listen to not up the client can't access the server

CodePudding user response:

The content of the original poster to the listener. Ora hair up,

CodePudding user response:

Service is not registered,
1, wait a minute, maybe take a dynamic registration
2, in the control panel, restart the service, OracleServiceORCL
3, up sqlplus/nolog
Conn/as sysdba
The alter system register;

CodePudding user response:

CodePudding user response:

CodePudding user response:

There are two LISTENER. Ora both above

CodePudding user response:

4 # this figure, the first part, the SID_DESC this, again a copy, SID_NAME renamed your instance name, other can not move, try to restart the monitor;

CodePudding user response:

CodePudding user response:

get

CodePudding user response:

Right to add the listener. Ora;
Restart the oracle server, and check whether all oracle services launched;
The oracle client.net Cofiguration Assistant to add or correct to reconfigure the instance name