LIXIANG'S BLOG
ҽ
л
ҵBlog
¹鵵...
·...
ͳ...
վ...
Դ
===========================================================
oracle11gRAC֮srvctl
===========================================================
oracle11gRAC֮srvctl

srvctl汾ѯ
[grid@dbserver1:/home/grid]$srvctl -V
srvctl version: 11.2.0.1.0

srvctlࣺ

* oracle asm/database/listener עϢ

egsrvctl add asm -l LISTENER -p +crs/dbserve-cluster/ASMPARAMETERFILE/registry.253.743836405

eg: srvctl add database -d orclqt -o /oracle/app/oracle/product/11.2.0/dbhome_1 -p +DATADG/orclqt/spfileorclqt.ora

eg: srvctl add listener -p TCP:1522 -o /u01/app/oracle/product/11.2.0/dbhome_1

*鿴 oracle asm/database/listener Ϣ

eg: srvctl config asm -a
ASM home: /oracle/app/11.2.0/grid
ASM listener: LISTENER
Spfile: +DATA/asm/asmparameterfile/registry.253.770900461
ASM diskgroup discovery string:
ASM is enabled.

eg: srvctl config database -d orclqt -a
Database unique name: orclqt
Database name: orclqt
Oracle home: /oracle/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATADG/orclqt/spfileorclqt.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orclqt
Database instances: orclqt1,orclqt2
Disk Groups: DATADG
Services:
Database is enabled
Database is administrator managed

eg: srvctl config listener
Name: LISTENER
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1521

*鿴 oracle database/instance/service/nodeapps/asm ״̬

eg: srvctl status database -d orclqt
Instance orclqt1 is running on node dbserver1
Instance orclqt2 is running on node dbserver2

eg: srvctl status instance -d orclqt -i "orclqt1,orclqt2"
Instance orclqt1 is running on node dbserver1
Instance orclqt2 is running on node dbserver2

eg: srvctl status nodeapps -n dbserver1
-n <node_name> option has been deprecated.
VIP dbserver1vip is enabled
VIP dbserver1vip is running on node: dbserver1
Network is enabled
Network is running on node: dbserver1
GSD is disabled
GSD is not running on node: dbserver1
ONS is enabled
ONS daemon is running on node: dbserver1
eONS is enabled
eONS daemon is running on node: dbserver1

eg: srvctl status asm
ASM is running on dbserver1,dbserver2
srvctl status asm -n dbserver2
ASM is running on dbserver2

* oracle asm/database/listener

eg: srvctl start asm

eg: srvctl start database -d orclqt -o /oracle/app/oracle/product/11.2.0/dbhome_1 -p +DATA/test/spfileorclqt.ora

eg: srvctl start listener -l LISTENER

*ֹͣ oracle asm/database/listener

eg: srvctl stop database -d orclqt

eg: srvctl stop instance -d orclqt -i qrclqt1

eg: srvctl stop asm -n dbserver1 -i +asm1

eg: srvctl stop listener -n dbserver1
lixiang114 :2012.03.31 10:38 ::: ( ORACLE ) ::Ķ:(57) :: (0) :: (0)
===========================================================
oracle11gRAC֮crsctl
===========================================================

oracle11gRAC֮crsctl

crsctl
# su - grid
[grid@dbserver1:/home/grid]$crsctl -h
Usage: crsctl add - add a resource, type or other entity
crsctl check - check a service, resource or other entity
crsctl config - output autostart configuration
crsctl debug - obtain or modify debug state
crsctl delete - delete a resource, type or other entity
crsctl disable - disable autostart
crsctl enable - enable autostart
crsctl get - get an entity value
crsctl getperm - get entity permissions
crsctl lsmodules - list debug modules
crsctl modify - modify a resource, type or other entity
crsctl query - query service state
crsctl pin - Pin the nodes in the nodelist
crsctl relocate - relocate a resource, server or other entity
crsctl replace - replaces the location of voting files
crsctl setperm - set entity permissions
crsctl set - set an entity value
crsctl start - start a resource, server or other entity
crsctl status - get status of a resource or other entity
crsctl stop - stop a resource, server or other entity
crsctl unpin - unpin the nodes in the nodelist
crsctl unset - unset a entity value, restoring its default

1crsctl start
crs
[grid@dbserver1:/oracle/app/11.2.0/grid/log/dbserver1/client]$crsctl start crs

crsԴ
[grid@dbserver1:/oracle/app/11.2.0/grid/log/dbserver1/client]$crsctl start -all

Դ(ԴԶҪֹ)
[grid@dbserver1:/oracle/app/11.2.0/grid/log/dbserver1/client]$crsctl start res ora.crsd -init

2crsctl stop
ֹͣcrs
[grid@dbserver1:/oracle/app/11.2.0/grid/log/dbserver1/client]$crsctl stop crs

ֹͣcrsԴ
[grid@dbserver1:/oracle/app/11.2.0/grid/log/dbserver1/client]$crsctl stop -all

Դ(ԴԶҪֹ)
[grid@dbserver1:/oracle/app/11.2.0/grid/log/dbserver1/client]$crsctl stop res ora.crsd -init (-f)


3crsctl check
crs
[grid@dbserver1:/home/grid]$crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

crsȺ
[grid@dbserver1:/home/grid]$crsctl check cluster -all
**************************************************************
dbserver1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
dbserver2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

4crsctl query
votedisk״̬
[grid@dbserver1:/oracle/app/11.2.0/grid/log/dbserver1/client]$crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 0b12969addea4f8fbf61eeaa0df697e6 (/dev/rhdisk6) [CRS]
Located 1 voting disk(s).

crs汾
[grid@dbserver1:/oracle/app/11.2.0/grid/log/dbserver1/client]$crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.1.0]

crsڵ汾
[grid@dbserver1:/oracle/app/11.2.0/grid/log/dbserver1/client]$crsctl query crs softwareversion dbserver1
Oracle Clusterware version on node [dbserver1] is [11.2.0.1.0]


lixiang114 :2012.03.28 17:22 ::: ( ORACLE ) ::Ķ:(33) :: (0) :: (0)
===========================================================
oracle11gRAC֮log־ϵ
===========================================================

oracle11gRAC֮log־ϵ

1CRS־grid

ѡ鿴alertlog

$CRS_HOME/grid/log/hostname/alertdbserver1.log

Clusterwarę־

crsd.Log: $ORA_CRS_HOME/grid/log/hostname/crsd/crsd.Log

ocssd.Log: $ORA_CRS_HOME/grid/log/hostname/cssd/ocsd.Log

evmd.Log: $ORA_CRS_HOME/grid/log/hostname/evmd/evmd.Log

ִ־

$ORA_CRS_HOME/log/hostname/client/

Clusterware ṩйߣ

crsctlocrcheck, ocrconfig,ocrdump,oifcfgclscfg, Щ߲־ͷĿ¼

2DB־oracle

alertlog

/diag/rdbms///trace
/oracle/app/oracle/diag/rdbms/orclfi/orclfi1/trace
/oracle/app/oracle/diag/rdbms/orclfi/orclfi2/trace

3lsnrctl log
/oracle/app/11.2.0/grid/log/diag/tnslsnr/dbserver2/listener_scan1/trace/listener_scan1.log


lixiang114 :2012.03.28 15:51 ::: ( ORACLE ) ::Ķ:(34) :: (0) :: (0)
===========================================================
oracle11gRAC֮asm
===========================================================

oracle11gRAC֮asm

һͨsqlplus鿴asm̻Ϣ

[grid@dbserver1:/home/grid]$sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 27 13:54:32 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
------------------------------------------------ ------------------------------------
+ASM1 STARTED

SQL> select group_number,name,state,type,total_mb,free_mb from v$asm_diskgroup;
SQL> col name format a15
SQL> /

GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB
------------ --------------- --------------------------------- ------------------ ---------- ----------
1 CRS MOUNTED EXTERN 15360 14960
2 DATADG MOUNTED EXTERN 3072000 1662844

SQL> col path format a15
SQL> col failgroup format a15
SQL> select group_number, name,failgroup, path,os_mb,free_mb,total_mb,state from V$asm_disk order by 1;

GROUP_NUMBER NAME FAILGROUP PATH OS_MB FREE_MB TOTAL_MB STATE
------------ --------------- --------------- --------------- ---------- ---------- ---------- ------------------------
1 CRS_0002 CRS_0002 /dev/rhdisk8 5120 4997 5120 NORMAL
1 CRS_0001 CRS_0001 /dev/rhdisk7 5120 4999 5120 NORMAL
1 CRS_0000 CRS_0000 /dev/rhdisk6 5120 4964 5120 NORMAL
2 DATADG_0003 DATADG_0003 /dev/rhdisk13 204800 110841 204800 NORMAL
2 DATADG_0004 DATADG_0004 /dev/rhdisk14 204800 110857 204800 NORMAL
2 DATADG_0005 DATADG_0005 /dev/rhdisk15 204800 110863 204800 NORMAL
2 DATADG_0006 DATADG_0006 /dev/rhdisk16 204800 110853 204800 NORMAL
2 DATADG_0007 DATADG_0007 /dev/rhdisk17 204800 110858 204800 NORMAL
2 DATADG_0008 DATADG_0008 /dev/rhdisk18 204800 110857 204800 NORMAL
2 DATADG_0009 DATADG_0009 /dev/rhdisk19 204800 110850 204800 NORMAL
2 DATADG_0010 DATADG_0010 /dev/rhdisk20 204800 110863 204800 NORMAL

GROUP_NUMBER NAME FAILGROUP PATH OS_MB FREE_MB TOTAL_MB STATE
------------ --------------- --------------- --------------- ---------- ---------- ---------- ------------------------
2 DATADG_0011 DATADG_0011 /dev/rhdisk21 204800 110860 204800 NORMAL
2 DATADG_0012 DATADG_0012 /dev/rhdisk22 204800 110864 204800 NORMAL
2 DATADG_0013 DATADG_0013 /dev/rhdisk23 204800 110858 204800 NORMAL
2 DATADG_0002 DATADG_0002 /dev/rhdisk12 204800 110849 204800 NORMAL
2 DATADG_0014 DATADG_0014 /dev/rhdisk9 204800 110857 204800 NORMAL
2 DATADG_0000 DATADG_0000 /dev/rhdisk10 204800 110858 204800 NORMAL
2 DATADG_0001 DATADG_0001 /dev/rhdisk11 204800 110856 204800 NORMAL

ͨasmcmd鿴Ϣ

[grid@dbserver1:/home/grid]$asmcmd
unix
ASMCMD> l
commands:
--------

md_backup, md_restore

lsattr, setattr

cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
mkdir, pwd, rm, rmalias

chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
offline, online, rebal, remap, umount

dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
spmove, spset, startup

chtmpl, lstmpl, mktmpl, rmtmpl

chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr

volcreate, voldelete, voldisable, volenable, volinfo
volresize, volset, volstat

ASMCMD> ls
CRS/
DATADG/
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 1048576 15360 14960 0 14960 0 N CRS/
MOUNTED EXTERN N 512 4096 1048576 3072000 1662844 0 1662844 0 N DATADG/
ASMCMD> cd datadg
ASMCMD> ls
DB_UNKNOWN/
ORCLFI/
ORCLQT/
RMAN/
TEST/
ASMCMD> ASMCMD> cd orclfi
ASMCMD> ls -l
Type Redund Striped Time Sys Name
Y ARCHIVELOG/
Y CONTROLFILE/
Y DATAFILE/
Y ONLINELOG/
Y TEMPFILE/
N spfileorclfi.ora => +DATADG/DB_UNKNOWN/PARAMETERFILE/SPFILE.295.757283423
ASMCMD> cd datafile
ASMCMD> ls -l
Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y APPPREDATA.275.766762363
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y APPPREDATA.756.766761795
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1043.751707999
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y CCXE.1045.766399299
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1085.751707775
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1119.751711581
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1131.751708671
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1156.751709343
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1164.751712029
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1216.751711805
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.1217.751711357
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y CCXE.1248.766399625
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.328.751712253
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.354.751709565
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.363.751710011
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.400.751710235
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.425.751711131
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.470.751708447
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.524.751710907
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.542.751708223
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y CCXE.632.766398931
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.658.751708895
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.701.751710459
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.750.751709789
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.835.751707387
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.859.751710685
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y CCXE.900.766398565
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y CCXE.902.751709119
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y CCXEMATEVIEW.1204.753533061
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y SYSAUX.280.743846019
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y SYSTEM.279.743846019
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y UNDOTBS1.281.743846019
DATAFILE UNPROT COARSE MAR 26 23:00:00 Y UNDOTBS2.290.743846287
DATAFILE UNPROT COARSE MAR 27 00:00:00 Y USERS.282.743846019

ASMCMD> du
Used_MB Mirror_used_MB
965984 965984


lixiang114 :2012.03.27 15:23 ::: ( ORACLE ) ::Ķ:(30) :: (0) :: (0)
===========================================================
sqlŻruleʹСĶ仯
===========================================================

ҵűԹִ鿴¸ñɵִмƻ

ִмƻ
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=16 Card=1 Bytes=71)


1 0 SORT (AGGREGATE)


2 1 TABLE ACCESS (BY INDEX ROWID) OF 'TOAF_ORDEREDPRODUCT' (Cost=18 Card=53 Bytes=901)


3 2 INDEX (RANGE SCAN) OF 'I_COLOURCODE' (NON-UNIQUE) (Cost=1 Card=19766)


4 0 SORT (AGGREGATE)


5 4 TABLE ACCESS (BY INDEX ROWID) OF 'TOAF_ORDEREDPRODUCT' (Cost=18 Card=53 Bytes=901)


6 5 INDEX (RANGE SCAN) OF 'I_COLOURCODE' (NON-UNIQUE) (Cost=1 Card=19766)


7 0 SORT (AGGREGATE)


8 7 TABLE ACCESS (BY INDEX ROWID) OF 'TOAF_ORDEREDPRODUCT' (Cost=18 Card=53 Bytes=901)


9 8 INDEX (RANGE SCAN) OF 'I_COLOURCODE' (NON-UNIQUE) (Cost=1 Card=19766)


10 0 TABLE ACCESS (BY INDEX ROWID) OF 'TSCM_PRODUCT' (Cost=2 Card=1 Bytes=37)


11 10 NESTED LOOPS (Cost=16 Card=1 Bytes=71)


12 11 HASH JOIN (Cost=14 Card=1 Bytes=34)


13 12 TABLE ACCESS (FULL) OF 'TVWS_PRODUCTQTY' (Cost=6 Card=4212 Bytes=67392)


14 12 TABLE ACCESS (FULL) OF 'TSCM_PRODUCTCOLOURSTYLE' (Cost=6 Card=4160 Bytes=74880)


15 11 INDEX (RANGE SCAN) OF 'IDX_TSCM_PRODUCT_1' (NON-UNIQUE) (Cost=1 Card=1)


ͳϢ
----------------------------------------------------------
8327 recursive calls
0 db block gets
184362743 consistent gets
23 physical reads
180 redo size
170200 bytes sent via SQL*Net to client
2183 bytes received via SQL*Net from client
279 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
4160 rows processed

consistent gets 184362743

Ĺԭ

TABLE ACCESS (FULL) OF 'TSCM_PRODUCTCOLOURSTYLE' (Cost=6 Card=4160 Bytes=74880)

TABLE ACCESS (FULL) OF 'TVWS_PRODUCTQTY' (Cost=6 Card=4212 Bytes=67392)

2еTABLE ACCESS (FULL)

ֶζΪoracleûлCBOʹСܴ۵Żû붮

sql/*+ RULE */ ִsql


ִмƻ
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=HINT: RULE


1 0 SORT (AGGREGATE)


2 1 TABLE ACCESS (BY INDEX ROWID) OF 'TOAF_ORDEREDPRODUCT'


3 2 AND-EQUAL


4 3 INDEX (RANGE SCAN) OF 'I_ORDEREDPRODPRODID' (NON-UNIQUE)


5 3 INDEX (RANGE SCAN) OF 'I_STYLECODE' (NON-UNIQUE)


6 3 INDEX (RANGE SCAN) OF 'I_COLOURCODE' (NON-UNIQUE)


7 0 SORT (AGGREGATE)


8 7 TABLE ACCESS (BY INDEX ROWID) OF 'TOAF_ORDEREDPRODUCT'


9 8 AND-EQUAL


10 9 INDEX (RANGE SCAN) OF 'I_ORDEREDPRODPRODID' (NON-UNIQUE)


11 9 INDEX (RANGE SCAN) OF 'I_STYLECODE' (NON-UNIQUE)


12 9 INDEX (RANGE SCAN) OF 'I_COLOURCODE' (NON-UNIQUE)


13 0 SORT (AGGREGATE)


14 13 TABLE ACCESS (BY INDEX ROWID) OF 'TOAF_ORDEREDPRODUCT'


15 14 AND-EQUAL


16 15 INDEX (RANGE SCAN) OF 'I_ORDEREDPRODPRODID' (NON-UNIQUE)


17 15 INDEX (RANGE SCAN) OF 'I_STYLECODE' (NON-UNIQUE)


18 15 INDEX (RANGE SCAN) OF 'I_COLOURCODE' (NON-UNIQUE)


19 0 TABLE ACCESS (BY INDEX ROWID) OF 'TSCM_PRODUCT'


20 19 NESTED LOOPS


21 20 NESTED LOOPS


22 21 TABLE ACCESS (FULL) OF 'TSCM_PRODUCTCOLOURSTYLE'


23 21 TABLE ACCESS (BY INDEX ROWID) OF 'TVWS_PRODUCTQTY'


24 23 INDEX (RANGE SCAN) OF 'IND_PRODUCTID' (NON-UNIQUE)


25 20 INDEX (RANGE SCAN) OF 'I_PRODUCTID_1' (NON-UNIQUE)


ͳϢ
----------------------------------------------------------
8332 recursive calls
0 db block gets
8781478 consistent gets
0 physical reads
0 redo size
172229 bytes sent via SQL*Net to client
2183 bytes received via SQL*Net from client
279 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
4166 rows processed

consistent getsԭ184362743 ٵ8781478

ֶҲ

TABLE ACCESS (BY INDEX ROWID) OF 'TVWS_PRODUCTQTY'


lixiang114 :2011.12.29 13:37 ::: ( ORACLE ) ::Ķ:(66) :: (0) :: (0)
===========================================================
Linuxntp ʱͬ
===========================================================

linuxͬʱ䱨ƴ

root@test log]#
[root@test log]# ntpdate 192.168.43.2
6 Sep 09:35:09 ntpdate[30210]: the NTP socket is in use, exiting
[root@test log]#

ڸNTPѾڣʱҪֹͣNTP

root@test log]#
[root@test log]# ntpdate 10.154.8.200
6 Sep 09:35:09 ntpdate[30210]: the NTP socket is in use, exiting
[root@test log]#

root@test init.d]# pwd
/etc/rc.d/init.d
[root@test init.d]# ./ntpd stop
Shutting down ntpd: [ OK ]
[root@test init.d]# ntpdate 192.168.43.2
6 Sep 09:37:19 ntpdate[30658]: step time server 10.161.8.200 offset -51.869609 sec


lixiang114 :2011.10.14 11:03 ::: ( LINUX ) ::Ķ:(141) :: (0) :: (0)
===========================================================
rmɾļʧ
===========================================================

logļʱ򱨴

$ rm -rf *.log
ksh: /bin/rm: arg list too long

$ find ./ -name *.log -exec rm{} ;
ksh: /bin/find: arg list too long

οϣʹrmɹ

echo *.log|xargs rm

ls /tmp|while read filename
do
echo $filename
rm $filename
done


lixiang114 :2011.10.14 10:52 ::: ( Solaris ) ::Ķ:(135) :: (0) :: (0)
===========================================================
netbackupָmedia server is not active
===========================================================

һָʱ򣬷netbackup⣺

1ָٳûɣ鿴jobs

# bpdbjobs
JobID Type State Status Policy Schedule Client Dest Media Svr Active PID FATPipe
7129 Restore Active sol2 22233
7128 Image Delete Done 0 20130

job7129һֱΪactive


2Ȳ鿴ŴϢппռ䣺

# available_media
media media robot robot robot side/ ret size status
ID type type # slot face level KBytes
----------------------------------------------------------------------------
CatalogBackup pool

0018L4 HCART TLD 0 2 - 5 40311168 ACTIVE
0019L4 HCART TLD 0 10 - - - AVAILABLE

DataStore pool

NetBackup pool

None pool

NU03CU HC_CLN TLD 0 23 - - - AVAILABLE
NU04CU HC_CLN TLD 0 16 - - - AVAILABLE

Oracle pool

0002L4 HCART TLD 0 21 - 3 2698358560 ACTIVE
0003L4 HCART TLD 0 6 - 3 2297925856 ACTIVE
0000L4 HCART TLD 0 19 - - - AVAILABLE
0001L4 HCART TLD 0 7 - - - AVAILABLE
0004L4 HCART TLD 0 15 - - - AVAILABLE
0005L4 HCART TLD 0 5 - - - AVAILABLE
0006L4 HCART TLD 0 18 - - - AVAILABLE
0007L4 HCART TLD 0 13 - - - AVAILABLE
0008L4 HCART TLD 0 14 - - - AVAILABLE
0009L4 HCART TLD 0 8 - - - AVAILABLE
0010L4 HCART TLD 0 12 - - - AVAILABLE
0011L4 HCART TLD 0 1 - - - AVAILABLE
0012L4 HCART TLD 0 22 - - - AVAILABLE
0013L4 HCART TLD 0 3 - - - AVAILABLE
0014L4 HCART TLD 0 4 - - - AVAILABLE
0015L4 HCART TLD 0 17 - - - AVAILABLE
0016L4 HCART TLD 0 9 - - - AVAILABLE
0017L4 HCART TLD 0 11 - - - AVAILABLE

3鿴ϸϢΪ

awaiting resource cbshp02-hcart3-robot-tld-0. Waiting for resources.

Reason: Tape media server is not active, Media server: sol1

Robot Type(Number): TLD(0), Media ID: N/A, Drive Name: N/A,

Volume Pool: unix, Storage Unit: cbshp02-hcart3-robot-tld-0, Drive Scan Host: N/A


4鿴media serveṛýûrunningԭ

# vmoprcmd -d

oprd returned abnormal status (96)
IPC Error: Daemon may not be running


# vmoprcmd -activate_host -h sol1

oprd returned abnormal status (96)
IPC Error: Daemon may not be running

5οĵ

http://www.symantec.com/business/support/index?page=content&id=TECH70502
http://www.symantec.com/connect/forums/media-server-not-active
http://www.ansonnotes.com/?p=106


6մ˲账

Solution/Workaround:

1Ran nbrbutil -resetMediaServer <media server> (preferably nbrbutil -resetall)
2Restarted NetBackup daemons on media server - now tldd is running again
3vmoprcmd now works fine, and the volume pools "came back."


7MediaServer

# nbrbutil -resetall
# nbrbutil -resetMediaServer all

8鿴MediaServerѾ


# vmoprcmd -activate_host -h sol1
# vmoprcmd

HOST STATUS
Host Name Version Host Status
========================================= ======= ===========
sol1 655000 ACTIVE

PENDING REQUESTS


<NONE>

DRIVE STATUS

Drive Name Label Ready RecMID ExtMID Wr.Enbl. Type
Host DrivePath Status
=============================================================================
HP.ULTRIUM4-SCSI.000 No No No hcart
sol1 /dev/rmt/1cbn TLD

HP.ULTRIUM4-SCSI.001 No No No hcart
sol1 /dev/rmt/0cbn TLD

ָ


lixiang114 :2011.09.15 13:48 ::: ( NetBackup ) ::Ķ:(362) :: (0) :: (0)
===========================================================
oracleڽʹ
===========================================================

¼һЩoracleúʹ

תԣhttp://blog.blueshop.com.tw/pili9141/articles/52418.aspx

1 ִú
2 1. ִ_ʼλ1
3 2. һ'B'ģʾԓ̎λԪYc̎pλԪY
4
5 A.ִִֵ
6
7 CHR(n)
8 --ɌASCII CODE Ddatabase character set
9
10 ex.
11 select CHR(67)||CHR(65) AA from dual;
12
13 AA
14 ----------
15 CA
16
17 select ASCII('') from dual;
18
19 ASCII('')
20 ----------
21 43982
22
23 select CHR(43982) from dual;
24
25 CHR(43982)
26 ----------
27
28
29 CONCAT(char1,char2)
30 --- BYchar1char2ɂִ
31 --- char1char2YϙQ
32 --- c||ִ֮BY̖ͬ concat('AA','BB') ɸij 'AA'||'BB'
33
34 ex.
35 select concat('AA','BB') AA from dual;
36
37 AA
38 ----------
39 AABB
40
41 INITCAP(chars)
42 --- ÿһֵDɴ
43 --- ֻӰӢģӰ
44
45 ex.
46 select INITCAP('aa') AA from dual;
47
48 AA
49 ----------
50 Aa
51
52 LOWER(chars)
53 --- 󌑵ִDС
54 --- ֻӰӢģӰ
55
56 ex.
57 select LOWER('AAAA') AA from dual;
58
59 AA
60 ----------
61 aaaa
62
63 UPPER(chars)
64 --- СִDɴ
65 --- ֻӰӢģӰ
66
67 ex.
68 select UPPER('aaaa') AA from dual;
69
70 AA
71 ----------
72 AAAA
73
74 LPAD(char1,n[,char2])
75 --- ִchar1ҿnԪtaִchar2
76 --- char2AOֵһհ
77
78 ex.
79 select LPAD('aa',5,'*') AA from dual;
80
81 AA
82 ----------
83 ***aa
84
85 RPAD(char1,n[,char2])
86 --- ִchar1󿿣nԪtaִchar2
87 --- char2AOֵһհ
88
89 ex.
90 select RPAD('aa',5,'*') AA from dual;
91
92 AA
93 ----------
94 aa***
95
96 LTRIM(char1[,set])
97 --- ִchar1߅_ʼȥsetԪ
98 --- setAOֵһհ
99 --- ֟oЧ
100
101 ex.
102 select LTRIM('aaBBBBaa','a') AA from dual;
103
104 AA
105 ----------
106 BBBBaa
107
108 RTRIM(char1[,set])
109 --- ִchar1߅_ʼȥsetԪ
110 --- setAOֵһհ
111 --- ֟oЧ
112
113 ex.
114 select RTRIM('aaBBBBaa','a') AA from dual;
115
116 AA
117 ----------
118 aaBBBB
119
120 REPLACE(char,search_string[,replacement_string])
121 --- charִҌsearch_stringҵጢDQreplacement_string
122 --- ʡreplacement_stringtremoved search_string
123
124 ex.
125 select REPLACE('aaBBBBaa','a','c') AA from dual;
126
127 AA
128 ----------
129 ccBBBBcc
130
131 select REPLACE('aaBBBBaa','a') AA from dual;
132
133 AA
134 ----------
135 BBBB
136
137 TRANSLATE(char,from,to)
138 --- ִcharfromĞto
139
140 ex.
141 select TRANSLATE(12345.12,'12345','ABCDE') AA from dual;
142
143 AA
144 ----------
145 ABCDE.AB
146
147 select TRANSLATE('abaaa','abcde','ABCDE') AA from dual;
148
149 AA
150 ----------
151 ABAAA
152
153 SUBSTR(char,m[,n])
154 --- ִcharɵmԪ_ʼXȡnԪ
155 --- mO0ɵһԪ_ʼXȡmOؓtִ_ʼ
156 --- ʡntmԪnؓtnullֵ
157
158 ex.
159 select SUBSTR('abcdef',-3,2) AA from dual;
160
161 AA
162 ----------
163 de
164
165 select SUBSTR('abcdef',3,-2) AA from dual;
166
167 AA
168 ----------
169 -- null
170
171 SUBSTRB(char,m[,n])
172 -- ÷substrͬsubstrb̎multi-byteY
173 -- Yώֻ̎single-byteYϣtsubstrsubstrbеĽYͬ
174
175 ex.
176 select SUBSTRB('yԇ',3,2) AA from dual;
177
178 AA
179 ----------
180 ԇ
181
182
183 B.ִֵؔ
184
185 INSTR(char1,char2[,n[,m]])
186 --- char1nԪ_ʼңmִchar2λ
187 --- nmAOֵ1ʡ
188 --- ҪĿʹINSTRB
189
190 ex.
191 select INSTR('aaBBBBaa','B') AA from dual;
192
193 AA
194 ----------
195 3
196
197 select INSTR('̨ aaa','') AA from dual;
198
199 AA
200 ----------
201 2
202
203 INSTRB(char1,char2[,n[,m]])
204 --- char1nԪ_ʼңmִchar2λ
205 --- nmAOֵ1ʡ
206 --- ÷INSTRͬ̎multi-byteY
207
208 ex.
209 select INSTRB('ˆA','',1,2) AA from dual;
210
211 AA
212 ----------
213 5
214
215 LENGTH(char)
216 --- ӋִcharL
217
218 LENGTHB(char)
219 --- ӋִcharL
220 --- λcharY͑BҙλYϰĕrʹ


lixiang114 :2011.09.05 11:21 ::: ( ORACLE ) ::Ķ:(125) :: (0) :: (0)
===========================================================
oracleڽʹ
===========================================================

һЩoracleڽʹ÷ʱ䳤˺ö඼ˣԼ¼

תԣhttp://blog.blueshop.com.tw/pili9141/articles/52418.aspx

1ִú
21. ִ_ʼλ1
32. һ'B'ģʾԓ̎λԪYc̎pλԪY
4
5A.ִִֵ
6
7 CHR(n)
8 --ɌASCII CODE Ddatabase character set
9
10 ex.
11 select CHR(67)||CHR(65) AA from dual;
12
13 AA
14 ----------
15 CA
16
17 select ASCII('') from dual;
18
19 ASCII('')
20 ----------
21 43982
22
23 select CHR(43982) from dual;
24
25 CHR(43982)
26 ----------
27
28
29 CONCAT(char1,char2)
30 -- BYchar1char2ɂִ
31 -- char1char2YϙQ
32 -- c||ִ֮BY̖ͬ concat('AA','BB') ɸij 'AA'||'BB'
33
34 ex.
35 select concat('AA','BB') AA from dual;
36
37 AA
38 ----------
39 AABB
40
41 INITCAP(chars)
42 -- ÿһֵDɴ
43 -- ֻӰӢģӰ
44
45 ex.
46 select INITCAP('aa') AA from dual;
47
48 AA
49 ----------
50 Aa
51
52 LOWER(chars)
53 -- 󌑵ִDС
54 -- ֻӰӢģӰ
55
56 ex.
57 select LOWER('AAAA') AA from dual;
58
59 AA
60 ----------
61 aaaa
62
63 UPPER(chars)
64 -- СִDɴ
65 -- ֻӰӢģӰ
66
67 ex.
68 select UPPER('aaaa') AA from dual;
69
70 AA
71 ----------
72 AAAA
73
74 LPAD(char1,n[,char2])
75 -- ִchar1ҿnԪtaִchar2
76 -- char2AOֵһհ
77
78 ex.
79 select LPAD('aa',5,'*') AA from dual;
80
81 AA
82 ----------
83 ***aa
84
85 RPAD(char1,n[,char2])
86 -- ִchar1󿿣nԪtaִchar2
87 -- char2AOֵһհ
88
89 ex.
90 select RPAD('aa',5,'*') AA from dual;
91
92 AA
93 ----------
94 aa***
95
96 LTRIM(char1[,set])
97 -- ִchar1߅_ʼȥsetԪ
98 -- setAOֵһհ
99 -- ֟oЧ
100
101 ex.
102 select LTRIM('aaBBBBaa','a') AA from dual;
103
104 AA
105 ----------
106 BBBBaa
107
108 RTRIM(char1[,set])
109 -- ִchar1߅_ʼȥsetԪ
110 -- setAOֵһհ
111 -- ֟oЧ
112
113 ex.
114 select RTRIM('aaBBBBaa','a') AA from dual;
115
116 AA
117 ----------
118 aaBBBB
119
120 REPLACE(char,search_string[,replacement_string])
121 -- charִҌsearch_stringҵጢDQreplacement_string
122 -- ʡreplacement_stringtremoved search_string
123
124 ex.
125 select REPLACE('aaBBBBaa','a','c') AA from dual;
126
127 AA
128 ----------
129 ccBBBBcc
130
131 select REPLACE('aaBBBBaa','a') AA from dual;
132
133 AA
134 ----------
135 BBBB
136
137 TRANSLATE(char,from,to)
138 -- ִcharfromĞto
139
140 ex.
141 select TRANSLATE(12345.12,'12345','ABCDE') AA from dual;
142
143 AA
144 ----------
145 ABCDE.AB
146
147 select TRANSLATE('abaaa','abcde','ABCDE') AA from dual;
148
149 AA
150 ----------
151 ABAAA
152
153 SUBSTR(char,m[,n])
154 -- ִcharɵmԪ_ʼXȡnԪ
155 -- mO0ɵһԪ_ʼXȡmOؓtִ_ʼ
156 -- ʡntmԪnؓtnullֵ
157
158 ex.
159 select SUBSTR('abcdef',-3,2) AA from dual;
160
161 AA
162 ----------
163 de
164
165 select SUBSTR('abcdef',3,-2) AA from dual;
166
167 AA
168 ----------
169 -- null
170
171 SUBSTRB(char,m[,n])
172 -- ÷substrͬsubstrb̎multi-byteY
173 -- Yώֻ̎single-byteYϣtsubstrsubstrbеĽYͬ
174
175 ex.
176 select SUBSTRB('yԇ',3,2) AA from dual;
177
178 AA
179 ----------
180 ԇ
181
182
183B.ִֵؔ
184
185 INSTR(char1,char2[,n[,m]])
186 -- char1nԪ_ʼңmִchar2λ
187 -- nmAOֵ1ʡ
188 -- ҪĿʹINSTRB
189
190 ex.
191 select INSTR('aaBBBBaa','B') AA from dual;
192
193 AA
194 ----------
195 3
196
197 select INSTR('̨ aaa','') AA from dual;
198
199 AA
200 ----------
201 2
202
203 INSTRB(char1,char2[,n[,m]])
204 -- char1nԪ_ʼңmִchar2λ
205 -- nmAOֵ1ʡ
206 -- ÷INSTRͬ̎multi-byteY
207
208 ex.
209 select INSTRB('ˆA','',1,2) AA from dual;
210
211 AA
212 ----------
213 5
214
215 LENGTH(char)
216 -- ӋִcharL
217
218 LENGTHB(char)
219 -- ӋִcharL
220 -- λcharY͑BҙλYϰĕrʹ


lixiang114 :2011.09.05 11:12 ::: ( ORACLE ) ::Ķ:(94) :: (0) :: (0)
===========================================================
nfsļϵͳ
===========================================================

NFS

# svcadm enable network/nfs/server

or

# /etc/init.d/nfs.server start

鿴NFS״̬

root@swallow4# svcs -l network/nfs/server
fmri svc:/network/nfs/server:default
name NFS server
enabled true (temporary)
state online
next_state none
state_time Thu Aug 25 11:14:35 2011logfile /var/svc/log/network-nfs-server:default.log
restarter svc:/system/svc/restarter:default
contract_id 1925
dependency require_any/error svc:/milestone/network (online)
dependency require_all/error svc:/network/nfs/nlockmgr (online)
dependency optional_all/error svc:/network/nfs/mapid (online)
dependency require_all/restart svc:/network/rpc/bind (online)
dependency optional_all/none svc:/network/rpc/keyserv (disabled)
dependency optional_all/none svc:/network/rpc/gss (online)
dependency require_all/error svc:/system/filesystem/local (online)


lixiang114 :2011.08.25 15:31 ::: ( Solaris ) ::Ķ:(147) :: (0) :: (0)
===========================================================
ڴDataGuard Physical Standbyݿ
===========================================================

DataGuard Physical Standbyݿ

ossolaris 10
dboracle9.2.0.6


1ݿΪForced Loggingģʽ

SQL>alter database force logging;

ǿ־ģʽ

ںnologgingѡ¼redoһdataguardԼȫҪϸߵݿ⣬Ҫе񶼿ͨ鵵лع

2鵵ģʽ屾ع鵵Ŀ¼

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=LOCATION=/oracle/app/archive' SCOPE=BOTH;


3ȷPrimary ݿļ

SQL> select * from v$dbfile;

FILE# NAME
----------------------------------------------------------------
10 /oracle/app/oradata/test/xdb01.dbf
9 /oracle/app/oradata/test/users01.dbf
2 /oracle/app/oradata/test/undotbs01.dbf
........

4ݿ⣺

ʹ䱸ݷʽݿ⡣

4.1ֹͣprimaryݿ⣺

SQL> SHUTDOWN IMMEDIATE;

4.2primaryݿ⣺

cp /oracle/app/oradata/test/system01.dbf
/oracle/app/oradata/test/standby/system01.dbf
........

4.3primaryݿ⣺
SQL> STARTUP;

5Physical Standbyݿļ

SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/oracle/app/control01.ctl';

Ȼ󿽱2control01.ctlļֱΪcontrol02.ctlcontrol03.ctl

6Physical Standbyݿõpfile

SQL> CREATE PFILE='/oracle/app/product/9.2.0/dbs/inittestdg.ora' FROM SPFILE;


7primaryݿ⿽ݵļstandby ݿ⣺

--ݵݿļļʱļ־ļŵ/oracle/app/oradata/testdg/
--ݵstandbyļŵ ŵ/oracle/app/oradata/testdg/
--ݵpfileʼļ ŵ/oracle/app/product/9.2/dbs/

8޸Physical Standbyݿpfileļ


db_name=test
compatible=9.2.0.0.0
standby_archive_dest='/oracle/app/standby_archive/'
db_file_name_convert=('/oracle/app/oradata/test/','/oracle/app/oradata/testdg/')
log_file_name_convert=('/oracle/app/archive/','/oracle/app/standby_archive/')
log_archive_format=log%d_%t_%s.arc
log_archive_dest_1=('LOCATION=/oracle/app/standby_archive/')
standby_file_management=AUTO
remote_archive_enable=TRUE
instance_name=testdg

# The following parameter is required only if the primary and standby databases
# are located on the same system.
lock_name_space=testdg

9Physical Standbyݿ־Ŀ¼鵵־Ŀ¼

$mkdir /oracle/app/admin/testdg/bdump
$mkdir /oracle/app/admin/testdg/cdump
$mkdir /oracle/app/admin/testdg/udump
$mkdir /oracle/app/standby_archive

10primarystandbyݿlistener.oratnsnames.ora

primaryݿlistener.ora£
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = /oracle/app/product/9.2)
(SID_NAME = test)
)
(SID_DESC =
(GLOBAL_DBNAME = testdg)
(ORACLE_HOME = /oracle/app/product/9.2)
(SID_NAME = testdg)
)


primaryݿtnsnames.ora£
TESTDG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sol2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdg)
)
)

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sol1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)

standyݿlistener.ora£
(SID_DESC =

(GLOBAL_DBNAME = testdg)
(ORACLE_HOME = /oracle/app/product/9.2.0)
(SID_NAME = testdg)

)

standyݿtnsnames.ora£
TESTDG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sol2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdg)
)
)
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sol1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)

Ȼprimarystandyݿļ
% lsnrctl stop
% lsnrctl start

11Physical StandbyݿConnection Detectionģʽ
޸SQLNET.ORA
SQLNET.EXPIRE_TIME=2

12Physical Standbyݿspfile
SQL> CREATE SPFILE FROM PFILE;

13Physical Standbyݿ⣺
SQL> STARTUP NOMOUNT;
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;

14־Ӧ÷
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
̷̨Ϊora_mrp0_testdg

15Physical StandbyݿĹ鵵
15.1primaryݿLOG_ARCHIVE_DEST_2
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=testdg' SCOPE=BOTH;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=BOTH;

15.2ԿʼԶ̹鵵
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;

16֤Physical Standbyݿ
16.1standbyݿѯv$archived_logͼ


SQL> select SEQUENCE#, FIRST_TIME, NEXT_TIME,name from V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIM NEXT_TIME NAME
--------------------------------------------------------------------------------

5 01-AUG-11 01-AUG-11 /oracle/app/standby_archive/log2055914502_1_5.arc

16.2primaryݿл鵵
SQL> alter system archive log current;
System altered.

16.3֤鵵־Ƿ͵standbyݿУ

SQL> select SEQUENCE#, FIRST_TIME, NEXT_TIME,name from V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIM NEXT_TIME NAME
--------------------------------------------------------------------------------

5 01-AUG-11 01-AUG-11 /oracle/app/standby_archive/log2055914502_1_5.arc
6 01-AUG-11 01-AUG-11 /oracle/app/standby_archive/log2055914502_1_6.arc

17֤µĹ鵵־ǷstandbyݿⱻӦã

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# APP
---------- ---
5 YES
6 YES

-THE END-


lixiang114 :2011.08.01 17:14 ::: ( ORACLE ) ::Ķ:(137) :: (0) :: (0)
===========================================================
ORA-600 [kgmimio1]
===========================================================

OS:Solaris10

DB:ORA9206

ϲ鿴alert.log´

Thu Jul 14 17:20:44 2011
Errors in file /oracle/app/admin/china111/udump/china111_ora_1393.trc:
ORA-00600: internal error code, arguments: [kgmimio1], [], [], [], [], [], [], []

Thu Jul 14 17:25:47 2011
Errors in file /oracle/app/admin/china111/udump/china111_ora_18307.trc:
ORA-00600: internal error code, arguments: [kgmimio1], [], [], [], [], [], [], []


googleûҵӦزģmetalinkҵϣ

ORA-600 [kgmimio1] [ID 309990.1]

* Errors in the alert.log file:

ORA-00600: internal error code, arguments: [kgmimio1], [], [], [], [], [], [], []

* Select from table or other fuction fails with ORA-00600 [kgmimio1]

* Call Stack Trace in the trace file shows the following function list:

ksedmp ksfdmp kgerinv kgeasnmierr kgmimio kgmexec evapls

ֿtraceȫϢ

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ?
000000000 ? 00000004A ?
FFFFFFFF7FFF77D8 ?
103312378 ?
kgerinv()+184 PTR_CALL 0000000000000000 00010373C ? 10373C000 ?
10373C968 ? 103741000 ?
000102C00 ? 000000000 ?
kgeasnmierr()+28 CALL kgerinv() 10373CBC8 ? 10385B348 ?
0000013C8 ? 000000000 ?
10373ECD4 ? 10373DF98 ?
kgmimio()+300 CALL kgeasnmierr() 10373CBC8 ? 10385B348 ?
103514278 ? 000000000 ?
788610BF0 ? 000001000 ?
kgmexec()+384 CALL kgmimio() 10373CBC8 ? 000000000 ?


Bug 2522666 was logged for the issue, but it was closed because a test case was not provided.

Ȼbug

ǽķrestart db ˣҵ񲻷æʱˢһshared pool ԰ɡ
Recompile the failing object (the package) although it does not show 'INVALID' status.
If you have revoked and granted privileges then revert the changes.
If still fails then flush the shared pool or restart the database and check if the problem reproduces.


lixiang114 :2011.07.15 10:29 ::: ( ORACLE ) ::Ķ:(138) :: (0) :: (0)
===========================================================
OracleRacϵṹ
===========================================================

ڿOracle9i:Real Application Clusters S.G

ϵṹһЩʵؽܣ

SMP(Symmetric Multi-Processor)

νԳƶദṹָжCPUԳƹλϵCPUͬڴ棬ÿCPUڴеκεַʱͬģSMP ҲΪһ´洢ʽṹ(UMAUniform Memory Access)SMPչķʽڴ桢ʹøCPUCPUI/O(ۿ)ԼӸⲿ豸(ͨǴ̴洢)

SMPҪǹϵͳԴ(CPUڴ桢I/O)ǹġҲSMPҪ⣬ǾչdzޡSMPԣÿһĻڶSMPչʱƿƵڴ档ÿCPUͨͬڴ߷ͬڴԴCPU ӣڴʳͻѸӣջCPUԴ˷ѣʹCPUܵЧԴ󽵵͡ʵ֤SMPCPUõ24CPU

NUMA(Non-Uniform Memory Access)

SMPչϵƣǿʼ̽νЧչӶϵͳļNUMAŬµĽ֮һNUMA԰ѼʮCPU(ϰٸCPU)һڡ

NUMAĻǾжCPUģ飬ÿCPUģɶCPU(4)ɣҾжıڴ桢I/Oۿڵȡڵ֮ͨģ(ΪCrossbar Switch)ӺϢÿCPUԷϵͳڴ(NUMAϵͳMPPϵͳҪ)ȻʱڴٶȽԶԶڷԶڴ(ϵͳڵڴ)ٶȣҲǷһ´洢NUMAص㣬Ϊ˸õطϵͳܣӦóʱҪٲͬCPUģ֮Ϣ

NUMAԽϺõؽԭSMPϵͳչ⣬һڿ֧ϰٸCPUȽϵ͵NUMAӰHPSuperdomeSUN15KIBMp690ȡ

NUMAͬһȱݣڷԶڴʱԶԶڴ棬˵CPUʱϵͳ޷ӡHP˾SuperdomeʱHPUNIXֵ֣64·CPUSuperdome (NUMAṹ)ֵ208·N4000(SMPṹ)ֵ6.3Կ8CPUֻ3ܵ

UDP(User Data Protocol)

UDPUser Data ProtocolûݱЭ飩TCPӦЭ顣ӵЭ飬ԷӣֱӾͰݰ͹ȥҪ֧ЩҪڼ֮䴫ݵӦáOracle RACʹUDP on GigaBit Ethernet(Gbe)ΪڵͨѶЭ

OSD(operating system-dependent ) clusterware

ΪRACṩϵͳͼȺķOSDOracleṩwindowsƽ̨Ӳṩunixƽ̨

OSD֣
The Cluster Manager(CM)ȺӽڵͨţͨinterconnectЭڵͬʱṩCLUSTERнڵʵͳһͼCMCLUSTERijԱʸ

interprcoess Communication(IPC)interconnectϢ;ΪracϢݡ

GSD(Global Service Daemon)

ȫַػRacʵֹͣͻʹServer Control Utility(SRVCTL)ʹDBCAOEMȵȣڴ˷磬˷һSRVCTLֹͣлʵÿڵִи󣬴˷񷵻ִнSRVCTL̡


lixiang114 :2011.07.05 14:29 ::: ( ORACLE ) ::Ķ:(165) :: (0) :: (0)
===========================================================
solairs10findʹ
===========================================================

root@swallow1# find /bea -name subversion.xml

/beaĿ¼ Ϊ subversion.xml

/bea/Deployment/Temp-IT3/subversion.xml
/bea/Deployment/bundle/et1.config/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0317/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0323/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0326/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0303/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0330/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0331/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0406/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0409/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0426/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0515/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_0913/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_20101226/BatchCore/subversion.xml
/bea/Deployment/bundle/27-December-2010/et1.config/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_20110303/BatchCore/subversion.xml
/bea/Deployment/bundle/et1.config_20110513/BatchCore/subversion.xml
root@swallow1#

root@swallow4# find /bea -name 'classes' -type d

/beaĿ¼ Ŀ¼Ϊclassesļ


/bea/bea814/weblogic81/common/eval/dbvisualizer/wrapper/classes
/bea/bea814/weblogic81/server/ext/jdbc/sybase/jConnect-5_5/classes
/bea/bea814/weblogic81/samples/partners/Crystal-Reports/ReportsWeb/WEB-INF/classes
/bea/bea814/weblogic81/samples/workshop/ExtensionDevKit/ControlDevKit/.workshop/output/ControlTest/WEB-INF/classes
/bea/bea814/weblogic81/samples/workshop/ExtensionDevKit/TaglibExtDevKit/TaglibWebProject/WEB-INF/classes
/bea/bea814/weblogic81/samples/workshop/SamplesApp/.workshop/output/GettingStarted/WEB-INF/classes
/bea/bea814/weblogic81/samples/workshop/SamplesApp/.workshop/output/WebApp/WEB-INF/classes
/bea/bea814/weblogic81/samples/workshop/SamplesApp/.workshop/output/WebServices/WEB-INF/classes
/bea/bea814/weblogic81/samples/workshop/SamplesApp/GettingStarted/WEB-INF/classes
/bea/bea814/weblogic81/samples/workshop/SamplesApp/WebApp/WEB-INF/classes


lixiang114 :2011.06.29 09:57 ::: ( Solaris ) ::Ķ:(203) :: (0) :: (0)