- 1 year ago
Oracle failing with "Unable to retrieve text of NETWORK/NCR message 65535", seemingly not reading initSID.ora
The error message "Unable to retrieve text of NETWORK/NCR message 65535" typically indicates an issue with the Oracle network configuration or connectivity. It's possible that Oracle is not reading the initSID.ora
file correctly or the file is not properly configured.
Here are a few steps you can try to troubleshoot the issue:
Verify the location of the
initSID.ora
file: Make sure the file is located in the correct directory. By default, the Oracle initialization files are located in the$ORACLE_HOME/dbs
directory.Check the content of the
initSID.ora
file: Open the file and verify that it contains the correct configuration settings for your Oracle database instance. Make sure the necessary parameters are defined, such asDB_NAME
,DB_UNIQUE_NAME
,CONTROL_FILES
,LOG_ARCHIVE_DEST
, etc.Restart the Oracle service: After making any changes to the
initSID.ora
file, restart the Oracle service to ensure the changes take effect.Check the Oracle environment variables: Ensure that the necessary Oracle environment variables, such as
ORACLE_HOME
andTNS_ADMIN
, are set correctly. These variables are used by Oracle to locate the initialization files and network configuration.Verify the Oracle listener configuration: Ensure that the Oracle listener is configured properly to listen for incoming connections. Check the listener configuration file (
listener.ora
) and make sure it is correctly defined.
If you've followed these steps and are still experiencing issues, it's recommended to consult the Oracle documentation or reach out to Oracle support for further assistance. They can provide more specific guidance based on your environment and configuration.