4 Replies Latest reply: Oct 20, 2006 8:34 AM by 531427 RSS

    agentctl start 시 에러현상.

    536604
      oemapp console 전에 agentctl start 를 하는데 에러가 납니다.

      "
      Starting Oracle intelligent Agent.../opt/oracle/product/920/bin/dbsnmpwd: line 156:12684 세그멘테이션 오류 nohup $ORACLE_HOME/bin/dbmnmp $* >>$DBMNMP_WDLOGFILE 2>&1
      /opt/oracle/product/920/bin/dbsnmpwd: line 156:12697 세그멘테이션 오류 nohup $ORACLE_HOME/bin/dbmnmp $* >>$DBMNMP_WDLOGFILE 2>&1
      /opt/oracle/product/920/bin/dbsnmpwd: line 156:12709 세그멘테이션 오류 nohup $ORACLE_HOME/bin/dbmnmp $* >>$DBMNMP_WDLOGFILE 2>&1
      /opt/oracle/product/920/bin/dbsnmpwd: line 156:12721 세그멘테이션 오류 nohup $ORACLE_HOME/bin/dbmnmp $* >>$DBMNMP_WDLOGFILE 2>&1
      "

      이런 에러 메세지가 납니다.
      어떻게 해결해야할까요.
        • 1. Re: agentctl start 시 에러현상.
          531427
          정확한 OS version, OS word size(32bit,64bit),
          DB version, DB word size를 알려주세요.

          혹시 RH ES 3.0아닌가요? 리눅스면 패치가 필요합니다.

          There are various issues with the agent on Linux - this note tries to address these.

          3 main issues.

          1 - Bug 3119415
          Relinking can fail on versions 9.2.0.1.0 to 9.2.0.6.0, make.log shows -

          /opt/oracle/OraHome2/network/lib/libnmi.a(snmitcln.o)
          (.text+0xba): In function `get_msg_id':
          : undefined reference to `__ctype_b'
          /opt/oracle/OraHome2/network/lib/libnmi.a(snmitcln.o)
          (.text+0x823): In function `Nls_FormatCmd':
          : undefined reference to `__ctype_b'
          /opt/oracle/OraHome2/network/lib/libnmi.a(snmitcln.o)
          (.text+0x927): In function `Nls_FormatCmd':
          : undefined reference to `__ctype_b'
          /opt/oracle/OraHome2/network/lib/libnmi.a(snmitcln.o)
          (.text+0xa4e): In function `Nls_FormatCmd':
          : undefined reference to `__ctype_b'
          /opt/oracle/OraHome2/network/lib/libnmi.a(snmitcln.o)
          (.text+0x159d): In function `Nls_ScanCmd':
          : undefined reference to `__ctype_b'
          /opt/oracle/OraHome2/network/lib/libnmi.a(snmitcln.o)
          (.text+0x1603): more undefined references to
          `__ctype_b' follow
          collect2: ld returned 1 exit status
          make: *** [dbsnmp] Error 1
          Where opt/oracle/OraHome2 = $ORACLE_HOME
          This was fixed in one off patches up to 9.2.0.6.0 and patchset 9.2.0.7.0

          2 - Bug 3238244
          Starting the Intelligent Agent using -
          agentctl start
          generates the following dump -

          DBSNMP for Linux: Version 9.2.0.7.0 - Production on 10-OCT-2005 11:04:53
          Copyright (c) 2003 Oracle Corporation. All rights reserved.
          Starting Oracle Intelligent Agent.../home/oracle/9i_test/bin/dbsnmpwd: line 156: 9591 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >$DBSNMP_WDLOGFILE 2>&1

          /home/oracle/9i_test/bin/dbsnmpwd: line 156: 9604 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >$DBSNMP_WDLOGFILE 2>&1

          /home/oracle/9i_test/bin/dbsnmpwd: line 156: 9616 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >$DBSNMP_WDLOGFILE 2>&1

          /home/oracle/9i_test/bin/dbsnmpwd: line 156: 9628 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >$DBSNMP_WDLOGFILE 2>&1
          This problem was fixed by one off patch for 9.2.0.4 and in patchset 9.2.0.5.0 - however due to bug 4199559 was still a problem in patchset 9.2.0.6.0 and 9.2.0.7.0 ( if patch 3238244 or patchset 9.2.0.5.0 had not been applied before going to 9.2.0.6.0 or 9.2.0.7.0)

          3 - Bug 4199559
          Bug 3238244 was fixed in 9.2.0.4 (one off patch) and 9.2.0.5.0 patchset. However this bug was omitted from patchset 9.2.0.6.0 and 9.2.0.7.0.
          This bug reports this problem.

          CauseBug 3119415 was due to an incorrect ins_oemagent.mk file.

          Bug 3238244 was due to incorrect $ORACLE_HOME/lib/stubs files.

          Bug 4199559 was due to the stubs.jar being omitted from the 9.2.0.6.0 and 9.2.0.7.0 patchsets (however a one off patch is available for 9.2.0.7.0 - patch 4199559)

          글 수정:
          민천사 (민연홍)

          base install은 어떤 버젼에서 했고, 패치를 했다면 버젼이
          어떻게 되는지 알려주세요.
          예를들어.. RH ES3.0 32bit 9.2.0.4 32bit base install
          => 9.2.0.7 32bit patch 를 했다면.. 4199559 패치를 추가
          적용해야합니다.
          • 2. Re: 패치방법
            531427
            만약 9.2.0.4 -> 9.2.0.7 이고 RH ES 3.0이라면..
            아래와 같이 intellegent를 띄울려면 에러가 날겁니다.
            PROD@/u/ora9i/product/9.2.0/OPatch $agentctl start agent

            DBSNMP for Linux: Version 9.2.0.7.0 - Production on 20-OCT-2006 21:49:15

            Copyright (c) 2003 Oracle Corporation. All rights reserved.

            Starting Oracle Intelligent Agent.../u/ora9i/product/9.2.0/bin/dbsnmpwd: line 156: 2178 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
            /u/ora9i/product/9.2.0/bin/dbsnmpwd: line 156: 2190 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
            /u/ora9i/product/9.2.0/bin/dbsnmpwd: line 156: 2201 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
            /u/ora9i/product/9.2.0/bin/dbsnmpwd: line 156: 2212 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1


            p4199559_9207_LINUX.zip
            패치를 적용해야 합니다.

            적용하는 방법은 아래와 같습니다.

            p4199559_9207_LINUX.zip 을 $ORACLE_HOME 으로 가져가서
            unzip p4199559_9207_LINUX.zip 으로 압축을 풉니다.

            opatch를 통해 패치를 하기 전에..
            cd $ORACLE_HOME/4199559 으로 이동합니다.
            vi files/lib/stubs/libc.so
            을 열어서
            GROUP ( %ORACLE_HOME%/lib/stubs/libc.so.6 /usr/lib/libc_nonshared.a )

            GROUP ( /u01/oracle9i/lib/stubs/libc.so.6 /usr/lib/libc_nonshared.a )
            처럼 $ORACLE_HOME을 절대경로주소로 변경합니다.

            그리고 나서 4199599 디렉토리에서 opatch apply를 지정합니다.

            만약..

            The Oracle Home /u/ora9i/product/9.2.0 is not registered with the Central Inventory. OPatch was not able to get details of the home from the inventory.
            이라는 에러가 나온다면..
            /etc/oraInst.loc 파일에 oracle inventory가 부정확하게 지정되어 있기
            때문입니다. /etc/oraInst.loc파일을 열어서 inventory를 정확하게 지정해주어야
            합니다.

            이제 아래와같이 opatch apply를 수행해서 정상적으로 패치를 합니다.

            PROD@/u/ora9i/product/9.2.0/4199559 $opatch apply

            Oracle Interim Patch Installer version 1.0.0.0.52
            Copyright (c) 2005 Oracle Corporation. All Rights Reserved..

            We recommend you refer to the OPatch documentation under
            OPatch/docs for usage reference. We also recommend using
            the latest OPatch version. For the latest OPatch version
            and other support related issues, please refer to document
            293369.1 which is viewable from metalink.oracle.com

            Oracle Home = /u/ora9i/product/9.2.0
            Location of Oracle Universal Installer components = /u/ora9i/product/9.2.0/oui
            Location of OraInstaller.jar = "/u/ora9i/product/9.2.0/oui/jlib"
            Oracle Universal Installer shared library = /u/ora9i/product/9.2.0/oui/lib/linux/liboraInstaller.so
            Location of Oracle Inventory Pointer = /etc/oraInst.loc
            Location of Oracle Inventory = /u/ora9i/product/9.2.0/inventory
            Path to Java = /u/ora9i/product/9.2.0/jre/1.4.2/bin/java
            Log file = /u/ora9i/product/9.2.0/.patch_storage/<patch ID>/*.log

            Creating log file "/u/ora9i/product/9.2.0/.patch_storage/4199559/Apply_4199559_10-20-2006_21-58-46.log"

            Invoking fuser to check for active processes.

            Backing up comps.xml ...

            OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


            Please shut down Oracle instances running out of this ORACLE_HOME
            (Oracle Home = /u/ora9i/product/9.2.0)
            Is this system ready for updating?
            Please respond Y|N >
            Y
            Patching...

            Updating inventory...
            Backing up comps.xml ...


            OPatch succeeded.


            이제
            $ORACLE_HOME/bin 에가서
            chmod 4755 dbsnmp
            로 권한을 변경하고
            root유저로 owner를 줍니다.
            chown root:root dbsnmp

            패치후에 아래와 같이 정상적으로 intellegent agent가 뜨는 것을
            확인하였습니다.

            PROD@/u/ora9i/product/9.2.0/bin $agentctl start agent

            DBSNMP for Linux: Version 9.2.0.7.0 - Production on 20-OCT-2006 22:07:25

            Copyright (c) 2003 Oracle Corporation. All rights reserved.

            Starting Oracle Intelligent Agent....
            Agent started
            PROD@/u/ora9i/product/9.2.0/bin $

            글 수정:
            민천사 (민연홍)
            opatch가 설치되어 있지 않다면..
            p2617419_10102_GENERIC.zip 을 메타링크에서 다운받아서
            $ORACLE_HOME에 풉니다. 그러면 $ORACLE_HOME/OPatch 라는
            디렉토리가 생길겁니다.
            export PATH=$ORACLE_HOME/OPatch:$PATH
            를 해서 OPatch 디렉토리를 지정해줍니다.
            그리고 perl도 설치되어 있어야 합니다.
            리눅스용 perl은
            http://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=2417872
            에서 다운받아 설치할 수 있습니다.
            설치방법은 $ORACLE_HOME에 압축풀고 sh install_perl.sh 를 수행하기만
            하면 됩니다.
            • 3. Re: 패치방법
              536604
              RH ES 3.0 이고 9.2.0.4 버젼입니다.
              그리고 자세한 설명 감사합니다. ^^

              글 수정:
              chapter10
              • 4. Re: 패치방법
                531427
                9.2.0.4 라면 아래처럼 하면 됩니다.
                그리고 perl과 OPATCH를 설치하기 귀찮다면..
                오라클 설치시에 HTTP서버에서 모두 선택하면 둘다 설치됩니다.
                단, 자동으로 http서버가 올라오니
                설치후에 $ORACLE_HOME/Apache/Apache/bin에 가서
                apachectl stop 을 해서 http서버 내리면 대요.

                Fix
                Scenario I:

                1. Installed 9204, agent segmentation fault dbsnmp

                2. Applied 9206 patchset, relinked agent, segmentation fault dbsnmp


                Scenario II:

                1. New install of 9204, applied patch for bug3238244, relinked agent, all is fine.

                2. Applied 9205 patchset, relinked agent, all is well

                3. Applied 9206 patchset, relinked agent, all is well


                Scenario III:

                1. 3rd new build of 9204, agent segmentation fault dbsnmp ( no additional patches applied )

                2. Applied 9205 patchset, relinked agent, agent works fine ( no additional patches )

                3. Applied 9206 patchset, relinked agent, agent works fine ( no additional patches )


                Do a clean install of the 9.2.0.4 agent from media. Then follow either Scenario 2 or 3. This should resolve the issue.

                글 수정:
                민천사 (민연홍)