PL/SQL won't install on DEC Alpha

PL/SQL won't install on DEC Alpha

Post by Phillip Mon » Sun, 31 Dec 1899 09:00:00



I've just finished an install of 7.3.4 on an old Digital AlphaStation 200
running Compaq Tru64 Unix 5.0. When I ran catalog.sql everything went fine,
but catproc.sql produced heaps of errors. I've traced this back to the fact
that PL/SQL v2.3.4.0.0 doesn't seem to be installed, even though I selected
it in orainst and didn't see any errors about it.

When I run sqlplus I get this output:

sqlplus phil/********

SQL*Plus: Release 3.3.4.0.0 - Production on Tue May 30 19:10:45 2000

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.

ERROR:
ORA-00900: invalid SQL statement

Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-00900: invalid SQL statement

Connected to:
Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Production

SQL>

This output makes sense given that PL/SQL isn't installed. Is there anything
in any of the logfiles produced in $ORACLE_HOME/orainst that would give a
clue as to why PL/SQL isn't there?

TIA,

Phil Monk
Synaxis Pty Ltd
Ph: +618 8235 6368
level 3, 97 Pirie St
Adelaide SA 5000
Australia

 
 
 

1. Dec Alpha OSF V7.3.2 Install of SQL*NET V2

Hi chaps,
on installing V7.3.2 for Dec Alpha UNIX 4.0B
I find that the Listener for IPC connections will
not start up. (Connections from TCP/IP are fine).

I get the following errors

 TNS-12546  TNS permission denied
   TNS -12560 : TNS : protocol adapter error
      TNS- 00516 : permission denied
         DEC OSF/1  AXP Error 13 : permission denied

It looks like I have a permissions problem on
some operating system file or catalogue. Or
the o/s was not fully installed.

My listener.ora file is a copy of a well tried and
tested version from another system as is the tnsnames.ora file.

I have checked /tmp/.oracle and /var/tmp but all looks fine.

Any clues as to where i should be looking?

thanks

2. 6.5 - 7 upgrade on dual alpha

3. Oracle 8i on DEC Alpha Win NT

4. Number of rows selected

5. Ingres on Win NT / DEC Alpha - any experiences?

6. NG Humour

7. HELP: Install Oracle 7.1 Workgroup Server on DEC Alpha Window NT 4.0

8. Multiple Progress developer openings IA

9. DEC Alpha 8400, DEC OSF/1 V3.2B and Ingres

10. [HACKERS] Re: Tuple-valued datums on Alpha (was Re: 7.1 on DEC/Alpha)

11. Tuple-valued datums on Alpha (was Re: 7.1 on DEC/Alpha)

12. Rebuilding Indexes ORACLE 7.3.2.3.2 DEC Alpha VMS 7.1 (Don't laugh)

13. DEC's Rdb announces 302.68 tpsA at $6643/tpsA on ALPHA