Operating System - HP-UX
1827684 Members
3536 Online
109967 Solutions
New Discussion

Core Dump when accessing sqlplus!!

 
Ettienne Mong
New Member

Core Dump when accessing sqlplus!!

Hi, we ahve just upgraded from oracle 734 to oracle 8. When I access sqlplus it returns with a core dump. my OS version 11.00 32/bit. We are running baan 4c if this is any help. What is the reason for this core dump and how do I fix this.

Please could you give some tips here.

THX
Ettienne
Never erver say DIE
3 REPLIES 3
John Palmer
Honored Contributor

Re: Core Dump when accessing sqlplus!!

Hi Ettienne,

There are several possibilities, among them are:-

1. Are you using RADIUS authentication?
2. Have you got the correct ORACLE_HOME/bin first in PATH and ORACLE_HOME set correctly?
3. Does SHLIB_PATH include $ORACLE_HOME/lib ?

Let me know if any of the above apply. If not, some more information would be useful.

Regards
John
Kofi ARTHIABAH
Honored Contributor

Re: Core Dump when accessing sqlplus!!

Hi:


You may have to relink the oracle binaries after the upgrade to get rid of that problem:


1. # su - oracle
2. $ dbshut
3. $ cd ${ORACLE_HOME}/bin
4. $ mkdir orig
5. $ mv oracle svrmgrl sqlplus orig
6. $ cd ${ORACLE_HOME}/svrmgr/lib
7. $ make -f ins_svrmgr.mk svrmgrl
8. $ mv svrmgrl ../../bin
9. $ cd ${ORACLE_HOME}/rdbms/lib
10. $ make -f ins_rdbms.mk oracle
11. $ chmod 6755 oracle
12. $ mv oracle ../../bin
13. $ cd ${ORACLE_HOME}/sqlplus/lib
14. $ make -f ins_sqlplus.mk sqlplus
15. $ mv sqlplus ../../bin
16. Ensure that the new binaries have the correct permissions
by comparing them with the ones saved in
${ORACLE_HOME}/bin/orig

For example, the oracle binary needs these permissions:

$ ll bin/oracle
-rwsr-s--x 1 oracle dba 7503872 Mar 15 11:33 bin/oracle

17. $ dbstart


Additionally, make sure that you have the /etc/nsswitch.conf set up properly eg:
hosts: files [NOTFOUND=continue] dns

Also if you do a search for "core dump" AND oracle in the forums for other links.

good luck
nothing wrong with me that a few lines of code cannot fix!
Alex Glennie
Honored Contributor

Re: Core Dump when accessing sqlplus!!

Try getting some more info on what caused the core : eg try running a

file core & what core :
get latest patches installed, check what "cored" log files etc, rc.log syslog.log etc for clues ?