cancel
Showing results for 
Search instead for 
Did you mean: 

Two questions.

SOLVED
Go to solution
brian_31
Super Advisor

Two questions.

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.
6 REPLIES
Michael Schulte zur Sur
Honored Contributor

Re: Two questions.

Hi,

connect
select * from v$instance;

btw, what's EOSL?

greetings,

Michael
brian_31
Super Advisor

Re: Two questions.

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

Re: Two questions.

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
Super Advisor

Re: Two questions.

we run 64 bit

Thanks

Brian.
Michael Schulte zur Sur
Honored Contributor
Solution

Re: Two questions.

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

Re: Two questions.

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
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.