topic Re: install oracle8.1.7 error on hpux11.00 in Operating System - HP-UX

install oracle8.1.7 error on hpux11.00

hongjing_zhang — Tue, 09 Sep 2003 02:50:37 GMT

$ 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

Re: install oracle8.1.7 error on hpux11.00

Steven E. Protter — Tue, 09 Sep 2003 02:59:27 GMT

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

Re: install oracle8.1.7 error on hpux11.00

hongjing_zhang — Tue, 09 Sep 2003 03:05:45 GMT

$ 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

Re: install oracle8.1.7 error on hpux11.00

Con O'Kelly — Tue, 09 Sep 2003 03:16:47 GMT

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

Re: install oracle8.1.7 error on hpux11.00

hongjing_zhang — Tue, 09 Sep 2003 03:25:42 GMT

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

Re: install oracle8.1.7 error on hpux11.00

T G Manikandan — Tue, 09 Sep 2003 03:52:08 GMT

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

Re: install oracle8.1.7 error on hpux11.00

Indira Aramandla — Tue, 09 Sep 2003 08:29:44 GMT

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

Re: install oracle8.1.7 error on hpux11.00

Sandro Schaer_1 — Tue, 09 Sep 2003 09:24:07 GMT

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

Re: install oracle8.1.7 error on hpux11.00

Sandro Schaer_1 — Tue, 09 Sep 2003 09:30:59 GMT

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

Re: install oracle8.1.7 error on hpux11.00

bob hollis — Tue, 09 Sep 2003 14:35:44 GMT

"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