CentOS以外への挑戦で、Miracle4_X86_64+Oracle10g-R2-X86_64の導入、こちらはOranaviがあるので特に問題なく導入が完了、本当に簡単だ。
login as: oracle
oracle@172.21.20.45's password:
[oracle@localhost ~]$ ps -ax
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
PID TTY STAT TIME COMMAND
1 ? S 0:02 init [5]
2 ? S 0:00 [migration/0]
3 ? SN 0:00 [ksoftirqd/0]
4 ? S 0:00 [migration/1]
5 ? SN 0:00 [ksoftirqd/1]
6 ? S< 0:17 [events/0]
7 ? S< 0:21 [events/1]
8 ? S< 0:00 [khelper]
9 ? S< 0:00 [kacpid]
29 ? S< 0:00 [kblockd/0]
30 ? S< 0:00 [kblockd/1]
31 ? S 0:00 [khubd]
46 ? S< 0:00 [aio/0]
45 ? S 0:07 [kswapd0]
47 ? S< 0:00 [aio/1]
632 ? S 0:00 [kseriod]
706 ? S< 0:00 [ata/0]
707 ? S< 0:00 [ata/1]
709 ? S 0:00 [scsi_eh_0]
710 ? S 0:00 [scsi_eh_1]
718 ? S< 0:00 [kmirrord/0]
719 ? S< 0:00 [kmirrord/1]
727 ? S 0:22 [kjournald]
1281 ? S< 0:00 udevd
3062 ? S 0:00 [kjournald]
3359 ? Ss 0:15 cpuspeed -d -i 2
3621 ? Ss 0:00 syslogd -m 0
3626 ? Ss 0:00 klogd -x
3636 ? Ss 0:13 irqbalance
3671 ? Ss 0:00 /usr/sbin/acpid
3705 ? Ss 0:00 /usr/sbin/sshd
3747 ? Ss 0:00 crond
3810 ? Ss 0:01 xfs -droppriv -daemon
3827 ? Ss 0:00 /usr/sbin/atd
3844 ? Ss 0:00 dbus-daemon-1 --system
3853 ? Ss 0:04 hald
3863 tty1 Ss+ 0:00 /sbin/mingetty tty1
3865 tty2 Ss+ 0:00 /sbin/mingetty tty2
3866 tty3 Ss+ 0:00 /sbin/mingetty tty3
3867 tty4 Ss+ 0:00 /sbin/mingetty tty4
3868 tty5 Ss+ 0:00 /sbin/mingetty tty5
3869 tty6 Ss+ 0:00 /sbin/mingetty tty6
3870 ? Ss 0:00 kdm -nodaemon
4290 ? S 6:00 /usr/X11R6/bin/X -auth /var/run/xauth/A:0-cQAj3T
4294 ? S 0:00 -:0
4395 ? S 0:00 /bin/sh /usr/bin/startkde
4424 ? Ss 0:00 /usr/bin/ssh-agent -s
4459 ? S 0:00 /usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xclients
4460 ? Ss 0:00 dbus-daemon-1 --fork --print-pid 9 --print-address 7 --session
4467 ? Ss 0:00 kdeinit: Running...
4471 ? S 0:00 kdeinit: dcopserver --nosid
4473 ? S 0:00 kdeinit: klauncher
4476 ? S 0:18 kdeinit: kded
4479 ? Ss 0:00 /usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay
4481 ? Ss 0:19 /usr/lib64/scim-1.0/scim-launcher -d -c socket -e socket -f x11
4487 ? Ss 0:00 /usr/lib64/scim-1.0/scim-helper-manager
4488 ? Ssl 0:14 /usr/lib64/scim-1.0/scim-panel-gtk --display :0.0 -c socket -d --no-stay
4498 ? S 0:15 artsd -F 10 -S 4096 -s 1 -m artsmessage -c drkonqi -l 3 -f
4502 ? S 1:00 kdeinit: knotify
4506 ? S 0:01 kwrapper ksmserver
4508 ? S 0:00 kdeinit: ksmserver
4509 ? S 0:01 kdeinit: kwin
4511 ? S 0:11 kdeinit: kdesktop
4513 ? S 0:18 kdeinit: kicker
4514 ? S 0:00 kdeinit: kio_file file /tmp/ksocket-root/klauncherUbQHxb.slave-socket /tm
4516 ? S 0:52 /usr/bin/autorun --interval=1000
4527 ? S 0:11 kdeinit: konqueror file:/media/cdrecorder
4558 ? S 0:00 /usr/libexec/gconfd-2 14
22945 ? Ssl 0:00 /opt/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
23208 ? Ss 0:00 sshd: unknown [priv]
23219 ? Z 0:00 [sshd]
23556 ? S 0:02 [pdflush]
24310 ? Ss 0:01 ora_pmon_orcl
24312 ? Ss 0:00 ora_psp0_orcl
24314 ? Ss 0:00 ora_mman_orcl
24316 ? Ss 0:02 ora_dbw0_orcl
24318 ? Ss 0:02 ora_lgwr_orcl
24320 ? Ss 0:06 ora_ckpt_orcl
24323 ? Ss 0:02 ora_smon_orcl
24325 ? Ss 0:00 ora_reco_orcl
24327 ? Ss 0:01 ora_cjq0_orcl
24329 ? Ss 0:02 ora_mmon_orcl
24331 ? Ss 0:02 ora_mmnl_orcl
24333 ? Ss 0:00 ora_d000_orcl
24335 ? Ss 0:00 ora_s000_orcl
24349 ? Ss 0:00 ora_qmnc_orcl
24363 ? Ss 0:00 ora_q000_orcl
24365 ? Ss 0:00 ora_q001_orcl
25402 ? S 0:00 /opt/app/oracle/product/10.2.0/db_1/perl/bin/perl /opt/app/oracle/product
25431 ? Sl 0:01 /opt/app/oracle/product/10.2.0/db_1/jdk/bin/java -server -Xmx256M -XX:Max
26090 ? Sl 0:00 /opt/app/oracle/product/10.2.0/db_1/bin/emagent
26216 ? Ss 0:00 oracleorcl (LOCAL=NO)
26241 ? Ss 0:04 oracleorcl (LOCAL=NO)
26279 ? Ss 0:02 oracleorcl (LOCAL=NO)
26281 ? Ss 0:05 oracleorcl (LOCAL=NO)
26609 ? Sl 0:00 /opt/app/oracle/product/10.2.0/db_1/jdk/bin/java -Djava.awt.headless=true
26730 ? S 0:01 kdeinit: konsole
26791 pts/0 Ss+ 0:00 /bin/bash
27107 ? S 0:00 [pdflush]
20520 ? Ss 0:00 sshd: oracle [priv]
20535 ? Ss 0:00 ora_j000_orcl
20540 ? S 0:00 sshd: oracle@pts/1
20541 pts/1 Ss 0:00 -bash
20570 pts/1 R+ 0:00 ps -ax
AMD64 MM1GB で導入に約2時間30分かかりました
[oracle@localhost ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 土 3月 3 04:12:05 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
に接続されました。
SQL>
[oracle@localhost ~]$ cd /opt/app/oracle/product/10.2.0/db_1/bin
[oracle@localhost bin]$ ls
DBConsole.pm emca impdpO nmus racgmain
EMAgent.pm emctl isqlplusctl nmus0 racgmainO
EMDeploy.pm emctl.pl isqlplusctl.pl oclsmon racgmdb
EmctlCommon.pm emctl.template kfod oclsmon.bin racgmdbO
IASConsole.pm emdctl kfod0 ocrcheck racgons
adapters emdctl0 kfodO ocrcheck.bin racgwrap
agentok.sh emdfail.command kgmgr ocrcheck0 racgwrap.sbs
agtctl emdlctl.template kgmgrO ocrconfig rawutl
agtctlO emdrollogs.pl kgpmon ocrconfig.bin rconfig
aqxmlctl emlfail.command lbuilder ocrconfig0 relink
aqxmlctl.pl emrepdown.pl lcsscan ocrdump repo_mig
asmcmd emrepdown.sh ldapadd ocrdump.bin rman
asmcmdcore emtgtctl ldapaddmt ocrdump0 rmanO
bndlchk emtgtctl2 ldapbind ocssd runclass
clscfg emtgtctl20 ldapcompare ocssd.bin sbttest
clscfg.bin emutil ldapdelete odisrvreg sbttestO
clsfmt emwd ldapmoddn oerr schema
clsfmt.bin emwd.pl ldapmodify oidadmin schemasync
clsid exp ldapmodifymt oidca sqlldr
clsid.bin expO ldapsearch oidprovtool sqlldrO
cluvfy expdp ldifmigrator oifcfg sqlplus
commonenv expdpO linkshlib oifcfg0 sqlplusO
commonenv.bat.template extjob lmsgen ojvmjava srvconfig
commonenv.template extjobO loadjava okdstry srvctl
coraenv extjobo loadpsp okdstry0 srvmspawn
crsctl extjoboO loadpspO okinit sslsetup
crsctl.bin extproc localconfig okinit0 statusnc
csscan extproc32 lsnrctl oklist symfind
csscanO extproc32O lsnrctl0 oklist0 sysresv
ctxkbtc extprocO lxchknlb olsadmintool targetdeploy.pl
ctxlc extusrupgrade lxegen olsoidsync tg4pwd
ctxlcO fmputl lxinst onsctl tg4pwdO
ctxload fmputlhp makerootca.sh oracg tkprof
ctxloadO genagtsh makeserverwlt oracle tkprofO
cursize genclntsh mapsga oracleO tnnfg.dbl
cursizeO genclntst mapsga0 oradism tnslsnr
dbca genezi maxmem oradismO tnslsnr0
dbfsize geneziO maxmemO oraenv tnsping
dbfsizeO genksms mkstore orajaxb tnsping0
dbhome gennfgt mkwallet orapipe transx
dbshut gennttab ncomp orapki trcasst
dbstart genoccish netca orapwd trcldr
dbua genorasdksh netca_deinst.sh orapwdO trcroute
dbv gensyslib netmgr oratclsh trcroute0
dbvO grdcscan nid oraxml trcsess
deploync gsd nidO oraxsl tstshm
dgmgrl gsd.sh nmb osdbagrp tstshmO
dgmgrlO gsdctl nmb0 osdbagrp0 umu
dropjava helpins nmcbufp osh unzip
dsml2ldif hsalloci nmccollector ott wrap
dumpsga hsallociO nmccollector0 owm wrapO
dumpsga0 hsdepxa nmei proc xml
e2eme hsdepxaO nmei0 processDef.pl xmlcg
e2eme0 hsodbc nmo proxyserv xmlwf
echodo hsodbcO nmo0 proxyserv.bin xsl
emagent hsots nmocat pupbld xsql
emagent0 hsotsO nmocat0 racgeut xvm
emagentdeploy.pl imp nmuct racgeutO zip
emagtm impO nmupm racgimon
emagtm0 impdp nmupm0 racgimonO
[oracle@localhost bin]$ ./emctl start dbconsole
TZ set to Japan
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ......... started.
------------------------------------------------------------------
Logs are generated in directory /opt/app/oracle/product/10.2.0/db_1/localhost.localdomain_orcl/sysman/log
[oracle@localhost bin]$ ./isqlplusctl start
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Starting iSQL*Plus
バックアップを実行せずに動かしていたらある日、エラーになっていました
oracle@centos bin]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 月 3月 26 22:09:20 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
に接続されました。
SQL> ARCHIVE LOG LIST
ORA-00210: 指定された制御ファイルをオープンできません
ORA-00202: 制御ファイル: '/u01/app/oracle/oradata/orcl/control01.ctl'
ORA-27041: ファイルをオープンできません。
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> ARCHIVE LOG LIST
データベース・ログ・モード アーカイブ・モード
自動アーカイブ 有効
アーカイブ先 USE_DB_RECOVERY_FILE_DEST
最も古いオンライン・ログ順序 76
アーカイブする次のログ順序 76
[root@centos ORCL]# ls
archivelog
[root@centos ORCL]# cd archivelog
[root@centos archivelog]# ls
2007_03_22 2007_03_23 2007_03_24 2007_03_25 2007_03_26 2007_03_27
[root@centos archivelog]# ls -la
合計 32
drwxr-x--- 8 oracle oinstall 4096 3月 27 09:27 .
drwxr-x--- 3 oracle oinstall 4096 3月 7 11:31 ..
drwxr-x--- 2 oracle oinstall 4096 3月 22 22:00 2007_03_22
drwxr-x--- 2 oracle oinstall 4096 3月 23 22:00 2007_03_23
drwxr-x--- 2 oracle oinstall 4096 3月 24 03:00 2007_03_24
drwxr-x--- 2 oracle oinstall 4096 3月 25 00:00 2007_03_25
drwxr-x--- 2 oracle oinstall 4096 3月 26 00:00 2007_03_26
drwxr-x--- 2 oracle oinstall 4096 3月 27 11:47 2007_03_27
[root@centos archivelog]# du
4 ./2007_03_25
138656 ./2007_03_23
276272 ./2007_03_27
138528 ./2007_03_22
4 ./2007_03_26
4 ./2007_03_24
553472 .
10g からは、USE_DB_RECOVERY_FILE_DEST = 2GB になっているようです、とりあえず不要な
ものを削除して、dbora の停止と再起動。うまく動作せず、USE_DB_RECOVERY_FILE_DEST = 4GB にして
再度立ち上げかえすと無事起動したが、USE_DB_RECOVERY_FILE_DEST の不要領域は改善せず、やはり
バックアップが必要。
[root@centos archivelog]# export 実行
Job EXPORT000041 has been reopened at Tuesday, 27 March, 2007 16:14
Restarting "SYSTEM"."EXPORT000041":
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. estimated "SYSMAN"."MGMT_METRICS_RAW" 4 MB
. estimated "SYSMAN"."MGMT_SEVERITY" 4 MB
. estimated "SYSMAN"."MGMT_METRICS_1HOUR" 3 MB
. estimated "SYSMAN"."MGMT_HC_OS_COMPONENTS" 768 KB
. estimated "SYSMAN"."MGMT_HC_VENDOR_SW_COMPONENTS" 768 KB
. estimated "SYSMAN"."MGMT_METRICS" 704 KB
. estimated "SYSMAN"."MGMT_STRING_METRIC_HISTORY" 512 KB
. estimated "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" 512 KB
. . exported "SYSTEM"."REPCAT$_RUNTIME_PARMS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_SITES_NEW" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_SITE_OBJECTS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_SNAPGROUP" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_PARMS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES" 0 KB 0 rows
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0 rows
. . exported "TSMSYS"."SRS$" 0 KB 0 rows
Master table "SYSTEM"."EXPORT000041" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.EXPORT000041 is:
/u01/app/oracle/product/10.2.0/db_1/md/admin/EXPDAT01.DMP
Job "SYSTEM"."EXPORT000041" successfully completed at 16:19:19
Job state: COMPLETED
[oracle@centos db_1]$ df
Filesystem 1K-ブロック 使用 使用可 使用% マウント位置
/dev/mapper/VolGroup00-LogVol00
36414164 12341308 22223104 36% /
/dev/hda1 101086 14511 81356 16% /boot
none 480220 0 480220 0% /dev/shm
[oracle@centos db_1]$ cd ../..//
[oracle@centos product]$ ls
10.2.0
[oracle@centos product]$ cd ..
[oracle@centos oracle]$ ls
admin arch_log flash_recovery_area oraInventory oradata product
[oracle@centos oracle]$ cd flash_recovery_area
[oracle@centos flash_recovery_area]$ ls
ORCL
[oracle@centos flash_recovery_area]$ cd ORCL
[oracle@centos ORCL]$ ls
archivelog backupset datafile
[oracle@centos ORCL]$ ls -la
合計 20
drwxr-x--- 5 oracle oinstall 4096 3月 28 02:03 .
drwxr-x--- 3 oracle oinstall 4096 3月 7 11:31 ..
drwxr-x--- 9 oracle oinstall 4096 3月 28 04:00 archivelog
drwxr----- 3 oracle oinstall 4096 3月 28 02:03 backupset
drwxr----- 2 oracle oinstall 4096 3月 28 02:02 datafile
[oracle@centos ORCL]$ cd archivelog
[oracle@centos archivelog]$ ls
2007_03_22 2007_03_24 2007_03_26 2007_03_28
2007_03_23 2007_03_25 2007_03_27
[oracle@centos archivelog]$ ls -la
合計 36
drwxr-x--- 9 oracle oinstall 4096 3月 28 04:00 .
drwxr-x--- 5 oracle oinstall 4096 3月 28 02:03 ..
drwxr-x--- 2 oracle oinstall 4096 3月 22 22:00 2007_03_22
drwxr-x--- 2 oracle oinstall 4096 3月 23 22:00 2007_03_23
drwxr-x--- 2 oracle oinstall 4096 3月 24 03:00 2007_03_24
drwxr-x--- 2 oracle oinstall 4096 3月 25 00:00 2007_03_25
drwxr-x--- 2 oracle oinstall 4096 3月 26 00:00 2007_03_26
drwxr-x--- 2 oracle oinstall 4096 3月 27 22:00 2007_03_27
drwxr-x--- 2 oracle oinstall 4096 3月 28 04:00 2007_03_28
[oracle@centos archivelog]$ cd ..
[oracle@centos ORCL]$ ls
archivelog backupset datafile
[oracle@centos ORCL]$ cd backupset
[oracle@centos backupset]$ ls
2007_03_28
[oracle@centos backupset]$ cd 2007_03_28
[oracle@centos 2007_03_28]$ ls
o1_mf_ncsn1_TAG20070328T020020_30lmlvlg_.bkp
[oracle@centos 2007_03_28]$ ls -la
合計 7028
drwxr----- 2 oracle oinstall 4096 3月 28 02:03 .
drwxr----- 3 oracle oinstall 4096 3月 28 02:03 ..
-rw-r----- 1 oracle oinstall 7176192 3月 28 02:03 o1_mf_ncsn1_TAG20070328T0200
20_30lmlvlg_.bkp
[oracle@centos 2007_03_28]$ cd ../../
[oracle@centos ORCL]$ ls
archivelog backupset datafile
[oracle@centos ORCL]$ cd datafile
[oracle@centos datafile]$ ls
o1_mf_sysaux_30lmkbqj_.dbf o1_mf_users_30lmhk2m_.dbf
o1_mf_system_30lmf61n_.dbf
[oracle@centos datafile]$ ls -la
合計 1599044
drwxr----- 2 oracle oinstall 4096 3月 28 02:02 .
drwxr-x--- 5 oracle oinstall 4096 3月 28 02:03 ..
-rw-r----- 1 oracle oinstall 377495552 3月 28 02:03 o1_mf_sysaux_30lmkbqj_.dbf
-rw-r----- 1 oracle oinstall 734011392 3月 28 02:01 o1_mf_system_30lmf61n_.dbf
-rw-r----- 1 oracle oinstall 524296192 3月 28 02:02 o1_mf_users_30lmhk2m_.dbf
[oracle@centos datafile]$
アーカイブモードの変更
spfile='/u01/app/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora'
|