How to upgrade to Oracle 10g with the shortest downtime

Upgrading your hardware is usually easy, but upgrading your database ... There is no doubt that everyone has a painful experience. An experienced Oracle DBA is primarily concerned with the successful completion of upgrades and the downtime that may result. Success does not just mean that the upgrade process itself is done properly, but more importantly, the production application can run without fail in the upgraded database. In this article, we will provide some suggestions to minimize downtime and risk of failure by adopting mature processes and technologies.

10g "href=" Http://oracle.chinaitlab.com/UploadFiles_7269/200705/20070504135659835.rar > Upgrade to Oracle 10g with minimal downtime

Select Database services in the right column dropdown option of the window and click the Add Database button. Enter the global database name, such as MyOracle, in the database column that appears. Note that the global database name is different from the database SID, and the global database name actually controls the uniqueness of the global naming of the database in the same network segment through the domain name, such as the domain name controller under Windows, where you can enter myoracle.192.168.1.5. The Oracle home directory can be entered without filling out the SID, such as MyOracle.

Save the above configuration, by default you can find the listening profile under the ORACLE installation directory (under Windows such as D:oracleora92networkadminlistener.ora,linux/unix $ oracle_home/network /admin/listerer.ora). At this point, the Oracle server-side listener configuration is complete. 2, Local Service name configuration (Tnsnames) Local service name is based on the Oracle client network configuration, so if the client needs to connect to the database server to operate, you need to configure the client, its dependent object can be any one to connect the database server to operate the PC, It can also be the database server itself. As described earlier, Oracle's own graphical management tool Net Manager can be used to complete the configuration of Oracle clients. Select the name of the service in figure (a), then click the "+" button on the upper left side to pop up the following icon dialog box:

Figure (iv) Enter the net service name, such as MyOracle, click Next and go to the following icon dialog box:

Figure (v)

Select TCP/IP (Internet Protocol) and click Next, as shown below:

Figure (vi) Enter the host name and port number. Note that the host name and port number must be the same as the host name and port number configured by the database server-side listener. Click Next to the following icon:

Figure (vii) Select the service name (Oracle8i or later) and enter the service name. The service name is actually the global database name in the database server-side listener configuration, which must be the same as the latter. The connection type typically chooses a dedicated server, depending on the configuration of the database server, and if a shared database server is configured, the connection type is selected for the shared server, or it is recommended that you select a dedicated server (refer to the documentation for a description of the dedicated server). When configured, click Next

If the database server-side related services are started, you can test the connection by tapping the test button. Oracle defaults to test the connection through the Scott/tiger user, because the Scott user is a sample user with Oracle, the user may not be configured for a formal business database or a professional test database, so it is possible to change to a valid user login before the test succeeds.　　If the test connection here is unsuccessful, it does not matter, the first click Finish button to complete the configuration. Return to the Oracle Network Manager main window, save the configuration, and by default the local Service name profile can be found under the Oracle installation directory (Windows such as D:o 　　Racleora92networkadmintnsnames.ora,linux/unix $ oracle_home/network/admin/tnsnames.ora). Service naming under a tree directory can be changed to a service name consisting of any legal character by editing the Rename menu in the menu, noting that the service name cannot have a space character before it can be connected to the database server. 3, connect the database server (1) Start the server-side listener and the database service Linux/unix, start the Listener: $ lsnrctl Start shutdown Listener: $ lsnrctl Stop View listening status: $ LSNRCTL Status Startup database: $ Sqlplus/nologsql>conn sys@myoracle as Sysdba--here myoracle is the client local service name or Sql>conn/as that was previously configured sysdbasql> Startupwindows, start listener: C:lsnrctl Start Start Oracle Instance service: C:ORADIM–STARTUP–SID myoracle shutdown Oracle Instance service: c:oradim–shutdown– Sid MyOracle The above services must be started simultaneously for clients to connect to the database. Because the default configured listener name is listener, the above command starts the listener normally, and if the listener name is a different name, such as Alistener, you need to start it in the following ways: Linux/unix: $ lsnrctl Start Alistenerwindows: C:lsnrctl start Alistener (2) test methods for connecting to a database server test can be tested in the configuration of the local service name, or Third-party client tools.such as Pl/sql Developer, the most convenient is the use of Oracle's own Sqlplus tools, the following use Sqlplus for testing: C:sqlplus/nologsql>conn Zgh@myoracle has been connected.

Iv. Client Connection server-side FAQ To troubleshoot client-server connectivity problems, first check that the client configuration is correct (client configuration must be the same as the database server-side listener configuration), and then resolve it according to the error message. Several common connectivity issues are listed below: 1. Ora-12541:tns: No listeners obviously, the server-side listener is not started, and the client IP address or port is filled in correctly. Start Listener: $ lsnrctl Start or C:lsnrctl start2, Ora-12500:tns: The listener cannot start the dedicated server process for Windows, the Oracle instance service is not started. Start Instance service: C:oradim–startup-sid myoracle3, Ora-12535:tns: Operation Timeout There are many reasons for this problem, but it is mainly related to the network. To solve this problem, first check the client and server network is unblocked, if the network connectivity, then check the firewall at both ends to block the connection. 4, Ora-12154:tns: Unable to process service name check whether the service name entered is consistent with the configured service name. Also note the generated local Service name file (under Windows such as D:oracleora92networkadmin Tnsnames.ora,linux/unix $oracle_home/network/admin/ Tnsnames.ora) There must be no spaces before the first line of service name for each service. 5. Ora-12514:tns: The listener process cannot resolve the Service_Name open net Manager given in the connection descriptor, select the service name, and check that the service name is entered correctly in the Service tab. The service name must be the same as the global database name configured by the server-side listener. 6, the start of the listening service under Windows can not find the path to use the command or in the service window to start the listener can not find the path, or listen for service startup exception. Open the registry and enter the Hkey_local_machine/system/current Controlset/services/oracleorahome92tnslistener entry to see if the ImagePath string entry exists. If not, the setting value is D:oracleora92bintnslsnr, and the different installation path settings are changed accordingly. This approach also applies to Oracle instance services, ditto, to find like Hkey_local_machine/system/current Controlset/serviceS/oracle the servicemyoracle item to see if the ImagePath string entry exists, and if not, create a new, set value of D:oracleora92 BinORACLE.EXE myoracle. These are some of the common problems with the Oracle Client Connection server, and certainly cannot include all connection exceptions. The key to solving the problem is the method and the idea, not every question has a fixed answer.