Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

install oracle8.1.7 error on hpux11.00

hongjing_zhang
Trusted Contributor

install oracle8.1.7 error on hpux11.00

$ 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
9 REPLIES
Steven E. Protter
Exalted Contributor

Re: install oracle8.1.7 error on hpux11.00

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
hongjing_zhang
Trusted Contributor

Re: install oracle8.1.7 error on hpux11.00

$ 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
Honored Contributor

Re: install oracle8.1.7 error on hpux11.00

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
Trusted Contributor

Re: install oracle8.1.7 error on hpux11.00

directory and file permission is 755 and owner is oracle:dba
it's right
T G Manikandan
Honored Contributor

Re: install oracle8.1.7 error on hpux11.00

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
Honored Contributor

Re: install oracle8.1.7 error on hpux11.00

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




Never give up, Keep Trying

Re: install oracle8.1.7 error on hpux11.00

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

Re: install oracle8.1.7 error on hpux11.00

oops....internal only works if logged in as 'oracle' owner
bob hollis
Frequent Advisor

Re: install oracle8.1.7 error on hpux11.00

"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