Some boring questions about ORACLE :;..? /\ |! @*

1. The oracledbconsoleorcl service cannot be started locally: You can stop the network. To start this service, the IP address of the local machine must be the same as the IP address used to create the database at the time. If the network is disconnected, it will be okay.

2. The OEM cannot add the database to the tree (mainly for win7 & Win8): run as an administrator.

3. When the sqlplus command is run in cmd, "SP2-1503: Unable to initialize Oracle call interface SP2-1503: Unable to initialize oracle": Enter db_1/bindirectory to find sqlplus.exe: Set compatibility, check to run as administrator.
4. Oracle regexp_like seems powerful ..
Think of this now...

Bytes -------------------------------------------------------------------------------------------------------------------
ORA-12560: TNS: protocol adapter error resolved when sqlplus was connected to Oracle

Cause 1: The listening service is not started.
Solution: Win + R (Windows key + r key --> quickly open "run") --> enter services. msc ---> to start the oracle... tnslistener Service

Cause 2: The database instance service (oracleservice...) is not started. (... Indicates your database instance. The default value is orcl or your own database instance. Xe is used for the Xe version)
Solution: Win + r --> enter services. msc ---> Start the oracleservice... service

For more information, see the following:

Cause 3: The registry is faulty.
Solution: Win + r --> enter Regedit --> Find HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle \ key_oraclehome... (The Xe version is key_xe)
-------> Double-click oracle_sid ----> enter the name of your database instance ..

Or enter SET oracle_sid = your database instance under DOS (this is not good)
 
Note: cause 3 is generally because many Oracle database instances have been created, and the database instances created by the user cannot be used due to various reasons (services are unavailable, files are deleted, and so on ), to connect to the original default orcl, the value of the registry should be the value of your own instance ..
 
If the problem persists, disconnect the network or change the IP address to the IP address when installing Oracle (therefore, we recommend that you do not enable the network when installing Oracle to avoid unnecessary troubles ..)