No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.

Knowledge Base

Oracle start there is a error code ORA-01012: not logged on

Publication Date:  2018-04-30  |   Views:  1344  |   Downloads:  0  |   Author:  t00555454  |   Document ID:  EKB1001542651


Issue Description

Oracle database start and stop show this error code ORA-01012: not logged on


Running the hostname -i command failed to resolve the host name to an IP address. Error hostname: Host name lookup failure

Edit the /etc/hosts file and configure the correct IP address and host name mapping relationship

After saving and exiting, run the hostname -i command again to check that the correct local IP address is displayed.

Restart the Oracle instance to start normally