Use this procedure to set up Oracle database permissions.
When completing Step 1 of this procedure, select and configure either the Oracle authentication method or the Solaris authentication method for fault-monitoring access.
Enable access for the user and password to be used for fault monitoring.
To complete this step, perform one of the following tasks.
To use the Oracle authentication method - For all supported Oracle releases, enter the following script into the screen that the srvmgrl command displays to enable access.
# svrmgrl connect internal; grant connect, resource to user identified by passwd; alter user user default tablespace system quota 1m on system; grant select on v_$sysstat to user; grant create session to user; grant create table to user; disconnect; exit; |
To use the Solaris authentication method - Grant permission for the database to use Solaris authentication.
The user for which you enable Solaris authentication is the user who owns the files under the $ORACLE_HOME directory. The following code sample shows that the user oracle owns these files.
# svrmgrl connect internal; create user ops$oracle identified by externally default tablespace system quota 1m on system; grant connect, resource to ops$oracle; grant select on v_$sysstat to ops$oracle; grant create session to ops$oracle; grant create table to ops$oracle; disconnect; exit; |
Configure NET8 for the Sun Cluster software.
The listener.ora and tnsnames.ora files must be accessible from all the nodes in the cluster. Place these files either under the cluster file system or in the local file system of each node that can potentially run the Oracle resources.
If you place the listener.ora and tnsnames.ora files in a location other than the /var/opt/oracle directory or the $ORACLE_HOME/network/admin directory, then you must specify TNS_ADMIN or an equivalent Oracle variable (see the Oracle documentation for details) in a user-environment file. You must also run the scrgadm(1M) command to set the resource extension parameter User_env, which will source the user-environment file.
The Sun Cluster HA for Oracle data service imposes no restrictions on the listener name-it can be any valid Oracle listener name.
The following code sample identifies the lines in listener.ora that are updated.
LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = logical-hostname) <- use logical hostname (PORT = 1527) ) ) . . SID_LIST_LISTENER = . . (SID_NAME = SID) <- Database name, default is ORCL |
The following code sample identifies the lines in tnsnames.ora that are updated on client machines.
service_name = . . (ADDRESS = (PROTOCOL = TCP) (HOST = logicalhostname) <- logical hostname (PORT = 1527) <- must match port in LISTENER.ORA ) ) (CONNECT_DATA = (SID = <SID>)) <- database name, default is ORCL |
The following example shows how to update the listener.ora and tnsnames.ora files given the following Oracle instances.
Instance |
Logical Host |
Listener |
---|---|---|
ora8 |
hadbms3 |
LISTENER-ora8 |
ora7 |
hadbms4 |
LISTENER-ora7 |
The corresponding listener.ora entries are the following entries.
LISTENER-ora7 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = hadbms4) (PORT = 1530) ) ) SID_LIST_LISTENER-ora7 = (SID_LIST = (SID_DESC = (SID_NAME = ora7) ) ) LISTENER-ora8 = (ADDRESS_LIST = (ADDRESS= (PROTOCOL=TCP) (HOST=hadbms3)(PORT=1806)) ) SID_LIST_LISTENER-ora8 = (SID_LIST = (SID_DESC = (SID_NAME = ora8) ) ) |
The corresponding tnsnames.ora entries are the following entries.
ora8 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = hadbms3) (PORT = 1806)) ) (CONNECT_DATA = (SID = ora8)) ) ora7 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = hadbms4) (PORT = 1530)) ) (CONNECT_DATA = (SID = ora7)) ) |
Verify that the Sun Cluster software is installed and running on all nodes.
# scstat |
Go to "Installing Sun Cluster HA for Oracle Packages" to register and configure the Sun Cluster HA for Oracle data service.