But PLSQL connection error
Listener. Ora configured in
Tnsnames. Ora configured in
CodePudding user response:
Question obviously,Why the content of the two configuration files is the same?
CodePudding user response:
You replace localhost with the IP address of the actual look again,CodePudding user response:
Determine surveillance launched?CodePudding user response:
We check the oracle service is started, check method is a computer - & gt;> Management - & gt;> Services and applications - & gt;> Service, and to find the oracle start the service, start the service OracleServiceORCL and OracleOraDb11g_home1TNSLister OracleDBCConsoleorcl startup,CodePudding user response:
First look at the Oracle server is started, check method is to control panel - management tools - service - find the beginning is Oracle server generally see two of the first and the second from server is open, if still can't open the listener. Ora configuration files, SID_LIST_LISTENER=(SID_LIST=
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=D: \ oracle \ product \ 10.2.0 \ db_1)
(the PROGRAM=extproc)
)
(SID_DESC=
(GLOBAL_DBNAME=former)
(ORACLE_HOME=D: \ oracle \ product \ 10.2.0 \ db_1)
(SID_NAME=former)
)
)
The LISTENER=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1))
(ADDRESS=(TCP) PROTOCOL=(HOST=10.5.134.104) (1521) PORT=)
)
)
CodePudding user response:
PLSQL unable to get 64 - bit database of OCI pack a 32-bit client configuration to a 64 - bit 32-bit client server-side TNS, again by PLSQL to connect,