It is prohibited to modify anything that involves oracle during the production period ., Time period oracle

It is prohibited to modify anything that involves oracle during the production period ., Time period oracle

This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/44560623

Warning:

It is prohibited to modify anything that involves oracle during the production period.

 

Description:

A database in a certain unit runs on a windows server. The version of oracle database is 817.

An engineer installed oracle9i client on the windows server, and then uninstalled the Oracle 9i client. It is unknown what other operations have been performed.

 

When our engineers took over, we found that there was no HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE in the registry.

Note:

After my experiments and testing Oracle 9i client_home deletion (oracle 817 has been installed before), I come to the conclusion:

1. uninstalling Oracle 9i client_home will not delete HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE.

 

Therefore, the lack of HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE is caused by other reasons.

 

 

Anyone familiar with oracle in windows knows what this means:

This means that the Oracle database instance cannot be started through the Windows Service OracleServerXXX, And the Oracle listener cannot be started (whether through the Windows service listening service or through lsnrctl start ).

 

The final conclusion: although the Oracle client on the windows database server does not seem to be a problem, windows is more troublesome than linux because of the Registry, so it is better to be careful:

1. It is prohibited to uninstall the Oracle client on the windows database server during the production period,

2. It is prohibited to modify anything related to oracle during the production period.

For example, in network/admin/sqlnet. ora under $ ORACLE_HOME, the following content is displayed:

# SQLNET.AUTHENTICATION_SERVICES = (NTS)

As you know, this setting will cause the following problems:

F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 23 10:51:22 2015Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.ERROR:ORA-01031: insufficient privilegesEnter user-name:

 

In contrast, the local Wei medical insurance program requires that the content in sqlnet. ora on the db server be # SQLNET. AUTHENTICATION_SERVICES = (ETS); otherwise, the medical insurance program cannot run.

 

In fact, at that time, I also considered deleting # first, but then I thought about the old cover, and I didn't touch the production environment. It was such an idea, saving me one time: if I delete #, the Medical Insurance front-end app will definitely not be able to connect to the database.