OERR 이란?
Oracle을 설치 하게 되면 사용할 수 있는 기능으로 $ORACLE_HOME/bin/ 아래 있습니다.
Oerr 을 이용하여 아래와 같이 해당 Error 가 무엇 인지와 Error에 대한 솔루션을 확인 하실 수 있습니다.
ORA-XXXXX 메시지 말고도 TNS-XXXXX 메시지 도 확인이 가능합니다.
[oracle@orcl ~]$ oerr ora 12514
12514, 00000, “TNS:listener does not currently know of service requested in connect descriptor”
// *Cause: The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a service name for a service (usually a database service)
// that either has not yet dynamically registered with the listener or has
// not been statically configured for the listener. This may be a temporary
// condition such as after the listener has started, but before the database
// instance has registered with the listener.
// *Action:
// – Wait a moment and try to connect a second time.
// – Check which services are currently known by the listener by executing:
// lsnrctl services <listener name>
// – Check that the SERVICE_NAME parameter in the connect descriptor of the
// net service name used specifies a service known by the listener.
// – If an easy connect naming connect identifier was used, check that
// the service name specified is a service known by the listener.
// – Check for an event in the listener.log file.
[oracle@orcl ~]$