Oracle 8i

[Diggers12]

Hello,

where can I find the error logs, Oracle Server configuration information, the version of Oracle Server you are using and service packs, that is used, the information about operating system and so on

Thanks

[sambavan]

What is the OS name and DB versions ? Need more informations ...

Sam

[kris109]

On unix,

uname -a

gives you the version, release of the OS and hostname of the server.

For oracle, in sql*plus use the following to get the oracle version:

sql> show release
or
sql> select version from v$instance;

[sambavan]

To find the Oracle bit, on unix do

cd $ORACLE_HOME/bin

file oracle

Sam

[Diggers12]

What about on NT?

[Diggers12]

Oh and I am using Oracle 8i. I am trying to get similar information in Oracle that I can get with SQL servers SQLDiag.

Thanks

[kris109]

Select host_name, version from v$instance;

would work for NT. If you want more try this query:

SELECT
S.STATUS "Status",
S.SERIAL# "Serial #",
S.TYPE "Type",
S.USERNAME "DB User",
S.OSUSER "Client User",
S.SERVER "Server",
S.MACHINE "Machine",
S.TERMINAL "Terminal",
S.PROGRAM "Program",
P.PROGRAM "O.S. Program",
s.logon_time "Connect Time",
s.process "Process",
p.spid,
p.pid,
si.sid,
s.sql_address "Address",
s.sql_hash_value "Sql Hash"
FROM
V$SESSION S,
V$PROCESS P,
sys.V_$SESS_IO si
WHERE
S.paddr = P.addr and
si.sid(+)=s.sid
ORDER BY 5 DESC


[Edited by kris109 on 09-07-2001 at 11:03 AM]

[pst]

You can get oracle products info from

select * from product_component_version;

pst