After successfully connecting to the database, check the listener status: lsnrctl status
Status READY status, which must be switched from non-archive to archive. The operation is as follows:
1. Shut down the database shutdown immediate and shut down normally;
2. Start the database to the mount status and start up mount. An error occurs:
3. Check the listener status at this time: lsnrctl status
Status BLOCKED status 4. Rewrite the listener. ora file (Blue is added)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = f: \ oracle \ product \ 10.1.0 \ Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = f: \ oracle \ product \ 10.1.0 \ Db_1)
(SID_NAME = orcl)
)
)
5. Restart the listener: lsnrctl start; check the status of lsnrctl:
Status UNKNOWN.
6. Connect to the instance, shut down the database, and start the database to the mount status. All operations are normal!
Check whether a service is registered dynamically or statically.
You can run the lsnrctl status Command to check whether the database is dynamically registered or static.
When the instance status is UNKNOWN, it indicates that the service is set for static registration, and the listener indicates that it does not know any information about the instance, only when the user sends a connection request, to check whether the instance exists.
The status of a dynamically registered database is indicated by READY or BLOCKED in the status information. No matter when the database is closed, the dynamically registered database will be logged out of the listener dynamically, and the related information will disappear from the status list, in this way, the listener will know its status no matter whether the database is running or closed.
To be supplemented...
**************************************** ********************
Oracle xe modification method
Solution:
Modify the tnsnames file in directory E: \ Oracle10gXEUniv \ app \ oracle \ product \ 10.2.0 \ server \ NETWORK \ ADMIN. ora, listener. ora changes the hosts following these two files to 127.0.0.1, and then restarts the OracleServiceXE and OracleXETNSListener services.
When pl/SQL developer connects to oracle, the error "ORA-12514: TNS: The listener currently cannot identify the Service requested in the connection descriptor" is reported, and the listener is modified again. ora file. Before modification, the file content is
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E: \ Oracle10gXEUniv \ app \ oracle \ product \ 10.2.0 \ server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E: \ Oracle10gXEUniv \ app \ oracle \ product \ 10.2.0 \ server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC_FOR_XE ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
The modification method is as follows: add A description of the database instance to be connected to in this file, that is, add a SID_DESC, and the database instance I connect to is XE, the added file content is:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E: \ Oracle10gXEUniv \ app \ oracle \ product \ 10.2.0 \ server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E: \ Oracle10gXEUniv \ app \ oracle \ product \ 10.2.0 \ server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = E: \ Oracle10gXEUniv \ app \ oracle \ product \ 10.2.0 \ server)
)
/* The red font section is the instance description of the newly added database instance XE, note that the ORACLE_HOME of the Instance description cannot be added as other instances (PROGRAM = extproc), otherwise the "ORA-28547: TNS: failed to connect to the server. It may be a Net8 management error." */
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC_FOR_XE ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
Author bubble Park
