Operating System - HP-UX
1748116 Members
3374 Online
108758 Solutions
New Discussion юеВ

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

 
SOLVED
Go to solution
Sanjay Kumar Suri
Honored Contributor

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Make another attempt with

connect sys/oracle as sysdba

startup;

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
jacky400
Advisor

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Now i can connect internal using password=oracle

but when i startup nomount
it always ORA-03113 end-of-line communication

The trace is as below,

Dump file /u01/app/oracle/admin/orcl/udump/ora_2108.trc
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.0.0 - Production
ORACLE_HOME = /u01/app/oracle/product/8.0.5
System name: HP-UX
Node name: osstest
Release: B.11.00
Version: U
Machine: 9000/869
Instance name: orcl
Redo thread mounted by this instance: 0
Oracle process number: 0
Unix process pid: 2108, image: oracleorcl

Exception signal: 10, code = 7f7e4040
sc_onstack: 00000000c0049a03, sc_mask 0000000000000480
pcsqh: 0x00000000 pcoqh: 0x000004b4 pcsqt: 0x00000000 pcoqt: 0x00007a5d
isr: 0x00000000 ior: 0x00000000
sc_flags: 0x4005324c sc_sp: 0x00000002 sc_ret1: 0x000004b4 sc_ret0: 0x0ec41093
sc_arg0: 0x00000000 sc_arg1: 0xc0049a07 sc_arg2: 0x00000000 sc_arg3: 0xc0049a03
sc_dp: 0xffffffff sc_rp: 0x00000002 sc_sar: 0x00000003 sc_ipsw: 0x000c3154 sc_psw: 0x000c3154
sc_gr1: 0x4005817a sc_gr2: 0x00000002 sc_gr3: 0x00000000 sc_gr4: 0x0000025b
sc_gr5: 0x00000444 sc_gr6: 0x0000017a sc_gr7: 0x0000014c sc_gr8: 0x00000000
sc_gr9: 0x7f7aa6f0 sc_gr10: 0x00000000 sc_gr11: 0x7f7e38c0 sc_gr12: 0x00000000
sc_gr13: 0x7f7b9be8 sc_gr14: 0x40068ac0 sc_gr15: 0x7f7a0182 sc_gr16: 0x7f7b9be8
sc_gr17: 0x40060188 sc_gr18: 0x00000000 sc_gr19: 0x000000b8 sc_gr20: 0x7f7e3b40
sc_gr21: 0xc011cbdb sc_gr22: 0x00000008 sc_gr27: 0xffffffff sc_gr28: 0x0ec41093
sc_gr29: 0x000004b4 sc_gr30: 0x00000002 sc_gr31: 0x0006fd1f sc_sr4: 0x000c0000
ORA-07445: exception encountered: core dump [10] [2138980416] [3221527043] [1152] [] []





===================================================
PROCESS STATE
-------------
Process global information:
process: 0, call: 0, xact: 0, curses: 0, usrses: 0
No process is allocated.
END OF PROCESS STATE
******************** Cursor Dump ************************
No curdef array
ssexhd: crashing the process...
Shadow_Core_Dump = full
Sanjay Kumar Suri
Honored Contributor

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Can you also look into the trace file created in background_dump_dest for PMON/SMON etc?

What is the shared_pool_size defined in init.ora file?

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
jacky400
Advisor

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

There is no pmon and smon trace file under the directory of bdump

The following is my initorcl.ora

db_name=orcl_db
db_files=100
db_block_buffers=3200
shared_pool_size=20000000
sort_area_size=20000000
log_checkpoint_interval=10000
processes=10
compatible=8.0.5
remote_login_passwordfile=exclusive
job_queue_processes=10
job_queue_interval=60
max_dump_file_size=10240
user_dump_dest=/u02/admin/udump/
background_dump_dest=/u02/admin/bdump/
core_dump_dest=/u02/admin/cdump
control_files=("/u02/orcl/control01.ctl","/u02/orcl/control02.ctl")

log_archive_start=true
log_archive_dest=/u02/orcl/arch
log_archive_format=arch_%s

Alexander M. Ermes
Honored Contributor

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Hi Jacky.
Did you check the attributes of your oracle executable ?

Make sure, that user oracle is the owner
and the attributes set to 6751 ( with the sticky bit ).
Rgds
Alexander M. Ermes

.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
jacky400
Advisor

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

oracle@osstest%ll oracle
-rwsr-s--x 1 oracle dba 21721284 Jun 17 13:53 oracle

It has been 6751 already .
Sanjay Kumar Suri
Honored Contributor

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Some more inputs:

Check if there is a need to apply patchset 8.0.5.1, 8.0.5.2 for 8.0.5 (HP_UX 11.0 - 32 bit)?

sks





A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
jacky400
Advisor

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

I am a newbie,if i want to patch it to 8.0.5.1
where can i download the patch ?
Thx a lot
Sanjay Kumar Suri
Honored Contributor

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Also look at following inputs:

Suggestion-I

An ora-7445 can have different causes. The error message only means that
a core dump has occurred during the execution of the action. This
usually means that the shadow process on the Oracle side has terminated
with a core dump. To identify the cause of the error, you must first
conduct a closer examination. The error can essentially have the
following causes:

Incorrectly set NLS environment variables

Corrupt blocks on the Oracle level

A bug in the Oracle software

Check the following environment variables for differences between
the ora and adm users:

ORA_NLS

ORA_NLS32

ORA_NLS33

NLS_LANG

NLS*: essentially no NLS environment variables other than the four
described above should be set.

Differences can exist in the path for ORA_NLS33. Essentially the NLS
environment variables are compatible for all Oracle 8.X releases.
If, for example, ORA_NLS33 is in ..ocommon/nls/admin/data for
ora and in ..ocommon/NLS_805/admin/data for adm. Make sure
that the directories exist and the files are located in the
directories to which the environment variables point.

Suggestion-II

On HP-UX 11.0, the function call gethostbyname() which is executed by
Oracle is not processed correctly. This causes the PMON process to
crash.
The error only occurs if the following parameters are set in the
protocol.ora:
tcp.invited_nodes
tcp.validnode_checking

Solution: change the tcp.invited_nodes parameter in such a way that, instead of
the host names, the IP addresses are entered for the relevant host
names.
sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Sanjay Kumar Suri
Honored Contributor

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Could not locate this patches from Oracle site. It seems Oracle is not supporing this version.

Check the following links as well.

http://forums1.itrc.hp.com/service/forums/bizsupport/questionanswer.do?threadId=230669
http://forums1.itrc.hp.com/service/forums/bizsupport/questionanswer.do?threadId=220790

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.