Two questions.

[brian_31]

How do i find out what is the version of oracle i run? Also do anyone know what is the EOSL on 8.1.7.4?

Thanks

Brian.

[Michael Schulte zur Sur]

Hi,

connect
select * from v$instance;

btw, what's EOSL?

greetings,

Michael

[brian_31]

Hi Mike:

Is there a way i can find the exact version of oracle as root?

EOSL - End of Service Life

Thanks

Brian

[Michael Schulte zur Sur]

Hi,

you could have a look into the alertlog. It should be printed during startup.
What hardware/os 32/64 bit version do you have?

greetings,

Michael

[brian_31]

we run 64 bit

Thanks

Brian.

[Michael Schulte zur Sur · Accepted solution]

Hi,

this you can find in metalink:
Desupport End Dates:
Error Correction Support (ECS): 31-DEC-2004
Extended Support (ES): 31-DEC-2007
Extended Maintenance Support (EMS): 31-DEC-2006

hth,

Michael

[Geoff Wild]

As root, you should be able to run tnsping:

tnsping

TNS Ping Utility for HPUX: Version 9.2.0.4.0 - Production on 31-MAR-2004 15:53:53

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

From above - looks like oracle 9.2...

Rgds...Geoff