Solution: Oracle cannot be started at 10 Gb under Asianux3

Keywords: Hongqi Asianux3 + Oracle 10g R2 for Linux x86-64

1. Receive a consulting phone number in the morning: Oracle cannot be started in Linux. We will try to solve the problem at the site in the afternoon.

2. After arriving at the site, learn the basic information as follows:

*. Operating System: Asianux3

*. Database: Oracle 10g R2 for Linux x86-64

*. Problem: After the server is migrated to the new data center, the previously installed Oracle database cannot be used normally. When the client connects to the server, a listener error is reported.

3. The problem was found a few days ago.

After arriving at the scene, we found that the listener. ora, sqlnet. ora, and tnsnames. ora files on the server had been completely modified.

Try to restore one by one.

4. After the preceding file is modified and restored, the dbconsole of Oracle cannot be started.

An error is reported when you use the emctl status dbconsole or e mctl start dbconsole command:

-----------

Enter the Configuration file.
/Opt/app/oracle/product/10.2.0/db_1/Solaris/j2ee/OC4J_DBConsole_localhost_orcl not found.

-----------

5. Because the new office building is being renovated, the new IDC has not been connected to the external network. If you cannot use your laptop for online queries, you have to use your mobile phone.

Generally, the Oracle service cannot be started because the machine name of the server bound to Oracle is modified.

However, after the server is relocated, only the IP address is modified and the machine name is not modified.

Confused for a moment.

6. The system is currently being tested and deployed, and there is no data in the database.

After obtaining the consent, we decided to reinstall Oracle.

7. After you uninstall Oracle, use Oranavi for a new installation.

The previous installation was successful. During the environment detection phase, the network device reports an "not executed" message. Ignore and continue.

When the number of database instances created reaches 74%, an exception occurs:

-----------

The null Value of the PORT parameter is invalid.

See the log files in/opt/app/oracle/product/10.2.0/db_1/export toollogs/dbca/orcl/emConfig. log.

-----------

An error occurred while installing the database instance. After confirming, continue to Complete Oracle installation.

After the installation is complete, it is found that tnsnames. ora should have been a PORT of 1521, which says "null": PORT = null.

8. port 1521 is suspected to be occupied. Or port 1521 is not explicitly specified in a configuration file or Oracle user's environment variable.

Tossing.

After a circle, no valuable clues were found.

Instead, use dbca to create a second database instance for testing and installation.

If the same problem occurs, an exception is thrown when the database instance is created to 74%: the null value of the PORT parameter is invalid.

1 2 Next Page