'oracle' 태그의 글 목록

2011. 11. 25. 21:08

Resolving Linking errors in installing Oracle 10g R2 on OEL 5 (x86_64)

Open the $ORACLE_BASE/oraInventory/logs/install_<timestamp>.log file to have a look at the specific error message.

Usually almost linking errors are arisen from any missing RPM packages. Very frequently I got the following error on the installation:

INFO: mv -f /oracle/app/product/10.2.0/db_1/bin/ctxlc /oracle/app/product/10.2.0/db_1/bin/ctxlcO

INFO: mv ctxlc /oracle/app/product/10.2.0/db_1/bin/ctxlc

INFO: chmod 751 /oracle/app/product/10.2.0/db_1/bin/ctxlc

INFO: gcc -m32 -o ctxhx -L/oracle/app/product/10.2.0/db_1/ctx//lib32/ -L/oracle/app/product/10.2.0/db_1/lib32/ -L/oracle/app/product/10.2.0/db_1/lib32/stubs/ /oracle/app/product/10.2.0/db_1/ctx/lib/ctxhx.o -L/oracle/app/product/10.2.0/db_1/ctx/lib/ -ldl -lm -lctxhx -Wl,-rpath,/oracle/app/product/10.2.0/db_1/ctx/lib -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /oracle/app/product/10.2.0/db_1/lib/sysliblist`

INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory

INFO: collect2: ld returned 1 exit status

INFO: make: *** [ctxhx] Error 1

INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'install' of makefile '/oracle/app/product/10.2.0/db_1/ctx/lib/ins_ctx.mk'. See '/oracle/app/oraInventory/logs/installActions2010-11-23_12-04-56PM.log' for details.
Exception Severity: 1

This error is shown up to us because the linking compiler can not find the required package: libXp for i386. Just install the package and click to retry to link.

For the full list of package requirement of installing of Oracle 10g R2 (x86_64), refer to the following website:

libstdc++-devel (x86_64)
libstdc++-devel (i386)
sysstat (x86_64)
glibc-devel (x86_64)
glibc-devel (i386)
libaio-devel (x86_64)
libaio-devel (i386)
gcc (x86_64)
gcc-c++ (x86_64)
elfutils-libelf-devel-static (x86_64)
elfutils-libelf-devel-static (i386)
unixODBC-devel (x86_64)
unixODBC-devel (i386)
compat-db (x86_64)
compat-gcc-34 (x86_64)
compat-gcc-34 (i386)
compat-libstdc++-34 (x86_64)
compat-libstdc++-34 (i386)
libXp (i386)

The second error to mention is due to the incompatibility to GLIBC's version. It looks like the followings:

INFO: make[1]: *** [/oracle/app/product/10.2.0/db_1/sysman/lib/e2eme] Error 1

INFO: make[1]: Leaving directory `/oracle/app/product/10.2.0/db_1/sysman/lib'

INFO: make: *** [e2eme] Error 2

INFO: End output from spawned process.

INFO: ----------------------------------

INFO: Exception thrown from action: make

Exception Name: MakefileException

Exception String: Error in invoking target 'agent nmo nmb' of makefile '/oracle/app/product/10.2.0/db_1/sysman/lib/ins_sysman.mk'. See '/oracle/app/oraInventory/logs/installActions2010-11-23_12-04-56PM.log' for details.

Exception Severity: 1

For this, just open the <Installation Package Dir>/install/oraparam.ini file with text editor. And then, find the line including [Linux-redhat-4.0-required] and replace the value of KERNEL with the one which is available by running the following command: uname -a

And, of course, change the content of the /etc/redhat-release file to redhat-4.

And. everything will be OK.

Any question? Let me know.

Posted by 겨울이 오나보다

2011. 11. 9. 15:18

카테고리 없음

DATAGUARD에서 SWITCHOVER_STATUS가 계속 ACTIVE SESSIONS로 나타날 때~~

DATAGUARD에서 FAILOVER를 할 때 미리 V$DATABASE의 SWITCHOVER_STATUS를 확인하여 TO_STANDBY로 표시될 때만 FAILOVER 기능을 사용하여 PRIMARY/STANDBY DB의 역할 변경이 가능하게 된다.

하지만 간혹 SWITCHOVER_STATUS이 계속해서 ACTIVE SESSIONS으로 나타나는 경우가 발생하는데 이런 경우는 다음과 같이 찾아보도록 하자.

SQL> SELECT SID, PROCESS, PROGRAM FROM V$SESSION
2 WHERE TYPE = ‘USER’ AND SID != (SELECT DISTINCT SID FROM V$MYSTAT);

위의 결과에서 나타나는 결과에서 PROCESS 컬럼의 값에 따라서 해결책을 찾을 수 있다.

PROCESS	설 명	해결방법
CJQ0 또는 Jnnn	Job Queue Scheduler Process or its Slaves	ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
QMN0	Advanced Queue Time Manager	ALTER SYSTEM SET AQ_TM_PROCESSES=0;
DBSNMP	ORACLE EM Management Agent	Stop the EM agent by invoking the following command: emctl stop agent