Resolved an error reporting ORA-01034 and ORA-27101 when connecting Oracle11g
Resolving ORA-01034 and ORA-27101 errors when connecting to Oracle 11g
My local database version installed is Oracle 11G R2, when using plsql connection, the following error is reported ora-12514:
However, when using sqlplus in cmd to connect a user already created, the following error is reported:
Oracle not available ORA-01034
ORA-27101-shared memory realm does not exist
I checked several solutions on the Internet to solve oracle home and sid problems, or asked Net Configuration Assistant to recreate the local network service name. After practice, it does not work.
After summary, it is better to use the following methods to solve the problem:
1. First, take a look at the ORADIM. LOG File under ORACLE_BASE \ ORACLE_HOME \ DATABASE
E: \ app \ psun \ product \ 11.2.0 \ dbhome_1 \ database:
The following error is reported only when you view the log !!
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'listener _ ORCL'
2. Search for this error and find that the following statement is missing in the tnsnames. ora file:
LISTENER_MAXIMO =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521 ))
After the instance is added, restart the database instance service and the listener:
Use SQLPLUS and plsql to connect again. Okay!
For more information about Oracle, see the Oracle topic page? Tid = 12