Oracle Parallel Server Getting Started Release 8.0.4 for Windows NT A55925-01 |
|
This chapter describes the configuration tasks to create an operating Oracle Parallel Server.
Specific topics discussed are:
The initialization files, INIT_COM.ORA and INITSID.ORA are installed in the ORACLE_HOME\OPS directory. To use Oracle Parallel Server Manager and to avoid specifying the PFILE parameter when starting the database (STARTUP PFILE=C: ORANT\OPS\INITSID.ORA), copy these file to the ORACLE_HOME\DATABASE file where initialization files are normally located.
To change the location of the initialization files:
The Oracle SETLINKS utility creates symbolic links to raw logical drives.
For example, with the SETLINKS utility, you can create a symbolic link called OPS_log1t1 to the second logical drive on the second physical disk:
OPS_log1t1 \Device\Harddisk2\Partition2
The SETLINKS utility comes with the following ASCII files, with symbolic link names already associated with raw partitions. Each node requires two log files. If you have more than a three to four cluster, additional symbolic link names must be linked to the files.
Below is a description of the symbolic link names:
You can use a worksheet similar the one below to assist with the process:
For example, the worksheet for the two nodes shown in section "Step 2: Create Logical Drives In an Extended Partition" in Chapter 3, "Performing Pre-Installation Tasks" looks like:
Additional Information:
See Chapter 3, "Performing Pre-Installation Tasks", for further information about the Disk Administrator. |
C:\> CD ORACLE_HOME\OPS C:\ORACLE_HOME\OPS> SETLINKS /F:ORALINK1.TBL
SETLINKS maps the drives to the symbolic label names:
Oracle Corporation. Copyright (c) 1997. All rights reserved. Created Link: Created Link:OPS_log1t1 = Device:\Device\Harddisk1\Partition1 Created Link:OPS_log2t1 = Device:\Device\Harddisk1\Partition2 Created Link:OPS_sys01 = Device:\Device\Harddisk1\Partition3 Created Link:OPS_usr01 = Device:\Device\Harddisk1\Partition4 Created Link:OPS_rbs01 = Device:\Device\Harddisk1\Partition5 Created Link:OPS_tmp01 = Device:\Device\Harddisk1\Partition6 Created Link:OPS_log1t2 = Device:\Device\Harddisk2\Partition1 Created Link:OPS_log2t2 = Device:\Device\Harddisk2\Partition2 Created Link:OPS_cntr01 = Device:\Device\Harddisk3\Partition3 Dos devices updated successfully.
If the cluster has third or fourth node, SETLINKS must be run again with OPSLINK2.TBL (for the third node) or OPSLINK3.TBL for the fourth node.
C:\> CD ORACLE_HOME\OPS C:\ORACLE_HOME\OPS> SETLINKS /F:ORALINK2.TBL C:\ORACLE_HOME\OPS> SETLINKS /F:ORALINK3.TBL
C:\ORACLE_HOME\OPS> SETLINKS /D
SETLINKS shows how the symbolic link names have been mapped:
Oracle Corporation. Copyright (c) 1997. All rights reserved.
OPS_log1t1 = \Device\Harddisk1\Partition1
OPS_log2t1 = \Device\Harddisk1\Partition2
OPS_sys01 = \Device\Harddisk1\Partition2
OPS_usr01 = \Device\Harddisk1\Partition2
OPS_rbs01 = \Device\Harddisk1\Partition5
OPS_tmp01 = \Device\Harddisk1\Partition6
OPS_log1t2 = \Device\Harddisk2\Partition1
OPS_log2t2 = \Device\Harddisk2\Partition2
OPS_cntr01 = \Device\Harddisk2\Partition3
...
Links can be removed or ignored by changing the contents of the ORALINKx.TBL files and running it through SETLINKS again.
To ignore links:
Insert a `#" at the beginning of a line to denote a comment, which is ignored by SETLINKS.
To remove an existing symbolic link:
List a symbolic link without a device path in the ORALINKx.TBL file.
For example:
OPS_log1t1 OPS_log2t1 \Device\Harddisk1\Partition2 OPS_sys01 \Device\Harddisk1\Partition3 OPS_usr01 \Device\Harddisk1\Partition4 OPS_rbs01 \Device\Harddisk1\Partition5 OPS_tmp01 \Device\Harddisk1\Partition6 OPS_log1t2 \Device\Harddisk2\Partition1 OPS_log2t2 \Device\Harddisk2\Partition2 OPS_cntr01 \Device\Harddisk2\Partition3
This removes the OPS_log1t1 link and creates the other links specified.
To configure the Operating System Dependent (OSD) components:
See your OSD vendor documentation for instructions about configuring the OSD components, making sure the:
CAUTION: When configuring domains, two instances cannot reside on the same machine and be in the same domain. |
After the OSD components have been configured, an OracleServiceSID for each instance must be created.
To create OracleServiceSID:
C:\ORACLE_HOME\BIN> CRTSRV SID
For example, to create OracleServiceOPS1 on the primary node:
C:\ORACLE_HOME\BIN> CRTSRV OPS1
The Services window appears:
Additional Information:
See Chapter 6, "Using Multiple Oracle Homes," in the Oracle8 Enterprise Edition Getting Started for Windows NT for a description of HOME_NAME and multiple Oracle homes. |
The Service dialog box appears:
The Add User dialog box appears:
The Service dialog box reappears.
The Services window reappears.
The SID for an instance must be set in the registry to allow instance recognition when you access a database from a node. When you connect to a database, Oracle Parallel Server will be able to resolve the SID name.
Oracle Parallel Server requires the ORACLE_SID registry value to be manually added to the following location:
To add the ORACLE_SID registry value:
C:\> REGEDT32
The Registry Editor window appears:
The Add Value dialog box appears:
The String Editor dialog box appears:
Registry Editor adds ORACLE_SID.
The registry exits.
Configure the nodes and clients for connections. Net8 clients communicate with Oracle8 servers through service names, which are easy to remember aliases for database addresses.
Each node must have the following configuration files in ORACLE_HOME\NET80\ADMIN:
Two tools are available for modifying these files:
If you want to use the Oracle Performance Manager in addition to Oracle Enterprise Manager, Oracle recommends using the OPSCONF utility to generate the needed SQL script for Oracle Performance Manager. Otherwise, you must generate the file manually. See "Step 3: Configure Oracle Performance Manager" in Chapter 6, "Installing and Configuring Oracle Parallel Server Manager".
The steps to perform to configure the network include:
To stop the listener:
C:\> NET STOP OracleHOME_NAMETNSListener80 C:\> NET STOP OracleHOME_NAMETNSListener80LSNR
(where LSNR is the non-default listener name)
A message appears, confirming you want to stop the listener. Click Yes.
Configuration files can be created with the OPSCONF utility or Oracle Net8 Easy Config. In order to use Oracle Performance Manager, however, you must use OPSCONF.
Below are instructions for both methods:
The OPSCONF utility creates the following:
These files are created on the node in ORACLE_HOME\OPS. After creation, you need to move the files to their proper configuration file names and to the proper machines.
The TNSNAMES.ORA created with OPSCONF is not compatible with the TNSNAME.ORA created with Oracle Net8 Easy Config.
To create the configuration files:
C:\ORACLE_HOME\BIN> OPSCONF
OPSCONF runs in interactive mode, prompting you with configuration questions. Bold indicates user input:
Enter the name of the Oracle Parallel Server database.
database_name
The database name is defined in the INIT_COM.ORA file in ORACLE_HOME\DATABASE. The database name is defaulted to OPS.
ERROR MESSAGE: If you receive the following error message, the Performance and Management component is not supported by your vendor. You must use SQL*Net Easy Configuration to create the configuration files. Failed to load path\pm.dll ERROR: Unable to access configuratin information. Additional Information: See "Using Oracle Net8 Easy Config". |
Enter the port number of the listener (Default=1526).
port_number
Press [Enter] to accept the default value.
Enter the port number of the Oracleagent (Default=1748).
Press [Enter] to accept the default value unless you have changed the port number.
All the configuration files and the OPS_DBL.SQL script are created in ORACLE_HOME\OPS.
Or, merge it with your existing TOPOLOGY.ORA.
Additional Information:
See Chapter 6, "Configuring the Network", in the Net8 Getting Started for Windows NT and Windows 95. |
Oracle Net8 Easy Config creates a TNSNAMES.ORA file.
A TNSNAMES.ORA created with Oracle Net8 Easy Config is not compatible a TNSNAME.ORA created with OPSCONF.
To configure service names:
For example, to modify the file for the primary node's OPS1 instance:
SID_LIST_lISTENER_NAME= (SID_LIST = (SID_DESC = (SID_NAME = OPS1)
To start the listener:
C:\> NET START OracleHOME_NAMETNSListener80 C:\> NET START OracleHOME_NAMETNSListener80LSNR
(where LSNR is the non-default listener name)
A message appears confirming that you want to stop the listener. Click Yes.
To ensure the files are configured correctly:
SVRMGR> CONNECT INTERNAL/
PASSWORD@
SERVICE_NAME
If there is an error in connecting, you must troubleshoot your installation. Typically, there is a problem with the IP address, host name, or SID.
Creating an Oracle Parallel Server database involves generating:
To create the Oracle Parallel Server database:
Note: Prior to starting a OracleServiceSID service, the OraclePGMSService service must be running. If you used the CRTSRV script in "Step 4: Create Services", OraclePGMSService automatically starts when the OracleServiceSID service is started. If you chose to create your services with another method, you can still have OraclePGMSService start up automatically with a OracleServiceSID service by entering the following at the command for each node:
|
C:\> CD ORACLE_HOME\OPS C:\ORACLE_HOME\OPS> SVRMGR30 SVRMGR> @OPSALL.SQL
The OPSALL.SQL script:
To start the Oracle Parallel Server database in parallel mode:
This file is re-created with new Oracle Parallel Server messages.
Note: Prior to starting a OracleServiceSID service, the OraclePGMSService service must be running. If you used the CRTSRV script in "Step 4: Create Services" of this chapter, OraclePGMSService automatically starts up when the OracleServiceSID service is started. If you chose to create your services with another method, you can still have OraclePGMSService start up automatically with a OracleServiceSID service by entering the following at the command for each node:
|
C:\> NET START OracleServiceOPS1
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> STARTUP
The first instance to start up in shared mode determines the values of the global constant parameters for the other instances. The control file records the values of the GC_* parameters when the first instance starts up.
When another instance attempts to start up in shared mode, the Oracle Server compares the values of the global constant parameters in its parameter file with those already in use and issues a message if any values are incompatible. The instance cannot mount the database unless it has the correct values for its global constant parameters.
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> STARTUP
Note: If PARALLEL_SERVER is set in the INIT_COM.ORA file, you do not have specify STARTUP PARALLEL. You also do not have specify the PFILE parameter when starting the database (STARTUP PFILE=C: ORANT\OPS\INITSID.ORA) if you followed the procedure in "Step 1: Copy Initialization Files" of this chapter. |
Below is a sample of the trace file, indicating successful startup for two nodes:
Thu Oct 30 15:22:59 1997 Reconfiguration started List of nodes: 1,2, Lock DB frozen Non-local Process blocks cleaned out Non-local Group blocks cleaned out Resources and locks cleaned out Traffic controller Initialized Communication channels reestablished Submitted all rdomain info Submitted all remote-lock requests Update rdomain variables Dwn-cvts replayed, VALBLKs dubious All grantable locks granted Thu Oct 30 15:23:02 1997 Reconfiguration complete
To verify instances are running:
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> SELECT * FROM V$ACTIVE_INSTANCES;
The following output is returned:
INST_NUMBRE INST_NAME ----------- --------- 1 node1:ops1 2 node2:ops2 3 node3:ops3 . . .
CAUTION: If another node is reconfigured after this table has been accessed and this statement is issued again, only the last node whose database was started displays. |
C:\> SVRMGR30
SVRMGR> CONNECT SCOTT/TIGER
SVRMGR> SELECT * FROM EMP;
The employee table displays:
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO --------- ---------- --------- --------- --------- --------- --------- --------- 7369 SMITH CLERK 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 7566 JONES MANAGER 7839 02-APR-81 2975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 10 14 rows selected.
SVRMGR>UPDATE EMP
SET SAL = SAL + 1000 WHERE ENAME = `MILLER'; SVRMGR>COMMIT;
SVRMGR> SELECT * FROM EMP;
MILLER's salary should now be $2,300, indicating the all the instances can see the database.