HP 11.0 Oracle 8.0.5 fresh install connect internal need password

[jacky400]

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

It has been 6751 already .

[Sanjay Kumar Suri]

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

[jacky400]

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]

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

[Sanjay Kumar Suri]

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

[Narasimha S Brahmanapal]

Greetings,

Please make sure that there are sharedmemeory and ipc entries from the previous oracle shutdown.

try the following unix commands as oracle s/w owner:

ipcs

if you think that the DB is down, then yoiu should not see any sharedmemory or ipc entries owned by oracle s/w owner.
If you see them, the delete using

ipcrm command.

HTH
BN

[Yogeeraj_1]

hi,

why don't you consider upgrading to 8.1.7.4?

this version is stable enough and lot of bug fixes compared to the base release 8.0.5.

Note that the Terminal releases are as follows:
8.1.7 for Oracle8i.
8.0.6 for Oracle8.

HP-UX11.0 with 8.0.5 Oracle Database has already been Desupported. Thus, not sure you can get the patches for this version.

hope this helps too!
regards
Yogeeraj

[R. Allan Hicks]

yogeeraj is right. 8.0.5 was a very buggy version.

BTW the default password for sys in the 8i days was change_on_install and for system it was manager.


Good Luck

[jacky400]

Actually my 8.0.5 has a serious problem,
if i haven't added the sqlnet.authentication_services=(nts) to sqlnet.ora ,then when start the svrmgrl ,it will say ORA-03113,i really found it is very strange .

Can anyone tell me how i can solve this ?

[Indira Aramandla]

Hi Jacky,

"SQLNET.AUTHENTICATION_SERVICES" (in SQLNET.ORA)this authenticates the user at the OS level. By default, the SQLNET.AUTHENTICATION_SERVICES parameter has been set to enable the Windows NT native authentication service (NTS). Commenting out this parameter will cause it to take the default value of NONE. Explicitly setting this parameter to '(NONE)' will have the same effect. If you have SQLNET.AUTHENTICATION_SERVICES=(NTS) set in your sqlnet.ora you're basically asking Oracle to authenticate you with the domain server when you log on to oracle.

When you installed and configured a Net8 client and cannot connect to the server. The connection may hang and return an ORA-3113 error. A sqlnet.log or trace file includes a 12547 error and a 12699 error. It is (often) accompanied by an TNS-12631 in SQLNET.LOG.

I have a query, you say the the database is called orcl. But in your initorcl.ora you have db_name=orcl_db

From the above error messages, Oracle 8.0.5 has few issues. I agree with Yogeeraj, Oracle 8i version 8.1.7.4 is a stable environwmnt.
And if this is your Dev / test server and you do not have other instances being used on this server, and if the databases are shutdown then as Narasimha mentioned, use ipcrm to remove semaphore set, or shared memory or ipc entries owned by oracle if any.

Now coming to the error you experience when you do startup

When you get ORA-03113: end-of-file on communication channel, when startup mount

Check the attributes of oracle user and permissions to $ORACLE_HOME

user id : uid=103(oracle) gid=100(dba)
permission of oracle binary: ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle dba 37898336 Jun 16 19:57 oracle

The other place to check is

System setup(/etc/system):

set semsys:seminfo_semmns------ If this is too low say 100 then set this to 500+ and is it it works.

Best wishes
Indira A

[T G Manikandan]

03113 errors rise because your do not have the semaphores and shared memory parameters tuned.

What values you have for shmmax,semmnu,semmni

Revert back

[jacky400]

I have one question to ask ,

Since my HPUX is a K420 ,32 bit and i download oracle 8.1.7 64 bit and installed
(of course not work)

is there any oracle 8.1.7 32-bit version i can download ?

[Eric Antunes]

Yes there is a version for 32 bits: that's my version!

[Eric Antunes]

I don't know if you can download it or if you must order the cd...

[jacky400]

Antunes ,

Could u mind make a iso for the oracle 8.1.7 32 bit for me ? i just for development use only and will not in production .

[jacky400]

T G Manikandan,

shmmax=1gb
semmnu=30
semmni=1000

Revert back