install oracle8.1.7 error on hpux11.00

[hongjing_zhang]

$ sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Sep 9 11:19:21 2003

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

SQL> connect / as sysdba
sh: /ccdata/u01/app/oracle/product/8i/bin/oracle: Execute permission denied.
ERROR:
ORA-12547: TNS:lost contact



$ll
-rwsr-s--x oracle dba oracle

[Steven E. Protter]

ll /ccdata/u01/app/oracle/product/8i/bin/oracle

then

id

You will see a conflict between the user id you are logged on as and the ownership of that binary.

If you are logged in as root.

STOP!

Do not ever, ever do anything with an oracle database as root.

Try again as the user that owns the database binaries. Most shops use the user oracle.

SEP

[hongjing_zhang]

$ id
uid=102(oracle) gid=102(dba) groups=20(users)
$ ll bin/oracle
-rwsr-s--x 1 oracle dba 36212736 Sep 9 11:11 bin/oracle
$ sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Sep 9 12:04:19 2003

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

SQL> connect / as sysdba
sh: /ccdata/u01/app/oracle/product/8i/bin/oracle: Execute permission denied.
ERROR:
ORA-12547: TNS:lost contact

[Con O'Kelly]

Hi

Check further up the directory tree.
Your permissions on oracle are OK but possibly some of the directories above need to have correct permissions/owners set. For example the oracle, product, bin & 8i directories should have 755 perms & be owned by oracle with group of dba.

Cheers
Con

[hongjing_zhang]

directory and file permission is 755 and owner is oracle:dba
it's right

[T G Manikandan]

you have missed some pre-requisite patches before installation.

Load this patch from hp

http://www2.itrc.hp.com/service/patch/patchDetail.do?patchid=PHSS_28434&context=hpux:800:11:00

Then re-link oracle

check the attache

[Indira Aramandla]

Hi,

Install HP-UX linker tools cumulative patch PHSS_22514 or later (HP patch PHSS_22478).

After you install this patch, all of the Oracle executables need to be relinked:

Do the following to relink :-
For Oracle8i:

1) Change to the "bin" directory:

% cd $ORACLE_HOME/bin

2) Use the "relink" utility with the "all" argument:

% relink all

3) Use the "relink" utility with the "utilities" argument:

% relink utilities

4) Change to the "sqlplus/lib" directory:

% cd $ORACLE_HOME/sqlplus/lib

5) Use the "make" command to relink "sqlplus":

% make -f ins_sqlplus.mk install


This should fix the error.

IA

[Sandro Schaer_1]

btw, why don't you just use 'connect internal' ?

[Sandro Schaer_1]

oops....internal only works if logged in as 'oracle' owner

[bob hollis]

"connect internal" is going away after 8i

the new (correct) login is now
connect / as sysdba

It's a good idea to start using it so it won't become a big shock when you go to 9