08.06.2017
Oracle ASM Installation, Konfiguration und Verwendung
Preinstalltions
Patchen der Solaris Maschine
Oracle Solaris 11.2 mit SRU 14.5 oder höher
Anlegen von Benutzern und Gruppen
# Gruppen /usr/sbin/groupadd oinstall /usr/sbin/groupadd dba /usr/sbin/groupadd asmdba # User mkdir -p /export/home/oracle /usr/sbin/useradd -d /export/home/oracle -m -s /bin/bash -g oinstall -G dba oracle chown oracle:oinstall /export/home/oracle passwd oracle usermod -g oinstall oracle usermod -G dba,asmdba oracle
Verzeichnisse und Berechtigungen
mkdir -p /apps/oracle chown -R oracle:oinstall /apps/oracle
Benötigte Pakete installieren
# Solaris Packages pkg install SUNWarc SUNWbtool SUNWlibC SUNWlibms SUNWtoo SUNWhea SUNWsprot # Java pkg install --accept jdk-7 # XServer pkg install slim_install # motif pkg install motif # dtrace pkg install pkg://solaris/system/dtrace # make pkg install pkg://solaris/developer/build/make # xcu4 package pkg install pkg://solaris/system/xopen/xcu4 # x11-info-clients pkg install pkg://solaris/x11/diagnostic/x11-info-clients # unzip pkg install pkg://solaris/compress/unzip
Oracle Project anlegen und konfigurieren
projadd -U oracle -K "project.max-shm-memory=(priv,96G,deny)" user.oracle projmod -sK "project.max-sem-nsems=(priv,512,deny)" user.oracle projmod -sK "project.max-sem-ids=(priv,128,deny)" user.oracle projmod -sK "project.max-shm-ids=(priv,128,deny)" user.oracle projmod -sK "process.max-file-descriptor=(priv,65536,deny)" user.oracle
Wichtig: Ser SHM Wert wird gebildet aus allen benötigten SGA’s der Datenbanken zusammen, die auf dem Server laufen sollen.
Sollte der shm-memory Wert nochmals geändert werden müssen.
projmod -sK "project.max-shm-memory=(priv,128G,deny)" user.oracle
Kontrolle des shm-memory Parameters (wird erst nach einem Reboot funktionieren)
id -p oracle
uid=100(oracle) gid=100(oinstall) projid=100(user.oracle)
root@xendbt01:~# prctl -n project.max-shm-memory -i project 100
project: 100: user.oracle
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 32.0GB - deny -
system 16.0EB max deny
Port Definitionen
ndd -set /dev/tcp tcp_smallest_anon_port 9000 ndd -set /dev/tcp tcp_largest_anon_port 65500 ndd -set /dev/udp udp_smallest_anon_port 9000 ndd -set /dev/udp udp_largest_anon_port 65500
vi /etc/inittab tm::sysinit:/usr/sbin/ndd -set /dev/tcp tcp_smallest_anon_port 9000 > /dev/console tm::sysinit:/usr/sbin/ndd -set /dev/tcp tcp_largest_anon_port 65500 > /dev/console tm::sysinit:/usr/sbin/ndd -set /dev/udp udp_smallest_anon_port 9000 > /dev/console tm::sysinit:/usr/sbin/ndd -set /dev/udp udp_largest_anon_port 65500 > /dev/console
Kernel Parameter setzen
# Open file descriptors ulimit -u 16384 # Number of process ulimit -n 65536 # Stack size ulimit -s 32768
LUN’s anlegen und bereitstellen
LUN’s auf dem Storage anlegen und der Maschine präsentieren
— SCREEN–
Die präsentierten LUN’s als virtuelle Disks anlegen und der LDOM präsentieren
ls -l /dev/rdsk | grep s2 | grep 'Feb 22' lrwxrwxrwx 1 root root 67 Feb 22 08:29 c0t600601603A402D00108E92E534D9E511d0s2 -> ../../devices/scsi_vhci/ssd@g600601603a402d00108e92e534d9e511:g,raw lrwxrwxrwx 1 root root 67 Feb 22 08:29 c0t600601603A402D0032CA28F634D9E511d0s2 -> ../../devices/scsi_vhci/ssd@g600601603a402d0032ca28f634d9e511:g,raw lrwxrwxrwx 1 root root 67 Feb 22 08:29 c0t600601603A402D0038F3080F35D9E511d0s2 -> ../../devices/scsi_vhci/ssd@g600601603a402d0038f3080f35d9e511:g,raw lrwxrwxrwx 1 root root 67 Feb 22 08:29 c0t600601603A402D00425D682735D9E511d0s2 -> ../../devices/scsi_vhci/ssd@g600601603a402d00425d682735d9e511:g,raw lrwxrwxrwx 1 root root 67 Feb 22 08:29 c0t600601603A402D00CA73C8CE34D9E511d0s2 -> ../../devices/scsi_vhci/ssd@g600601603a402d00ca73c8ce34d9e511:g,raw
Beim Export der physikal LUN’s zu virtuellen LUN’s sollte immer Slice 2 ohne Slice Option verwendet werden, da somit die gesamte Disk (alle Slices) exportiert wird.
ldm add-vdsdev /dev/rdsk/c0t600601603A402D00CA73C8CE34D9E511d0s2 bb_ora02_data01@primary-vds0
Bei diesem Beispiel wird wirklich nur Slice zwei exportiert, sollte dies mal benötigt werden.
ldm add-vdsdev options=slice /dev/rdsk/c0t600601603A402D00CA73C8CE34D9E511d0s2 bb_ora02_data01@primary-vds0
Anzeigen der aktuellen LDOM Disk Konfiguration
ldm list -o disk ora02
NAME
ora02
DISK
NAME VOLUME TOUT ID DEVICE SERVER MPGROUP
ora02_root0 ora02_root0@primary-vds0 0 disk@0 primary
ora02_root1 ora02_root1@primary-vds0 1 disk@1 primary
ora02_apps0 ora02_apps0@primary-vds0 2 disk@2 primary
ora02_apps1 ora02_apps1@primary-vds0 3 disk@3 primary
Anlegen der virtuellen Disk für die LDOM
ldm add-vdsdev /dev/rdsk/c0t600601603A402D00CA73C8CE34D9E511d0s2 bb_ora02_data01@primary-vds0 ldm add-vdsdev /dev/rdsk/c0t600601603A402D00108E92E534D9E511d0s2 bb_ora02_data02@primary-vds0 ldm add-vdsdev /dev/rdsk/c0t600601603A402D0032CA28F634D9E511d0s2 bb_ora02_data03@primary-vds0 ldm add-vdsdev /dev/rdsk/c0t600601603A402D0038F3080F35D9E511d0s2 bb_ora02_fra01@primary-vds0 ldm add-vdsdev /dev/rdsk/c0t600601603A402D00425D682735D9E511d0s2 bb_ora02_fra02@primary-vds0 ldm add-vdisk id=4 bb_ora02_data01 bb_ora02_data01@primary-vds0 ora02 ldm add-vdisk id=5 bb_ora02_data02 bb_ora02_data02@primary-vds0 ora02 ldm add-vdisk id=6 bb_ora02_data03 bb_ora02_data03@primary-vds0 ora02 ldm add-vdisk id=7 bb_ora02_fra01 bb_ora02_fra01@primary-vds0 ora02 ldm add-vdisk id=8 bb_ora02_fra02 bb_ora02_fra02@primary-vds0 ora02
Anzeigen der aktuellen LDOM Disk Konfiguration
ldm list -o disk ora02
NAME
ora02
DISK
NAME VOLUME TOUT ID DEVICE SERVER MPGROUP
ora02_root0 ora02_root0@primary-vds0 0 disk@0 primary
ora02_root1 ora02_root1@primary-vds0 1 disk@1 primary
ora02_apps0 ora02_apps0@primary-vds0 2 disk@2 primary
ora02_apps1 ora02_apps1@primary-vds0 3 disk@3 primary
bb_ora02_data01 bb_ora02_data01@primary-vds0 4 disk@4 primary
bb_ora02_data02 bb_ora02_data02@primary-vds0 5 disk@5 primary
bb_ora02_data03 bb_ora02_data03@primary-vds0 6 disk@6 primary
bb_ora02_fra01 bb_ora02_fra01@primary-vds0 7 disk@7 primary
bb_ora02_fra02 bb_ora02_fra02@primary-vds0 8 disk@8 primary
Vorbereiten LUN’s in der LDOM für ASM
Anlegen eines eigenen ASM Verzeichnisses zum separaten Linken der LUN’s.
mkdir /dev/asmdba
Labeln aller neuen Disks
format
Searching for disks...done
c1d4: configured with capacity of 499.98GB
c1d5: configured with capacity of 499.98GB
c1d6: configured with capacity of 499.98GB
c1d7: configured with capacity of 249.99GB
c1d8: configured with capacity of 249.99GB
AVAILABLE DISK SELECTIONS:
0. c1d0 <DGC-VRAID-0532 cyl 40958 alt 2 hd 256 sec 10>
/virtual-devices@100/channel-devices@200/disk@0
1. c1d1 <DGC-VRAID-0532 cyl 40958 alt 2 hd 256 sec 10>
/virtual-devices@100/channel-devices@200/disk@1
2. c1d2 <DGC-VRAID-0532-50.00GB>
/virtual-devices@100/channel-devices@200/disk@2
3. c1d3 <DGC-VRAID-0532-50.00GB>
/virtual-devices@100/channel-devices@200/disk@3
4. c1d4 <DGC-VRAID-0532 cyl 63998 alt 2 hd 256 sec 64>
/virtual-devices@100/channel-devices@200/disk@4
5. c1d5 <DGC-VRAID-0532 cyl 63998 alt 2 hd 256 sec 64>
/virtual-devices@100/channel-devices@200/disk@5
6. c1d6 <DGC-VRAID-0532 cyl 63998 alt 2 hd 256 sec 64>
/virtual-devices@100/channel-devices@200/disk@6
7. c1d7 <DGC-VRAID-0532 cyl 63998 alt 2 hd 256 sec 32>
/virtual-devices@100/channel-devices@200/disk@7
8. c1d8 <DGC-VRAID-0532 cyl 63998 alt 2 hd 256 sec 32>
/virtual-devices@100/channel-devices@200/disk@8
Specify disk (enter its number): 4
selecting c1d4
[disk formatted]
Disk not labeled. Label it now? y
FORMAT MENU:
disk - select a disk
type - select (define) a disk type
partition - select (define) a partition table
current - describe the current disk
format - format and analyze the disk
repair - repair a defective sector
label - write label to the disk
analyze - surface analysis
defect - defect list management
backup - search for backup labels
verify - read and display labels
save - save new disk/partition definitions
inquiry - show disk ID
volname - set 8-character volume name
!<cmd> - execute <cmd>, then return
quit
format> q
Dieser Schritt muss für alle neuen LUN’s, die für ASM gedacht sind, durchgeführt werden.
Linken und Berechtigen der neuen LUN’s in das neue asmdba Verzeichnis
cd /dev/asmdba ln -s /dev/rdsk/c1d4s6 bb_ora02_data01 ln -s /dev/rdsk/c1d5s6 bb_ora02_data02 ln -s /dev/rdsk/c1d6s6 bb_ora02_data03 ln -s /dev/rdsk/c1d7s6 bb_ora02_fra01 ln -s /dev/rdsk/c1d8s6 bb_ora02_fra02 chown oracle:asmdba * ls -l lrwxrwxrwx 1 root root 16 Feb 22 09:17 bb_ora02_data01 -> /dev/rdsk/c1d4s6 ls -l /dev/rdsk/c1d4s6 lrwxrwxrwx 1 root root 66 Nov 20 09:00 /dev/rdsk/c1d4s6 -> ../../devices/virtual-devices@100/channel-devices@200/disk@4:g,raw ls -l ../../devices/virtual-devices@100/channel-devices@200/disk@4:g,raw crw------- 1 oracle asmdba 272, 38 Feb 22 09:17 ../../devices/virtual-devices@100/channel-devices@200/disk@4:g,raw
Oracle Grid Installation
Überprüfen der heruntergeladenen Software Pakete und entpacken
cd /apps/oracle/software ls -al total 11569547 drwxr-xr-x 2 oracle oinstall 9 Feb 17 09:24 . drwxr-xr-x 3 oracle oinstall 3 Feb 15 15:58 .. -rw-r--r-- 1 oracle oinstall 177144055 Feb 15 06:56 cvupack_sol_sparc64.zip -rw-r--r-- 1 oracle oinstall 1765495417 Feb 15 07:23 p21419221_121020_SOLARIS64_1of10.zip -rw-r--r-- 1 oracle oinstall 1147043852 Feb 15 07:23 p21419221_121020_SOLARIS64_2of10.zip -rw-r--r-- 1 oracle oinstall 1328921933 Feb 15 07:24 p21419221_121020_SOLARIS64_5of10.zip -rw-r--r-- 1 oracle oinstall 778288046 Feb 15 07:22 p21419221_121020_SOLARIS64_6of10.zip -rw-r--r-- 1 oracle oinstall 668842950 Feb 15 07:12 p22191349_121020_SOLARIS64.zip -rw-r--r-- 1 root root 53089322 Feb 17 09:23 p6880880_121010_SOLARIS64.zip unzip p21419221_121020_SOLARIS64_5of10.zip unzip p21419221_121020_SOLARIS64_6of10.zip
Installationsverzeichnis für Oracle ASM anlegen
mkdir -p /apps/oracle/12.1.0.2/grid
Installation starten
cd /apps/oracle/software/grid/ ./runInstaller
Install and Configure GI for Standalone Server Language English INFO: Parsing KFOD-00311: Error scanning device /dev/dsk/c1d0s0 INFO: Parsing ORA-15059: invalid device type for ASM disk INFO: Parsing SVR4 Error: 24576: Unknown system error INFO: Parsing Additional information: 42 >>>Note: Make sure the raw devices are not in the cylinder # 0 since it contains the VTOC and this can corrupt the disk for sure. 3) If they have specific questions about how create raw devices on Solaris, they will need to engage their OS support, basically they only need to avoid the cylinder # 0 since it contains the VTOC. ASM Does Not Discover Disk on Solaris (Doc ID 368840.1) ASM is not Discovering Disks on Solaris: ORA-15025 ORA-27041 SVR4 Error: 5: I/O error. (Doc ID 1300393.1) >>> Using the correct partition #6 >>> chown oracle:oinstall oder ASM Gruppe Create ASM Dirskgroup Disk Group Name: Data Redundancy: External Allocation Unit Size: 4MB Disk(s) /dev/asmdba/data01 ASM Password: all ordix123 Management Option: nicht resitrieren mit Cloud Control Operating System Groups ASM Administrator - dba ASM DBA - asmdba ASM Operator - dba Installation Location Oracle Base - /apps/oracle Oracle Home - /apps/oracle/12.1.0.2/grid Inventory: /apps/oracle/oraInventory Root Script Execution: nichtr automatisch Prerequisite Checks ulimit -n 256 -> 16384 Summary Install Root Skript(e) /apps/oracle/oraInventory/orainstRoot.sh /apps/oracle/12.1.0.2/grid/root.sh Configuration Assistants
Root Scripte ausführen
/apps/oracle/oraInventory/orainstRoot.sh Changing permissions of /apps/oracle/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /apps/oracle/oraInventory to oinstall. The execution of the script is complete.
/apps/oracle/12.1.0.2/grid/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /apps/oracle/12.1.0.2/grid
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 script.
Now product-specific root actions will be performed.
Using configuration parameter file: /apps/oracle/12.1.0.2/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node vmlso-asmt01 successfully pinned.
2016/02/17 12:56:51 CLSRSC-330: Adding Clusterware entries to file '/etc/inittab'
vmlso-asmt01 2016/02/17 12:57:23 /apps/oracle/12.1.0.2/grid/cdata/vmlso-asmt01/backup_20160217_125723.olr 0
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'vmlso-asmt01'
CRS-2673: Attempting to stop 'ora.evmd' on 'vmlso-asmt01'
CRS-2677: Stop of 'ora.evmd' on 'vmlso-asmt01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'vmlso-asmt01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2016/02/17 12:57:47 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
Erste Schritte nach der Installation
export PATH=$PATH:/usr/local/bin . oraenv ORACLE_SID = [root] ? +ASM The Oracle base has been set to /apps/oracle env |grep ORA ORACLE_SID=+ASM ORACLE_BASE=/apps/oracle ORACLE_HOME=/apps/oracle/12.1.0.2/grid
. oraenv +ASM asmca DATA2 Normal data02 & data03 FG_RZ1 data04 & data05 FG_RZ2 AU Size 4MB ASM Compatibility 12.1.0.0.0 Database Compatibility - nicht eintragen -->nachtraeglich >>> ASM Alert Log:/apps/oracle/diag/asm/+asm/+ASM/trace/alert_+ASM.log SUCCESS: CREATE DISKGROUP DATA2 NORMAL REDUNDANCY FAILGROUP FG_RZ2 DISK '/dev/asmdba/data04' SIZE 9983M , '/dev/asmdba/data05' SIZE 9983M FAILGROUP FG_RZ1 DISK '/dev/asmdba/data02' SIZE 9983M , '/dev/asmdba/data03' SIZE 9983M ATTRIBUTE 'compatible.asm'='12.1.0.0.0','au_size'='4M' /* ASMCA */ FRA External data06 AU Size 4MB ASM Compatibility 12.1.0.0.0 Database Compatibility - nicht eintragen -->nachtraeglich SUCCESS: CREATE DISKGROUP FRA EXTERNAL REDUNDANCY DISK '/dev/asmdba/data06' SIZE 9983M ATTRIBUTE 'compatible.asm'='12.1.0.0.0','au_size'='4M' /* ASMCA */
crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE vmlso-asmt01 STABLE
ora.DATA2.dg
ONLINE ONLINE vmlso-asmt01 STABLE
ora.FRA.dg
ONLINE ONLINE vmlso-asmt01 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE vmlso-asmt01 STABLE
ora.asm
ONLINE ONLINE vmlso-asmt01 Started,STABLE
ora.ons
OFFLINE OFFLINE vmlso-asmt01 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE vmlso-asmt01 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE vmlso-asmt01 STABLE
ora.hafp.db
1 ONLINE ONLINE vmlso-asmt01 Open,STABLE
--------------------------------------------------------------------------------
Bash Profile für oracle Benutzer anlegen
su - oracle vi .bash_profile ".bash_profile" [New File]~ export PATH=$PATH:/usr/local/bin export ORAENV_ASK=NO export ORACLE_SID=hafp . oraenv export ORAENV_ASK=YES exit su - oracle Oracle Corporation SunOS 5.11 11.2 August 2015 ORACLE_SID = [+ASM] ? The Oracle base has been set to /apps/oracle
ASM Status fragen
srvctl status asm ASM is running on vmlso-asmt01
Ausführen der ASMCMD
asmcmd -p
ASMCMD [+] > ls -l
State Type Rebal Name
MOUNTED EXTERN N DATA/
MOUNTED NORMAL N DATA2/
MOUNTED EXTERN N FRA/
ASMCMD [+] > cd DATA
ASMCMD [+DATA] > ls -l
Type Redund Striped Time Sys Name
Y ASM/
Y HAFP/
PASSWORD UNPROT COARSE FEB 17 13:00:00 N orapwasm => +DATA/ASM/PASSWORD/pwdasm.256.904050105
ASMCMD [+DATA] > du
Used_MB Mirror_used_MB
56 56
ASMCMD [+DATA] > lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 4194304 9980 9832 0 9832 0 N DATA/
MOUNTED NORMAL N 512 4096 4194304 39920 35648 9980 12834 0 N DATA2/
MOUNTED EXTERN N 512 4096 4194304 9980 9460 0 9460 0 N FRA/
ASMCMD [+DATA] > lsdsk --statistics
Reads Write Read_Errs Write_Errs Read_time Write_Time Bytes_Read Bytes_Written Voting_File Path
481 17539 0 0 530.202805 52739.875638 7614464 71868416 N /dev/asmdba/data01
25432 45257 0 0 549.178936 52768.04406 455400960 524435456 N /dev/asmdba/data02
73532 11411 0 0 44.18546 10.642783 1269517824 190604800 N /dev/asmdba/data03
48324 45164 0 0 562.053877 52767.006389 820886528 531904000 N /dev/asmdba/data04
22051 11504 0 0 16.346886 10.787276 427771392 183136256 N /dev/asmdba/data05
1130 49159 0 0 530.843192 52768.979921 17869312 679791104 N /dev/asmdba/data06
ASMCMD [+DATA] > lsdsk --candidate
Path
/dev/asmdba/data07
/dev/asmdba/data08
/dev/asmdba/data09
/dev/asmdba/data10
ASMCMD [+DATA] > exit
Durchsicht des ASM Logfiles
cd $ORACLE_BASE cd diag/asm/+asm/+ASM/trace/ view alert_+ASM.log
ASM Tabelle mit sqlplus abgfragen
sqlplus / as sysasm SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 17 14:04:24 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Automatic Storage Management option SQL> desc v$asm_disk Name Null? Type ----------------------------------------- -------- ---------------------------- GROUP_NUMBER NUMBER DISK_NUMBER NUMBER COMPOUND_INDEX NUMBER INCARNATION NUMBER MOUNT_STATUS VARCHAR2(7) HEADER_STATUS VARCHAR2(12) MODE_STATUS VARCHAR2(7) STATE VARCHAR2(8) REDUNDANCY VARCHAR2(7) LIBRARY VARCHAR2(64) OS_MB NUMBER TOTAL_MB NUMBER FREE_MB NUMBER HOT_USED_MB NUMBER COLD_USED_MB NUMBER NAME VARCHAR2(30) FAILGROUP VARCHAR2(30) LABEL VARCHAR2(31) PATH VARCHAR2(256) UDID VARCHAR2(64) PRODUCT VARCHAR2(32) CREATE_DATE DATE MOUNT_DATE DATE REPAIR_TIMER NUMBER READS NUMBER WRITES NUMBER READ_ERRS NUMBER WRITE_ERRS NUMBER READ_TIMEOUT NUMBER WRITE_TIMEOUT NUMBER READ_TIME NUMBER WRITE_TIME NUMBER BYTES_READ NUMBER BYTES_WRITTEN NUMBER PREFERRED_READ VARCHAR2(1) HASH_VALUE NUMBER HOT_READS NUMBER HOT_WRITES NUMBER HOT_BYTES_READ NUMBER HOT_BYTES_WRITTEN NUMBER COLD_READS NUMBER COLD_WRITES NUMBER COLD_BYTES_READ NUMBER COLD_BYTES_WRITTEN NUMBER VOTING_FILE VARCHAR2(1) SECTOR_SIZE NUMBER FAILGROUP_TYPE VARCHAR2(7) CON_ID NUMBER
su - oracle
Oracle Corporation SunOS 5.11 11.2 August 2015
ORACLE_SID = [+ASM] ?
The Oracle base has been set to /apps/oracle
-bash-4.1$ sqlplus / as sysasm
SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 17 14:14:13 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
set lines 160
set pages 100
col GROUP_NUMBER format 99999 heading GROUP
col DISK_NUMBER format 9999 heading DISK
col NAME format a16
col PATH format a40
col FAILGROUP format a10
col MOUNT_STATUS format a6
col HEADER_STATUS format a9
col MODE_STATUS format a6
select GROUP_NUMBER,DISK_NUMBER,NAME,PATH,FAILGROUP,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS
from v$asm_disk
order by GROUP_NUMBER,PATH; 2 3
GROUP DISK NAME PATH FAILGROUP MOUNT_ HEADER_ST MODE_S
------ ----- ---------------- ---------------------------------------- ---------- ------ --------- ------
0 3 /dev/asmdba/data07 CLOSED CANDIDATE ONLINE
0 0 /dev/asmdba/data08 CLOSED CANDIDATE ONLINE
0 1 /dev/asmdba/data09 CLOSED CANDIDATE ONLINE
0 2 /dev/asmdba/data10 CLOSED CANDIDATE ONLINE
1 0 DATA_0000 /dev/asmdba/data01 DATA_0000 CACHED MEMBER ONLINE
2 2 DATA2_0002 /dev/asmdba/data02 FG_RZ1 CACHED MEMBER ONLINE
2 3 DATA2_0003 /dev/asmdba/data03 FG_RZ1 CACHED MEMBER ONLINE
2 0 DATA2_0000 /dev/asmdba/data04 FG_RZ2 CACHED MEMBER ONLINE
2 1 DATA2_0001 /dev/asmdba/data05 FG_RZ2 CACHED MEMBER ONLINE
3 0 FRA_0000 /dev/asmdba/data06 FRA_0000 CACHED MEMBER ONLINE
10 rows selected.
set lines 160
set pages 100
col GROUP_NUMBER format 99999 heading GROUP
col DISK_NUMBER format 9999 heading DISK
col NAME format a16
col PATH format a40
col FAILGROUP format a10
col MOUNT_STATUS format a6
col HEADER_STATUS format a9
col MODE_STATUS format a6
select
GROUP_NUMBER,
DISK_NUMBER,
NAME,
PATH,
FAILGROUP,
MOUNT_STATUS,
HEADER_STATUS,
MODE_STATUS,
OS_MB,
TOTAL_MB,
FREE_MB
from v$asm_disk
order by GROUP_NUMBER,DISK_NUMBER;
GROUP DISK NAME PATH FAILGROUP MOUNT_ HEADER_ST MODE_S OS_MB TOTAL_MB FREE_MB
------ ----- ---------------- ---------------------------------------- ---------- ------ --------- ------ ---------- ---------- ----------
0 0 /dev/asmdba/data08 CLOSED CANDIDATE ONLINE 9983 0 0
0 1 /dev/asmdba/data09 CLOSED CANDIDATE ONLINE 9983 0 0
0 2 /dev/asmdba/data10 CLOSED CANDIDATE ONLINE 9983 0 0
0 3 /dev/asmdba/data07 CLOSED CANDIDATE ONLINE 9983 0 0
1 0 DATA_0000 /dev/asmdba/data01 DATA_0000 CACHED MEMBER ONLINE 9983 9980 9884
2 0 DATA2_0000 /dev/asmdba/data04 FG_RZ2 CACHED MEMBER ONLINE 9983 9980 9940
2 1 DATA2_0001 /dev/asmdba/data05 FG_RZ2 CACHED MEMBER ONLINE 9983 9980 9924
2 2 DATA2_0002 /dev/asmdba/data02 FG_RZ1 CACHED MEMBER ONLINE 9983 9980 9932
2 3 DATA2_0003 /dev/asmdba/data03 FG_RZ1 CACHED MEMBER ONLINE 9983 9980 9932
3 0 FRA_0000 /dev/asmdba/data06 FRA_0000 CACHED MEMBER ONLINE 9983 9980 9896
10 rows selected.
asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 4194304 9980 9884 0 9884 0 N DATA/ MOUNTED NORMAL N 512 4096 4194304 39920 39728 9980 14874 0 N DATA2/ MOUNTED EXTERN N 512 4096 4194304 9980 9896 0 9896 0 N FRA/
Installation Oracle Datenbank (RDBMS)
Umgebungsvariablen reseten
unset ORACLE_HOME unset ORACLE_SID
Auspacken der Oracle Software
cd /apps/oracle/software/ unzip p21419221_121020_SOLARIS64_1of10.zip
RDBMS Verzeichnis anlegen
mkdir -p /apps/oracle/12.1.0.2/rdbms
Installation starten
cd /apps/oracle/software/database ./runInstaller
Configure Security Updates -no Installation Options - database software only Grid Installation Option - Single Instance Product Language - English Database Edition - Enterprise Edition Installation Location Oracle Base - /apps/oracle Oracle Home - /apps/oracle/12.1.0.2/rdbms Operating System Groups - dba Prerequisite Checks ulimit -n 256 -> 16384 Summary Install
/apps/oracle/12.1.0.2/rdbms/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /apps/oracle/12.1.0.2/rdbms
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
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 script.
Now product-specific root actions will be performed.
Datenbank anlegen
Anpassen der oratab mit der neuen Datenbank
vi /var/opt/oracle/oratab "/var/opt/oracle/oratab" 26 lines, 967 characters#Backup file is /apps/oracle/12.1.0.2/grid/srvm/admin/oratab.bak.vmlso-asmt01 line added by Agent ## This file is used by ORACLE utilities. It is created by root.sh # and updated by either Database Configuration Assistant while creating # a database or ASM Configuration Assistant while creating ASM instance. # A colon, ':', is used as the field terminator. A new line terminates # the entry. Lines beginning with a pound sign, '#', are comments. # # Entries are of the form: # $ORACLE_SID:$ORACLE_HOME:<N|Y>: # # The first and second fields are the system identifier and home # directory of the database respectively. The third field indicates # to the dbstart utility that the database should , "Y", or should not, # "N", be brought up at system boot time. # # Multiple entries with the same $ORACLE_SID are not allowed. # # +ASM:/apps/oracle/12.1.0.2/grid:N# line added by Agent hafp:/apps/oracle/12.1.0.2/rdbms:N
Setzen der oraenv
. oraenv hafp unset ORACLE_SID
Starten des Database Configuration Assistant (dbca)
dbca
Database Operation - Create Database
Creation Mode - Advanced
Database Template - Custom Database
Database Identification - hafp #nicht in oratab
Management Options - keine
Database Credentials - ordix123 for all
Network Configuration - default GI/ASM Listener, Port 1521 verwenden
Storage Location
Database Files - ASM
File Location - DATA2
Use Oracle Managed Files
Multiplex Redo Log + Control Files
+DATA2
+FRA
Recovery releated Files - ASM
Secify Fast Recovery Area
File Location - FRA
FRA Size - 4815 MB
Enable Archive Log Mode
Database Options - deselect all
Initilaation Parameters
Memory: Custom Settings - Manual Shared Memory Management
Sizing: BlocK Size 8K, Processes 300
Character Set
Connection Mode
Creation Options
Create Database, Template + Scripts
Create
>>> creation scripts in /apps/oracle/admin/hafp/scripts
Install Script nach der Installation
[spoiler title=’RDBMS’ style=’default’ collapse_link=’true’]
cd $ORACLE_BASE
cd admin/hafp/scripts/
view init.ora
"init.ora" [readonly][Incomplete last line] 81 lines, 2300 characters##############################################################################
# Copyright (c) 1991, 2013 by Oracle Corporation
##############################################################################
###########################################
# Archive
###########################################
log_archive_format=%t_%s_%r.dbf
###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_cache_size=1000m
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# Database Identification
###########################################
db_domain=""
db_name="hafp"
###########################################
# File Configuration
###########################################
db_create_file_dest="+DATA2"
db_create_online_log_dest_1=+DATA2
db_create_online_log_dest_2=+FRA
db_recovery_file_dest="+FRA"
db_recovery_file_dest_size=4815m
###########################################
# Miscellaneous
###########################################
compatible=12.1.0.2.0
diagnostic_dest=/apps/oracle
###########################################
# Network Registration
###########################################
#local_listener=LISTENER_HAFP
###########################################
# Pools
###########################################
java_pool_size=0m
large_pool_size=32m
shared_pool_size=400m
###########################################
# Processes and Sessions
###########################################
processes=300
###########################################
# Security and Auditing
###########################################
audit_file_dest="/apps/oracle/admin/hafp/adump"
audit_trail=db
remote_login_passwordfile=EXCLUSIVE
###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=hafpXDB)"
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=1000m
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1
:q+
E488: Trailing characters:q!
-bash-4.1$
-bash-4.1$
-bash-4.1$ view hafp.sh
"hafp.sh" [readonly] 16 lines, 594 characters#!/bin/sh
OLD_UMASK=`umask`
umask 0027
mkdir -p /apps/oracle
mkdir -p /apps/oracle/admin/hafp/adump
mkdir -p /apps/oracle/admin/hafp/dpdump
mkdir -p /apps/oracle/admin/hafp/pfile
mkdir -p /apps/oracle/audit
mkdir -p /apps/oracle/cfgtoollogs/dbca/hafp
umask ${OLD_UMASK}
PERL5LIB=$ORACLE_HOME/rdbms/admin:$PERL5LIB; export PERL5LIB
ORACLE_SID=hafp; export ORACLE_SID
PATH=$ORACLE_HOME/bin:$PATH; export PATH
echo You should Add this entry in the /var/opt/oracle/oratab: hafp:/apps/oracle/12.1.0.2/rdbms:Y
/apps/oracle/12.1.0.2/rdbms/bin/sqlplus /nolog @/apps/oracle/admin/hafp/scripts/hafp.sql
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ :q+
E488: Trailing characters:q!
-bash-4.1$ view hafp.sh ql
"hafp.sql" [readonly] 13 lines, 904 charactersset verify off
ACCEPT sysPassword CHAR PROMPT 'Enter new password for SYS: ' HIDE
ACCEPT systemPassword CHAR PROMPT 'Enter new password for SYSTEM: ' HIDE
host /apps/oracle/12.1.0.2/rdbms/bin/srvctl add database -d hafp -o /apps/oracle/12.1.0.2/rdbms -p +DATA2/hafp/spffilehafp.ora -n hafp
host /apps/oracle/12.1.0.2/rdbms/bin/srvctl disable database -d hafp
host /apps/oracle/12.1.0.2/rdbms/bin/orapwd file=/apps/oracle/12.1.0.2/rdbms/dbs/orapwhafp force=y format=12
host /apps/oracle/12.1.0.2/grid/bin/setasmgidwrap o=/apps/oracle/12.1.0.2/rdbms/bin/oracle
@/apps/oracle/admin/hafp/scripts/CreateDB.sql
@/apps/oracle/admin/hafp/scripts/CreateDBFiles.sql
@/apps/oracle/admin/hafp/scripts/CreateDBCatalog.sql
host echo "SPFILE='+DATA2/hafp/spfilehafp.ora'" > /apps/oracle/12.1.0.2/rdbms/dbs/inithafp.ora
@/apps/oracle/admin/hafp/scripts/lockAccount.sql
@/apps/oracle/admin/hafp/scripts/postDBCreation.sql
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ :q!
-bash-4.1$ vi postDBCreation.sql
"postDBCreation.sql" 22 lines, 919 charactersSET VERIFY OFF
spool /apps/oracle/admin/hafp/scripts/postDBCreation.log append
@/apps/oracle/12.1.0.2/rdbms/rdbms/admin/catbundleapply.sql;
shutdown immediate;
connect "SYS"/"&&sysPassword" as SYSDBA
startup mount pfile="/apps/oracle/admin/hafp/scripts/init.ora";
alter database archivelog;
alter database open;
connect "SYS"/"&&sysPassword" as SYSDBA
set echo on
create spfile='+DATA2' FROM pfile='/apps/oracle/admin/hafp/scripts/init.ora';
connect "SYS"/"&&sysPassword" as SYSDBA
select 'utlrp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual;
@/apps/oracle/12.1.0.2/rdbms/rdbms/admin/utlrp.sql;
select 'utlrp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual;
select comp_id, status from dba_registry;
shutdown immediate;
host /apps/oracle/12.1.0.2/rdbms/bin/srvctl enable database -d hafp;
host /apps/oracle/12.1.0.2/rdbms/bin/srvctl start database -d hafp;
connect "SYS"/"&&sysPassword" as SYSDBA
spool off
exit;
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ :q+
E488: Trailing characters:q!
-bash-4.1$ pwd
/apps/oracle/admin/hafp/scripts
-bash-4.1$ cd
-bash-4.1$ vi .bash_profile
".bash_profile" 4 lines, 86 charactersexport PATH=$PATH:/usr/local/bin
export ORAENV_ASK=no
export ORACLE_SID=+ASM
. oraenv
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
export ORAENV_ASK=o=NO:wq
[/spoiler]
Abfragen und Bearbeiten der angelegten Tablespaces unserer neuen hafp Datenbank
[spoiler title=’RDBMS’ style=’default’ collapse_link=’true’]
sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 17 15:39:01 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options SQL> set lines 132 SQL> set pages 100 SQL> SQL> SQL> select name from v$datafile; NAME ------------------------------------------------------------------------------------------------------------------------------------ +DATA2/HAFP/DATAFILE/system.260.904057717 +DATA2/HAFP/DATAFILE/sysaux.261.904057719 +DATA2/HAFP/DATAFILE/undotbs1.262.904057721 +DATA2/HAFP/DATAFILE/users.264.904057729 SQL> select *f from v$tempfile; FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED BYTES BLOCKS CREATE_BYTES BLOCK_SIZE ---------- ---------------- --------- ---------- ---------- ------- ---------- ---------- ---------- ------------ ---------- NAME ------------------------------------------------------------------------------------------------------------------------------------ CON_ID ---------- 1 3374 17-FEB-16 3 1 ONLINE READ WRITE 20971520 2560 20971520 8192 +DATA2/HAFP/TEMPFILE/temp.263.904057723 0 SQL> show parameter control_file NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 control_files string +DATA2/HAFP/CONTROLFILE/curren t.256.904057715, +FRA/HAFP/CON TROLFILE/current.256.904057715 SQL> select member from v$logfile; MEMBER ------------------------------------------------------------------------------------------------------------------------------------ +DATA2/HAFP/ONLINELOG/group_1.257.904057715 +FRA/HAFP/ONLINELOG/group_1.257.904057715 +DATA2/HAFP/ONLINELOG/group_2.258.904057715 +FRA/HAFP/ONLINELOG/group_2.258.904057717 +DATA2/HAFP/ONLINELOG/group_3.259.904057717 +FRA/HAFP/ONLINELOG/group_3.259.904057717 6 rows selected. SQL> alter system switch logfile; System altered. SQL> seke lect name from v$archived_log; NAME ------------------------------------------------------------------------------------------------------------------------------------ +FRA/HAFP/ARCHIVELOG/2016_02_17/thread_1_seq_26.260.904059777 SQL> select * from v$datafile; FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED CHECKPOINT_CHANGE# CHECKPOIN UNRECOVERABLE_CHANGE# ---------- ---------------- --------- ---------- ---------- ------- ---------- ------------------ --------- --------------------- UNRECOVER LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE# ONLINE_TI BYTES BLOCKS CREATE_BYTES BLOCK_SIZE --------- ------------ --------- --------------- -------------- --------- ---------- ---------- ------------ ---------- NAME ------------------------------------------------------------------------------------------------------------------------------------ PLUGGED_IN BLOCK1_OFFSET ---------- ------------- AUX_NAME ------------------------------------------------------------------------------------------------------------------------------------ FIRST_NONLOGGED_SCN FIRST_NON FOREIGN_DBID FOREIGN_CREATION_CHANGE# FOREIGN_C PLU PLUGIN_CHANGE# PLUGIN_RESETLOGS_CHANGE# PLUGIN_RE ------------------- --------- ------------ ------------------------ --------- --- -------------- ------------------------ --------- CON_ID ---------- 1 7 17-FEB-16 0 1 SYSTEM READ WRITE 373991 17-FEB-16 0 0 0 734003200 89600 734003200 8192 +DATA2/HAFP/DATAFILE/system.260.904057717 0 4294967295 NONE 0 0 0 NO 0 0 0 2 2437 17-FEB-16 1 2 ONLINE READ WRITE 373991 17-FEB-16 0 0 0 576716800 70400 576716800 8192 +DATA2/HAFP/DATAFILE/sysaux.261.904057719 0 4294967295 NONE 0 0 0 NO 0 0 0 3 3249 17-FEB-16 2 3 ONLINE READ WRITE 373991 17-FEB-16 0 0 0 304087040 37120 209715200 8192 +DATA2/HAFP/DATAFILE/undotbs1.262.904057721 0 4294967295 NONE 0 0 0 NO 0 0 0 4 15468 17-FEB-16 4 4 ONLINE READ WRITE 373991 17-FEB-16 0 0 0 5242880 640 5242880 8192 +DATA2/HAFP/DATAFILE/users.264.904057729 0 4294967295 NONE 0 0 0 NO 0 0 0 SQL> alter database datafile u '+DATA2/HAFP/DATAFILE/users.264.904057729' resize 100m; Database altered. SQL> select * from v$datafile; FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED CHECKPOINT_CHANGE# CHECKPOIN UNRECOVERABLE_CHANGE# ---------- ---------------- --------- ---------- ---------- ------- ---------- ------------------ --------- --------------------- UNRECOVER LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE# ONLINE_TI BYTES BLOCKS CREATE_BYTES BLOCK_SIZE --------- ------------ --------- --------------- -------------- --------- ---------- ---------- ------------ ---------- NAME ------------------------------------------------------------------------------------------------------------------------------------ PLUGGED_IN BLOCK1_OFFSET ---------- ------------- AUX_NAME ------------------------------------------------------------------------------------------------------------------------------------ FIRST_NONLOGGED_SCN FIRST_NON FOREIGN_DBID FOREIGN_CREATION_CHANGE# FOREIGN_C PLU PLUGIN_CHANGE# PLUGIN_RESETLOGS_CHANGE# PLUGIN_RE ------------------- --------- ------------ ------------------------ --------- --- -------------- ------------------------ --------- CON_ID ---------- 1 7 17-FEB-16 0 1 SYSTEM READ WRITE 373991 17-FEB-16 0 0 0 734003200 89600 734003200 8192 +DATA2/HAFP/DATAFILE/system.260.904057717 0 4294967295 NONE 0 0 0 NO 0 0 0 2 2437 17-FEB-16 1 2 ONLINE READ WRITE 373991 17-FEB-16 0 0 0 576716800 70400 576716800 8192 +DATA2/HAFP/DATAFILE/sysaux.261.904057719 0 4294967295 NONE 0 0 0 NO 0 0 0 3 3249 17-FEB-16 2 3 ONLINE READ WRITE 373991 17-FEB-16 0 0 0 304087040 37120 209715200 8192 +DATA2/HAFP/DATAFILE/undotbs1.262.904057721 0 4294967295 NONE 0 0 0 NO 0 0 0 4 15468 17-FEB-16 4 4 ONLINE READ WRITE 373991 17-FEB-16 0 0 0 104857600 12800 5242880 8192 +DATA2/HAFP/DATAFILE/users.264.904057729 0 4294967295 NONE 0 0 0 NO 0 0 0 SQL> show parameter create_derst st SQL> show parameter create NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ create_bitmap_area_size integer 8388608 create_stored_outlines string db_create_file_dest string +DATA2 db_create_online_log_dest_1 string +DATA2 db_create_online_log_dest_2 string +FRA db_create_online_log_dest_3 string db_create_online_log_dest_4 string db_create_online_log_dest_5 string SQL> alter tablespace users add datafile size 100m; Tablespace altered. SQL> select * from v$datafile where ts#=4; FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED CHECKPOINT_CHANGE# CHECKPOIN UNRECOVERABLE_CHANGE# ---------- ---------------- --------- ---------- ---------- ------- ---------- ------------------ --------- --------------------- UNRECOVER LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE# ONLINE_TI BYTES BLOCKS CREATE_BYTES BLOCK_SIZE --------- ------------ --------- --------------- -------------- --------- ---------- ---------- ------------ ---------- NAME ------------------------------------------------------------------------------------------------------------------------------------ PLUGGED_IN BLOCK1_OFFSET ---------- ------------- AUX_NAME ------------------------------------------------------------------------------------------------------------------------------------ FIRST_NONLOGGED_SCN FIRST_NON FOREIGN_DBID FOREIGN_CREATION_CHANGE# FOREIGN_C PLU PLUGIN_CHANGE# PLUGIN_RESETLOGS_CHANGE# PLUGIN_RE ------------------- --------- ------------ ------------------------ --------- --- -------------- ------------------------ --------- CON_ID ---------- 4 15468 17-FEB-16 4 4 ONLINE READ WRITE 375419 17-FEB-16 0 0 0 104857600 12800 5242880 8192 +DATA2/HAFP/DATAFILE/users.264.904057729 0 4294967295 NONE 0 0 0 NO 0 0 0 5 375639 17-FEB-16 4 5 ONLINE READ WRITE 375640 17-FEB-16 0 0 0 104857600 12800 104857600 8192 +DATA2/HAFP/DATAFILE/users.266.904060063 0 4294967295 NONE 0 0 0 NO 0 0 0 SQL> alter tablespace users add datafile '+DATA' size 50m; Tablespace altered. SQL> select * from v$datafile where ts#=4; FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED CHECKPOINT_CHANGE# CHECKPOIN UNRECOVERABLE_CHANGE# ---------- ---------------- --------- ---------- ---------- ------- ---------- ------------------ --------- --------------------- UNRECOVER LAST_CHANGE# LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE# ONLINE_TI BYTES BLOCKS CREATE_BYTES BLOCK_SIZE --------- ------------ --------- --------------- -------------- --------- ---------- ---------- ------------ ---------- NAME ------------------------------------------------------------------------------------------------------------------------------------ PLUGGED_IN BLOCK1_OFFSET ---------- ------------- AUX_NAME ------------------------------------------------------------------------------------------------------------------------------------ FIRST_NONLOGGED_SCN FIRST_NON FOREIGN_DBID FOREIGN_CREATION_CHANGE# FOREIGN_C PLU PLUGIN_CHANGE# PLUGIN_RESETLOGS_CHANGE# PLUGIN_RE ------------------- --------- ------------ ------------------------ --------- --- -------------- ------------------------ --------- CON_ID ---------- 4 15468 17-FEB-16 4 4 ONLINE READ WRITE 375419 17-FEB-16 0 0 0 104857600 12800 5242880 8192 +DATA2/HAFP/DATAFILE/users.264.904057729 0 4294967295 NONE 0 0 0 NO 0 0 0 5 375639 17-FEB-16 4 5 ONLINE READ WRITE 375640 17-FEB-16 0 0 0 104857600 12800 104857600 8192 +DATA2/HAFP/DATAFILE/users.266.904060063 0 4294967295 NONE 0 0 0 NO 0 0 0 6 375735 17-FEB-16 4 6 ONLINE READ WRITE 375736 17-FEB-16 0 0 0 52428800 6400 52428800 8192 +DATA/HAFP/DATAFILE/users.257.904060191 0 4294967295 NONE 0 0 0 NO 0 0 0 SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ NEXT_TIME CON_ID --------- ---------- 1 1 25 52428800 512 2 YES INACTIVE 356742 17-FEB-16 366464 17-FEB-16 0 2 1 26 52428800 512 2 YES INACTIVE 366464 17-FEB-16 375419 17-FEB-16 0 3 1 27 52428800 512 2 NO CURRENT 375419 17-FEB-16 2.8147E+14 0 SQL> alter database add logfile group size 50m; alter database add logfile group size 50m * ERROR at line 1: ORA-02177: Missing required group number SQL> alter database add logfile group 4 size 50m; Database altered. SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ NEXT_TIME CON_ID --------- ---------- 1 1 25 52428800 512 2 YES INACTIVE 356742 17-FEB-16 366464 17-FEB-16 0 2 1 26 52428800 512 2 YES INACTIVE 366464 17-FEB-16 375419 17-FEB-16 0 3 1 27 52428800 512 2 NO CURRENT 375419 17-FEB-16 2.8147E+14 0 4 1 0 52428800 512 2 YES UNUSED 0 0 0 SQL> select member from v$logfile; MEMBER ------------------------------------------------------------------------------------------------------------------------------------ +DATA2/HAFP/ONLINELOG/group_1.257.904057715 +FRA/HAFP/ONLINELOG/group_1.257.904057715 +DATA2/HAFP/ONLINELOG/group_2.258.904057715 +FRA/HAFP/ONLINELOG/group_2.258.904057717 +DATA2/HAFP/ONLINELOG/group_3.259.904057717 +FRA/HAFP/ONLINELOG/group_3.259.904057717 +DATA2/HAFP/ONLINELOG/group_4.267.904060299 +FRA/HAFP/ONLINELOG/group_4.261.904060299 8 rows selected. SQL> SQL> SQL> exit
[/spoiler]
Listener abfragen
srvctl status listener Listener LISTENER is enabled Listener LISTENER is running on node(s): vmlso-asmt01
lsnrctl status LISTENER LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 18-FEB-2016 08:48:55 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vmlso-asmt01)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Solaris: Version 12.1.0.2.0 - Production Start Date 17-FEB-2016 16:19:29 Uptime 0 days 16 hr. 29 min. 25 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /apps/oracle/12.1.0.2/grid/network/admin/listener.ora Listener Log File /apps/oracle/diag/tnslsnr/vmlso-asmt01/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmlso-asmt01)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "hafp" has 1 instance(s). Instance "hafp", status READY, has 1 handler(s) for this service... Service "hafpXDB" has 1 instance(s). Instance "hafp", status READY, has 1 handler(s) for this service... The command completed successfully
Starten, Stoppen, Status und Config einer Datenbank
srvctl status database -d hafp srvctl start database -d hafp srvctl stop database -d hafp srvctl config database -d hafp
RDBMS Kompatibilität abfragen
set lines 160
set pages 100
col GROUP_NUMBER format 99999 heading GROUP
col NAME format a16
col TOTAL_MB format 99999
col FREE_MB format 99999
col REQUIRED_MIRROR_FREE_MB format 99999
col COMPATIBILITY format a10 heading COMPATIBLE
col DATABASE_COMPATIBILITY format a13 heading DB_COMPATIBLE
select
GROUP_NUMBER,
NAME,
TOTAL_MB,
FREE_MB,
REQUIRED_MIRROR_FREE_MB,
COMPATIBILITY,
DATABASE_COMPATIBILITY
from v$asm_diskgroup
order by NAME;
GROUP NAME TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB COMPATIBLE DB_COMPATIBLE
------ ---------------- -------- ------- ----------------------- ---------- -------------
2 DATA 9980 9832 0 12.1.0.0.0 10.1.0.0.0
1 DATA2 39920 35648 9980 12.1.0.0.0 10.1.0.0.0
3 FRA 9980 9460 0 12.1.0.0.0 10.1.0.0.0
alter diskgroup data set attribute 'compatible.rdbms' = '11.2.0.0.0'; alter diskgroup data2 set attribute 'compatible.rdbms' = '11.2.0.0.0'; alter diskgroup fra set attribute 'compatible.rdbms' = '11.2.0.0.0';
set lines 160
set pages 100
col GROUP_NUMBER format 99999 heading GROUP
col NAME format a16
col TOTAL_MB format 99999
col FREE_MB format 99999
col REQUIRED_MIRROR_FREE_MB format 99999
col COMPATIBILITY format a10 heading COMPATIBLE
col DATABASE_COMPATIBILITY format a13 heading DB_COMPATIBLE
select
GROUP_NUMBER,
NAME,
TOTAL_MB,
FREE_MB,
REQUIRED_MIRROR_FREE_MB,
COMPATIBILITY,
DATABASE_COMPATIBILITY
from v$asm_diskgroup
order by NAME;
GROUP NAME TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB COMPATIBLE DB_COMPATIBLE
------ ---------------- -------- ------- ----------------------- ---------- -------------
2 DATA 9980 9884 0 12.1.0.0.0 11.2.0.0.0
1 DATA2 79840 69880 9980 12.1.0.0.0 11.2.0.0.0
3 FRA 9980 6588 0 12.1.0.0.0 11.2.0.0.0
ASM Backup
Beim ASM Backup sind die folgenden drei Dinge essentiell:
- OLR File – Oracle Local Registry
- ASM Parameter File
- ASM Metadaten
Oracle Rollback pending transaction
Oracle Patch Set install
RMAN Catalog Maintenance for old Backups on Tape (sbt)
About Author
