Installation Notes for Oracle 10g R2 on Solaris 10

Installation notes for Oracle 10g R2 on Solaris 10, Sun Fire 2900.

Storage für Oracle

Disks für ASM labeln

Jede LUN labeln: Slice 6, Cylinder 1-$

format
Searching for disks...done
 
 
AVAILABLE DISK SELECTIONS:
       0. c1t0d0 <SUN72G cyl 14087 alt 2 hd 24 sec 424>
          /ssm@0,0/pci@18,600000/scsi@2/sd@0,0
       1. c1t1d0 <SUN72G cyl 14087 alt 2 hd 24 sec 424>
          /ssm@0,0/pci@18,600000/scsi@2/sd@1,0
       2. c5t6NNNXXX52Dd0 <DataCore-SANmelody-DCS-64.00GB>
          /scsi_vhci/ssd@g6NNNXXX52d
       3. c5t6NNNXXXD61d0 <DataCore-SANmelody-DCS-100.00GB>
          /scsi_vhci/ssd@g6NNNXXXd61
       4. c5t6NNNXXX174d0 <DataCore-SANmelody-DCS cyl 25598 alt 2 hd 8 sec 1024>
          /scsi_vhci/ssd@g6NNNXXX174
       5. c5t6NNNXXX261d0 <DataCore-SANmelody-DCS cyl 51198 alt 2 hd 8 sec 1024>
          /scsi_vhci/ssd@g6NNNXXX261
       6. c5t6NNNXXX564d0 <DataCore-SANmelody-DCS cyl 5118 alt 2 hd 4 sec 512>
          /scsi_vhci/ssd@g6NNNXXX564
Specify disk (enter its number): 6
selecting c5t6NNNXXX564d0
[disk formatted]
FORMAT MENU:
[...]
        partition  - select (define) a partition table
[...]
format> p
PARTITION MENU:
[...]
        6      - change `6' partition
        print  - display the current table
        label  - write partition map and label to the disk
[...]
partition> p
Current partition table (original):
Total disk cylinders available: 5118 + 2 (reserved cylinders)
 
Part      Tag    Flag     Cylinders        Size            Blocks
  0       root    wm       0               0         (0/0/0)           0
  1       swap    wu       0               0         (0/0/0)           0
  2     backup    wu       0 - 5117        5.00GB    (5118/0/0) 10481664
  3 unassigned    wm       0               0         (0/0/0)           0
  4 unassigned    wm       0               0         (0/0/0)           0
  5 unassigned    wm       0               0         (0/0/0)           0
  6        usr    wm       0 - 5117        5.00GB    (5118/0/0) 10479616
  7 unassigned    wm       0               0         (0/0/0)           0
partition> 6
Part      Tag    Flag     Cylinders        Size            Blocks
  6        usr    wm       0 - 5117        5.00GB    (5118/0/0) 10479616
 
Enter partition id tag[usr]:
Enter partition permission flags[wm]:
Enter new starting cyl[0]: 1
Enter partition size[10479616b, 5117c, 5117e, 5117.00mb, 5.00gb]: $
partition> la
Ready to label disk, continue? y

ZFS Filesysteme

Pool        Mountpoint               Wofür?                Größe
oraswpool   /u01/app/oracle          Oracle Software       64 GB
oradatapool /u02/app/oracle/install  Software Repository  100 GB
oradatapool /u02/app/oracle/dump     Oracle Dumps, RMAN   100 GB

ZFS Pool für Software erstellen

# zpool create oraswpool c5t6NNNXXXd0
# zpool set autoexpand=on orapool

ZFS Pool für Dumps, RMAN erstellen

# zpool create oradatapool c5t6NNNXXXd0
# zpool set autoexpand=on oradatapool

OFA

/u01/app/oracle anlegen

# zfs create -o atime=off -o mountpoint=/u01/app/oracle orapool/u01
# chown oracle:dba /u01/app/oracle

/u01/app/oracle/install anlegen

# zfs create -o atime=off -o mountpoint=/u02/app/oracle/install orapool/install
# chown oracle:dba /u02/app/oracle/install
# chmod 770 /u02/app/oracle/install

/u01/app/oracle/dump anlegen

# zfs create -o atime=off -o mountpoint=/u02/app/oracle/dump oradatapool/dump
# chown oracle:dba /u02/app/oracle/dump

Via NFS schreibbar machen:

# chmod 777 /u02/app/oracle/dump

So schauts aus…

ZFS Pools aoc-node1

root@aoc-node1:/ # zpool status -v
  pool: oradatapool
 state: ONLINE
 scrub: none requested
config:
 
        NAME               STATE     READ WRITE CKSUM
        oradatapool        ONLINE       0     0     0
          c5t6NNNXXXD61d0  ONLINE       0     0     0
 
errors: No known data errors
 
  pool: oraswpool
 state: ONLINE
 scrub: none requested
config:
 
        NAME               STATE     READ WRITE CKSUM
        oraswpool          ONLINE       0     0     0
          c5t6NNNXXX52Dd0  ONLINE       0     0     0
 
errors: No known data errors
 
  pool: rpool
 state: ONLINE
 scrub: none requested
config:
 
        NAME          STATE     READ WRITE CKSUM
        rpool         ONLINE       0     0     0
          mirror-0    ONLINE       0     0     0
            c1t0d0s0  ONLINE       0     0     0
            c1t1d0s0  ONLINE       0     0     0
 
errors: No known data errors

ZFS Pools aoc-node2

root@aoc-node2:/ # zpool status -v
  pool: oradatapool
 state: ONLINE
 scrub: none requested
config:
 
        NAME               STATE     READ WRITE CKSUM
        oradatapool        ONLINE       0     0     0
          c5t6NNNXXXD61d0  ONLINE       0     0     0
 
errors: No known data errors
 
  pool: oraswpool
 state: ONLINE
 scrub: none requested
config:
 
        NAME               STATE     READ WRITE CKSUM
        oraswpool          ONLINE       0     0     0
          c5t6NNNXXX52Dd0  ONLINE       0     0     0
 
errors: No known data errors
 
  pool: rpool
 state: ONLINE
 scrub: none requested
config:
 
        NAME          STATE     READ WRITE CKSUM
        rpool         ONLINE       0     0     0
          mirror-0    ONLINE       0     0     0
            c1t0d0s0  ONLINE       0     0     0
            c1t1d0s0  ONLINE       0     0     0
 
errors: No known data errors

Filesysteme und Rechte

root@aoc-node1:/ # ls -ld /u*/app/oracle/*
drwxr-xr-x   3 oracle   oinstall       3 Apr 19 18:15 /u01/app/oracle/admin
drwxrwx---   6 oracle   oinstall      11 Apr 19 18:15 /u01/app/oracle/oraInventory
drwxrwx---   3 oracle   oinstall       3 Apr 19 18:15 /u01/app/oracle/product
drwxrwxrwx   2 oracle   dba            2 Apr 19 19:21 /u02/app/oracle/dump
drwxrwx---   4 oracle   oinstall       7 Apr 19 19:16 /u02/app/oracle/install

Setup Oracle

User and groups

# groupadd -g 200 oinstall
# groupadd -g 201 oper
# groupadd -g 202 dba
# useradd -u 200 -g oinstall -G dba,oper -s /bin/ksh -d /u01/app/oracle oracle
# passwd oracle
# chown oracle:dba /u01/app/oracle

Resource Manager

Für Benutzer oracle: 24 GB shared-memory 256 sem-ids

# projadd -U oracle -G dba user.oracle
# projmod -s -K "project.shm-max-memory=(priv,25769803776,deny)" user.oracle
# projmod -s -K "project.max-sem-ids=(priv,256,deny)" user.oracle
# su - oracle
$ prctl -n project.max-shm-memory -i project $$
$ prctl -n project.max-sem-ids -i project $$
$ prctl -n project.max-shm-memory -i process $$
$ prctl -n project.max-sem-ids -i process $$

SSH

SSH Schlüssel generieren und für ssh localhost in die eigene authorized_keys hinzufügen:

$ ssh-keygen -t rsa
$ cp .ssh/id_rsa.pub .ssh/authorized_keys

Korn Shell .kshrc für root

Mit folgenden Einträgen erweitern: […]

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db1
export PATH=$ORACLE_HOME/bin:$PATH

Korn Shell .profile for oracle

/export/home/oracle/.profile

set -o vi
prctl -n project.max-shm-memory -i project $$
prctl -n project.max-sem-ids -i project $$
# Oracle
_setpath() {
    if [ $# -gt 1 ]; then
        p=$(echo $PATH | sed "s#$2##")
    else
        p=$PATH
    fi
    export PATH=$1/bin:$p
}
_oracle_settnsadmin() {
    export TNS_ADMIN=$1
    _oracle_showenv
}
_oracle_showenv() {
    env | /usr/xpg4/bin/grep -Ee "PATH|ORACLE|TNS|NLS" | sort
}
_oracle_setsid() {
    export ORACLE_SID=$1
    export ORACLE_ADMIN=$ORACLE_BASE/admin/$ORACLE_SID
    _oracle_showenv
}
_oracle_setbase() {
    export ORACLE_BASE=$1
    _oracle_showenv
    echo "** ATTENTION: Please set ORACLE_HOME with sethome too"
}
_oracle_sethome() {
    OLDORACLE_HOME=$ORACLE_HOME
    export ORACLE_HOME=$ORACLE_BASE/product/$1
    export ORACLE_ADMIN=$ORACLE_BASE/admin/$ORACLE_SID
    export TNS_ADMIN=$ORACLE_HOME/network/admin
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib
    _setpath $OLDORACLE_HOME $ORACLE_HOME
    _oracle_showenv
}
alias setsid='_oracle_setsid'
alias setbase='_oracle_setbase'
alias sethome='_oracle_sethome'
alias settns='_oracle_settnsadmin'
##alias sqlplus='rlwrap sqlplus'
alias sysdba='sqlplus / as sysdba'
alias sysoper='sqlplus / as sysoper'
##alias rman='rlwrap rman'
# Customize here
export PS1='$LOGNAME@'$(uname -n)':$PWD $ORACLE_SID $ '
setbase /u01/app/oracle >/dev/null
sethome 10.2.0/db1 >/dev/null
setsid BLA1

Software Installation

Database

Installation via Response File, db1_db.rsp

UNIX_GROUP_NAME=oinstall
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db1
ORACLE_HOME_NAME=OrbisDbHome1
s_nameForDBAGrp=dba
s_nameForOPERGrp=oper
varSelect=3
$ cd
$ /export/install/oracle/10gr2/database/runInstaller -silent -responseFile /export/home/oracle/db1_db.rsp

/u01/app/oracle/product/10.2.0/db1/root.sh ausführen

Running Oracle10 root.sh script...
 
The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/db1
 
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...
 
 
Creating /var/opt/oracle/oratab file...
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

Companion CD

Metalink Note 293658.1 “10.1 or 10.2 Patchset Install Getting ORA-29558 JAccelerator (NCOMP) And ORA-06512”

Installation via Response File, db1_companion.rsp

UNIX_GROUP_NAME=oinstall
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db1
$ cd
$ /export/install/oracle/10gr2/companion/runInstaller -silent -responseFile /export/home/oracle/db1_companion.rsp

/u01/app/oracle/oraInventory/orainstRoot.sh ausführen

Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to oinstall.
The execution of the script is complete

Patch Set 10.2.0.5.0

Installation via Response File, db1_patchset102050.rsp

FROM_LOCATION=/export/install/oracle/10gr2/p102050/Disk1/stage/products.xml
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db1
ORACLE_HOME_NAME=OrbisDbHome1
DECLINE_SECURITY_UPDATES=TRUE

SEVERE:Unable to establish a network connection to Oracle. If your systems require a proxy server for outbound internet connections, enter the proxy server details. If network connectivity to Oracle is not possible, set ‘DECLINE_SECURITY_UPDATES’ to ‘true’.

$ cd
$ /export/install/oracle/10gr2/p102050/Disk1/runInstaller -silent -responseFile /export/home/oracle/db1_patchset102050.rsp

/u01/app/oracle/product/10.2.0/db1/root.sh ausführen

Running Oracle 10g root.sh script...
 
The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/db1
 
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]: y
   Copying coraenv to /usr/local/bin ...
 
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

ASM

Instanz aufsetzen

SID setzen

oracle@aoc-node1:/export/home/oracle BLA1 $ setsid +ASM
LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/db1/lib
ORACLE_ADMIN=/u01/app/oracle/admin/+ASM
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db1
ORACLE_SID=+ASM
PATH=/u01/app/oracle/product/10.2.0/db1/bin:/usr/bin:
PS1=$LOGNAME@aoc-node1:$PWD $ORACLE_SID $
TNS_ADMIN=/u01/app/oracle/product/10.2.0/db1/network/admin
oracle@aoc-node1:/export/home/oracle +ASM $ 
$ORACLE_HOME/dbs/initASM.ora
instance_type=ASM
asm_diskstring='/dev/rdsk/c5*s6'
processes=100
remote_login_passwordfile='NONE'
background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
user_dump_dest='/u01/app/oracle/admin/+ASM/udump'

Verzeichnisse für ASM

$ mkdir -p $ORACLE_ADMIN/+ASM/bdump
$ mkdir -p $ORACLE_ADMIN/+ASM/cdump
$ mkdir -p $ORACLE_ADMIN/+ASM/udump

Rechte auf Raw Devices setzen

# chown oracle:dba /dev/rdsk/c5*s6
# chmod 660 /dev/rdsk/c5*s6

ASM starten, ORA-29701

oracle@aoc-node1:/export/home/oracle +ASM $ sysdba
 
SQL*Plus: Release 10.2.0.5.0 - Production on Sat Apr 16 10:36:51 2011
 
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
 
Connected to an idle instance.
 
SQL> startup
ORA-29701: unable to connect to Cluster Manager
ORA-29701: localconfig add als root
root@aoc-node1:/ # export ORACLE_BASE=/u01/app/oracle
root@aoc-node1:/ # export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db1
root@aoc-node1:/ # export PATH=$ORACLE_HOME/bin:$PATH
root@aoc-node1:/ # localconfig delete
/u01/app/oracle/product/10.2.0/db1/bin/localconfig: /etc/init.d/init.cssd: not found
root@aoc-node1:/ # localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized
 
Adding to inittab
Apr 16 10:40:17 aoc-node1 root: Oracle Cluster Synchronization Service starting by user request.
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
Apr 16 10:40:18 aoc-node1 root: Cluster Ready Services completed waiting on dependencies.
CSS is active on these nodes.
        aoc-node1
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)

ASM starten

oracle@aoc-node1:/export/home/oracle +ASM $ sysdba
 
SQL*Plus: Release 10.2.0.5.0 - Production on Sat Apr 16 10:42:21 2011
 
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
 
Connected to an idle instance.
 
SQL> startup
ASM instance started
 
Total System Global Area  125829120 bytes
Fixed Size                  2050328 bytes
Variable Size              98612968 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted

SPFILE erstellen

SQL> create spfile from pfile;
 
File created.
 
SQL> shutdown
ORA-15100: invalid or missing diskgroup name
 
 
ASM instance shutdown
SQL> startup
ASM instance started
 
Total System Global Area  125829120 bytes
Fixed Size                  2050328 bytes
Variable Size              98612968 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted

Diskgroups

Diskgroups aoc-node1

Zuordnung Solaris Device zu LUN, Verwendung:

LUN#  Größe  Solaris Device              Slice   ASM Diskgroup
   1 100 GB  /dev/rdsk/c5t6NNNXXX174d0   6       datadg
   2 200 GB  /dev/rdsk/c5t6NNNXXX261d0   6       fradg
   3   5 GB  /dev/rdsk/c5t6NNNXXX564d0   6       redodg
SQL> set linesize 120
SQL> col path format a50
SQL> SELECT group_number, disk_number, mount_status, header_status, state, path FROM v$asm_disk ORDER BY disk_number;
 
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU STATE    PATH
------------ ----------- ------- ------------ -------- ---------------------------
           0           0 CLOSED  CANDIDATE    NORMAL   /dev/rdsk/c5t6NNNXXX564d0s6
           0           1 CLOSED  CANDIDATE    NORMAL   /dev/rdsk/c5t6NNNXXXD61d0s6
           0           2 CLOSED  CANDIDATE    NORMAL   /dev/rdsk/c5t6NNNXXX174d0s6
           0           3 CLOSED  CANDIDATE    NORMAL   /dev/rdsk/c5t6NNNXXX261d0s6

Diskgroups erstellen

SQL> create diskgroup datadg external redundancy disk '/dev/rdsk/c5t6NNNXXX174d0s6';
 
Diskgroup created.
 
SQL> create diskgroup fradg external redundancy disk '/dev/rdsk/c5t6NNNXXX261d0s6';
 
Diskgroup created.
 
SQL> create diskgroup redodg external redundancy disk '/dev/rdsk/c5t6NNNXXX564d0s6';
 
Diskgroup created.
 
SQL> set linesize 140
SQL> col name format a12
SQL> SELECT d.group_number, g.name, disk_number, d.name, mount_status, header_status, d.state, path FROM v$asm_disk d INNER JOIN v$asm_diskgroup g ON d.group_number = g.group_number ORDER BY g.name;
 
GROUP_NUMBER NAME         DISK_NUMBER NAME         MOUNT_S HEADER_STATU STATE    PATH
------------ ------------ ----------- ------------ ------- ------------ -------- ---------------------------
           1 DATADG                 0 DATADG_0000  CACHED  MEMBER       NORMAL   /dev/rdsk/c5t6NNNXXX174d0s6
           2 FRADG                  0 FRADG_0000   CACHED  MEMBER       NORMAL   /dev/rdsk/c5t6NNNXXX261d0s6
           3 REDODG                 0 REDODG_0000  CACHED  MEMBER       NORMAL   /dev/rdsk/c5t6NNNXXX564d0s6

Diskgroups aoc-node2

Zuordnung Solaris Device zu LUN, Verwendung:

LUN#    Größe   Solaris Device              Slice   ASM Diskgroup
   1   100 GB   /dev/rdsk/c5t6NNNXXX174d0   6       datadg
   2   200 GB   /dev/rdsk/c5t6NNNXXX261d0   6       fradg 
   3     5 GB   /dev/rdsk/c5t6NNNXXX564d0   6       redodg
SQL> set linesize 120
SQL> col path format a50
SQL> SELECT group_number, disk_number, mount_status, header_status, state, path FROM v$asm_disk ORDER BY disk_number;
 
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU STATE    PATH
------------ ----------- ------- ------------ -------- ---------------------------
           0           0 CLOSED  CANDIDATE    NORMAL   /dev/rdsk/c5t6NNNXXX261d0s6
           0           1 CLOSED  CANDIDATE    NORMAL   /dev/rdsk/c5t6NNNXXX564d0s6
           0           2 CLOSED  CANDIDATE    NORMAL   /dev/rdsk/c5t6NNNXXX174d0s6
           0           3 CLOSED  CANDIDATE    NORMAL   /dev/rdsk/c5t6NNNXXXD61d0s6

Diskgroups erstellen

SQL> create diskgroup datadg external redundancy disk '/dev/rdsk/c5t6NNNXXX174d0s6';
 
Diskgroup created.
 
SQL> create diskgroup fradg external redundancy disk '/dev/rdsk/c5t6NNNXXX261d0s6';
 
Diskgroup created.
 
SQL> create diskgroup redodg external redundancy disk '/dev/rdsk/c5t6NNNXXX564d0s6';
 
Diskgroup created.
 
SQL> set linesize 140
SQL> col name format a12
SQL> SELECT d.group_number, g.name, disk_number, d.name, mount_status, header_status, d.state, path FROM v$asm_disk d INNER JOIN v$asm_diskgroup g ON d.group_number = g.group_number ORDER BY g.name;
 
GROUP_NUMBER NAME         DISK_NUMBER NAME         MOUNT_S HEADER_STATU STATE    PATH
------------ ------------ ----------- ------------ ------- ------------ -------- ---------------------------
           1 DATADG                 0 DATADG_0000  CACHED  MEMBER       NORMAL   /dev/rdsk/c5t6NNNXXX174d0s6
           2 FRADG                  0 FRADG_0000   CACHED  MEMBER       NORMAL   /dev/rdsk/c5t6NNNXXX261d0s6
           3 REDODG                 0 REDODG_0000  CACHED  MEMBER       NORMAL   /dev/rdsk/c5t6NNNXXX564d0s6

ASM Parameter anpassen

SQL> alter system set asm_diskgroups = 'redodg,datadg,fradg' scope=both;

Automatischer Start der Oracle Datenbanken

oratab

/var/opt/oracle/oratab

# This script will start all databases listed in the oratab file
# whose third field is a "Y". If the third field is set to "Y" and
# there is no ORACLE_SID for an entry (the first field is a *),
# then this script will ignore that entry.
#
# This script requires that ASM ORACLE_SID's start with a +, and
# that non-ASM instance ORACLE_SID's do not start with a +.
#
# If ASM instances are to be started with this script, it cannot
# be used inside an rc*.d directory, and should be invoked from
# rc.local only. Otherwise, the CSS service may not be available
# yet, and this script will block init from completing the boot
# cycle.
#
# If you want dbstart to auto-start a single-instance database that uses
# an ASM server that is auto-started by CRS (this is the default behavior
# for an ASM cluster), you must change the database's ORATAB entry to use
# a third field of "W" and the ASM's ORATAB entry to use a third field of "N".
# These values specify that dbstart auto-starts the database only after
# the ASM instance is up and running.
#
# To configure:
# 1) Set ORATAB:
# On Solaris
# ORATAB=/var/opt/oracle/oratab
# All other UNIX platforms
# ORATAB=/etc/oratab
#
# 2) Update $ORATAB/oratab with Database Instances that need to be started up.
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y|W>:
# An example entry:
# main:/usr/lib/oracle/emagent_10g:Y
#
# Overall algorithm:
# 1) Bring up all ASM instances with 'Y' entry in status field in oratab entry
# 2) Bring up all Database instances with 'Y' entry in status field in
# oratab entry
# 3) If there are Database instances with 'W' entry in status field
# then
# iterate over all ASM instances (irrespective of 'Y' or 'N') AND
# wait for all of them to be started
# fi
# 4) Bring up all Database instances with 'W' entry in status field in
# oratab entry
#
+ASM:/u01/app/oracle/product/10.2.0/db1:Y

dbstart

Skript /u01/app/oracle/product/10.2.0/db1/bin/dbstart modifizieren, damit die ksh genutzt wird, 1. Zeile:

#!/usr/bin/ksh

Oracle SQL*Net

sqlnet.ora

NAMES.DEFAULT_DOMAIN = WORLD
SQLNET.EXPIRE_TIME = 30
#SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH = (TNSNAMES)
This entry was posted in Databases, System Administration and tagged , . Bookmark the permalink.