For Oracle databases, the same name is case-insensitive, indicating different database instances. When the Instance name of the static listener is inconsistent with the corresponding database instance,
For Oracle databases, the same name is case-insensitive, indicating different database instances. When the Instance name of the static listener is inconsistent with the corresponding database instance,
Remote logon fails due to the Case sensitivity of SID_NAME during static listening configuration.
For Oracle databases, the same name is case-insensitive, indicating different database instances. Once the Instance name of the static listener is inconsistent with the corresponding database instance, the database cannot be connected.
Oracle ORA-12523 errors caused by static listening
Oracle static Listener Configuration example
Listener registered statically)
Because the original port 1521 is intended for another instance, the current instance uses a static listener to use another port. After the listener is restarted, an error occurs during Remote logon.
SQL> conn test/test @ 127
ERROR:
A ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
View the oracle home Directory and oracle_sid
[Oracle @ ggfwweb admin] $ echo $ ORACLE_HOME
/U01/app/oracle/10gR2/db
[Oracle @ ggfwweb admin] $ echo $ ORACLE_SID
Hygeia
[Oracle @ ggfwweb admin] $ ps-ef | grep pmon
Oracle 25830 1 0? 00:00:00 ora_pmon_hygeia
Oracle 25950 25585 0 00:00:00 pts/1 grep pmon
View the listener File
[Oracle @ ggfwweb admin] $ cd $ ORACLE_HOME/network/admin
[Oracle @ ggfwweb admin] $ ls
Listener. ora listener. ora. bak samples shrept. lst tnsnames. ora
[Oracle @ ggfwweb admin] $ cat listener. ora
# Listener. ora Network Configuration File:/u01/app/oracle/10gR2/db/network/admin/listener. ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =/u01/app/oracle/10gR2/db)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = HYGEIA)
(ORACLE_HOME =/u01/app/oracle/10gR2/db)
(SID_NAME = HYGEIA)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.142.11.108) (PORT = 1568 ))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0 ))
)
)
HYGEIA is used in the listening file, and ORACLE_SID is hygeia.
Change SID_NAME = HYGEIA to SID_NAME = hygeia and restart the listener.
[Oracle @ ggfwweb admin] $ lsnrctl stop
LSNRCTL for Linux: Version 10.2.0.5.0-Production on 03-JUL-2014 10:03:32
Copyright (c) 1991,201 0, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.142.11.108) (PORT = 1568 )))
The command completed successfully
[Oracle @ ggfwweb admin] $ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.5.0-Production on 03-JUL-2014 10:03:53
Copyright (c) 1991,201 0, Oracle. All rights reserved.
Starting/u01/app/oracle/10gR2/db/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.5.0-Production
System parameter file is/u01/app/oracle/10gR2/db/network/admin/listener. ora
Log messages written to/u01/app/oracle/10gR2/db/network/log/listener. log
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 10.142.11.108) (PORT = 1568 )))
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC0 )))
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.142.11.108) (PORT = 1568 )))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0-Production
Start Date 03-JUL-2014 10:03:53
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File/u01/app/oracle/10gR2/db/network/admin/listener. ora
Listener Log File/u01/app/oracle/10gR2/db/network/log/listener. log
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 10.142.11.108) (PORT = 1568 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC0 )))
Services Summary...
Service "PLSExtProc" has 1 instance (s ).
Instance "PLSExtProc", status UNKNOWN, has 1 handler (s) for this service...
Service "hygeia" has 1 instance (s ).
Instance "hygeia", status UNKNOWN, has 1 handler (s) for this service...
The command completed successfully
[Oracle @ ggfwweb admin] $ sqlplus/nolog
SQL * Plus: Release 10.2.0.5.0-Production on Thu Jul 3 10:04:12 2014
Copyright (c) 1982,201 0, Oracle. All Rights Reserved.
SQL> conn/as sysdba
Connected.
SQL> show parameter local_listener