pat98's always & forever

- silent mode 에서 전부 Big file 로 만드는 방법 (Tablespace 별 개별적으로 true로 하지 않고)

1. Templates 화일의 최소 충족요건으로 변경

$ORACLE_HOME/assistants/dbca/templates/New_Database.dbt 화일내의 USERS tabllespace 의 datafile 최소크기를 최소 7M 로 변경함.

      <DatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/users01.dbf">
         <tablespace>USERS</tablespace>
         <temporary>false</temporary>
         <online>true</online>
         <status>0</status>
         <size unit="MB">7</size>
         <reuse>true</reuse>
         <autoExtend>true</autoExtend>
         <increment unit="KB">1280</increment>
         <maxSize unit="MB">-1</maxSize>
      </DatafileAttributes>

2. -useBigFileForTablespace 옵션 사용 
dbca -silent -createDatabase -gdbName BIGORCL -templateName New_Database.dbt -useBigFileForTablespace true


3. 확인
sys@BIGORCL> select TABLESPACE_NAME, BIGFILE from DBA_TABLESPACES;

TABLESPACE_NAME                BIG
------------------------------ ---
SYSTEM                         YES
SYSAUX                         YES
UNDOTBS1                       YES
TEMP                           YES
USERS                          YES

장애 증상 :

- OLD ORACLE_HOME
/oracle/app/11.2.0.4

- NEW ORACLE_HOME
/u01/app/oracle/product/11.2.0.4/dbhome_2

신규설치가 원활하지 않아 11.2.0.4 기존 서버에서 ORACLE_HOME 을 통쨰로 tar 압축하여 신규 ORACLE_HOME 에 압축해제 후 relink all 작업함.

dbca 로 database 생성시 계속 이전 ORACLE_HOME 을 바라보고 있음..

[ORCL]oracle@upgrade:/home/oracle# dbca
java.lang.UnsatisfiedLinkError: Can't load library: /oracle/product/11.2.0.4/oui/lib/linux64/liboraInstaller.so
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1652)
        at java.lang.Runtime.load0(Runtime.java:769)
        at java.lang.System.load(System.java:968)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.loadNativeLib(OiipuUnixOps.java:384)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.<clinit>(OiipuUnixOps.java:126)
        at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.getEnv(OiipgEnvironment.java:201)
        at oracle.sysman.oii.oiip.oiipg.OiipgPropertyLoader.initUnixPtrFileLoc(OiipgPropertyLoader.java:212)
        at oracle.sysman.oii.oiip.oiipg.OiipgPropertyLoader.<clinit>(OiipgPropertyLoader.java:125)
        at oracle.sysman.oii.oiic.OiicStandardInventorySession.updateProperties(OiicStandardInventorySession.java:492)
        at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:266)
        at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:240)
        at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:189)
        at oracle.sysman.assistants.util.InventoryUtil.getOUIInvSession(InventoryUtil.java:346)
        at oracle.sysman.assistants.util.InventoryUtil.getOUILoc(InventoryUtil.java:122)
        at oracle.sysman.assistants.util.hasi.HAUtils.getOUILoc(HAUtils.java:2332)
        at oracle.sysman.assistants.util.hasi.HAUtils.<init>(HAUtils.java:240)
        at oracle.sysman.assistants.util.hasi.HAUtils.getInstance(HAUtils.java:281)
        at oracle.sysman.assistants.util.NetworkUtils.getAllListeners(NetworkUtils.java:349)
        at oracle.sysman.assistants.util.step.StepContext.<init>(StepContext.java:337)
        at oracle.sysman.assistants.dbca.backend.Host.<init>(Host.java:828)
        at oracle.sysman.assistants.dbca.ui.UIHost.<init>(UIHost.java:258)
        at oracle.sysman.assistants.dbca.ui.InteractiveHost.<init>(InteractiveHost.java:54)
        at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:173)
        at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:113)
        at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:189)

relink 효과없음.

genclntsh 효과없음

조치방법 :

오라클 HOME detach 후 다시 attach 함.

/u01/app/oracle/product/11.2.0.4/dbhome_2/oui/bin/runInstaller -silent -waitforcompletion -detachHome ORACLE_HOME='/u01/app/oracle/product/11.2.0.4/dbhome_2' -local \
-intPtrLoc /app/oracle/oraInventory/oraInst.loc

/usr/bin/perl clone.pl ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_2 ORACLE_HOME_NAME=OraDb11g_home1  OSDBA_GROUP=dba OSOPER_GROUP=dba

[ORCL]oracle@upgrade:/home/oracle# dbca   <-------- 에러없이 정상수행됨.