Install Oracle9i and 10g on Windows2000 Server

The following article is intended for new users who want to use Windows to build a website, and Oracle 9i/10g to install and build a database background. The installation steps are as follows:
Operating System: windows2000 server
Oracle9i + oracle10G102
Step: first install 9i and then 10 Gb)
1. First install oracle9i, and then close all services.
2. Install oracle10G. The installation path is different from 9i.
3. restart the system's personal behavior), modify the oracle9i listener port listener. ora1522), and modify the relevant ports in the tnsnames. ora and snmp_ro.ora files.

After 9i is installed, you can log on, but "ORACLE unavailable" appears when you click"
Method: sqlplus/nolog
Conn sys/sys as sysdba
Startup
After running the preceding command, you can log on

After 10 Gb listening port is installed and the 9i listening port is modified, "ORACLE unavailable" also appears in 9i. The method in method 1 cannot be used. Execute tnsping orcl9i to find the 10 Gb directory pointing

Method 1: choose my computer> Properties> advanced> environment variable> path. Change the path value to "oracle9i \... \ bin "to" oracle10g \... \ bin ", restart the system and use problem 1.

Method 2: without changing the path value, modify the tnsnames. ora file under 10 Gb, and add the configuration in 9i to the tnsnames. ora file of 10, as well as the tnsnames. ora file of 9i. Run the following command to start the 9i Database: (for the modified tnsnames. ora file, see the following)
Sqlplus/nolog
Connsys/sys @ orcl9ias sysdba
Startup

10g tnsnames. ora
========================================================== ================

ORCL10G =
(DEscr resume ptION =
(ADDRESS = (PROTOCOL = TCP) (HOST = xt-b271dac81b07) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl10g)
)
)
ORCL9I =
(DEscr resume ptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = xt-b271dac81b07) (PORT = 1522 ))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL9I)
)
)
EXTPROC_CONNECTION_DATA =
(DEscr resume ptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

========================================================== ================

9i tnsnames. ora
========================================================== ================

ORCL10G =
(DEscr resume ptION =
(ADDRESS = (PROTOCOL = TCP) (HOST = xt-b271dac81b07) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl10g)
)
)
ORCL9I =
(DEscr resume ptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = xt-b271dac81b07) (PORT = 1522 ))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL9I)
)
)
Instanchttp =
(DEscr resume ptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = xt-b271dac81b07) (PORT = 1522 ))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http: // HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DEscr resume ptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0 ))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

If you are interested, pay attention to related articles on the website.

1. What is unknown about Oracle performance diagnosis?
2. How to remotely connect to the mongoel 9i Database Using dtu
3. Code example of Oracle multi-Table query optimization
4. Analyze the default port number modified by Oracle
5. Introduction to five Oracle ERP online preparation experiences