| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i install gives 817 in v$version
Hemant, thanks for your reply.
TWO_TASK is undefined, here's the query output you mentioned.
There is only one Oracle installation on the server as it was a fresh
OS and Oracle install.
I'll try to find the cds and take another look.
Perhaps the 9i app server comes with the 8i database, which would
explain my confusion.
SQL> select * from v$database;
DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
---------- --------- --------- ----------------- --------- PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
----------------------- --------- ------------ ------------------
--------------- ------- --------- ---------------------
-------------------
2621343412 EME1 22-OCT-01 1 22-OCT-01
0 NOARCHIVELOG 61189729
61189462 CURRENT 22-OCT-01 975035
61189790
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
----------------- --------- ------- --- ---------- ------- -----------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE
---------- --- ----------------- ------------------
1 eme1
oracle-dev
8.1.7.0.0 31-JAN-02 OPEN NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE
"Hemant K Chitale" <hkchital_nospam_at_singnet_nospam.com.sg> wrote in message news:<a8s8ra$h7m$1_at_violet.singnet.com.sg>...
> Your ORACLE_HOME listing is of a > 9iAS installation --- not the database > but the Application Server. > 9iAS 1.0.2.x is on 5 CDs. Don't you > have the CDs with you now to check them ? > Also, check to see if you have TWO_TASK > defined in your environment and you are > really connecting to a database running > from a different ORACLE_HOME. > If you connect as SYSTEM, query V$INSTANCE > and V$DATABASE to get the Instance Name, > Database Server Name and Database Name. > > [9iAS also includes an RDBMS engine > as the Database Cache but it is not > supposed to be used as a Database itself]. > Hemant K Chitale > > "Chris" <nospam_at_chrismccarthysoftware.com> wrote in message > news:7d812462.0204080608.3102a61_at_posting.google.com... > > A few months ago I installed Solaris on a new sunfire sparc server. > > > > SunOS oracle-dev 5.8 Generic_108528-07 sun4u sparc SUNW,Sun-Fire-280R > > > > Next, I installed Oracle 9i, it said 9i on the install discs, and I > > seem to remember there was 5 cds. > > > > However, I recently noticed that it does not report the version as > > being 9i: > > > > Connected to: > > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production > > With the Partitioning option > > JServer Release 8.1.7.0.0 - Production > > > > SQL> select * from v$version; > > > > BANNER > > ---------------------------------------------------------------- > > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production > > PL/SQL Release 8.1.7.0.0 - Production > > CORE 8.1.7.0.0 Production > > TNS for Solaris: Version 8.1.7.0.0 - Production > > NLSRTL Version 3.4.1.0.0 - Production > > > > We don't even have 8.1.7 install cds. What's going on ? > > > > This is an 'ls' of our $ORACLE_HOME > > > > 6iserver dbs jis oem_webstage > > precomp starterdb > > 8ienv.csh doc jlib oracore > > rdbms svrmgr > > 8ienv.sh hs JRE oradata > > relnotes sysman > > admin icache jsp oradata2 > > resp webcache > > Apache ifs1.1 ldap ord > > root.sh wwg > > assistants install lib otrace > > root.sh.old xdk > > bin install.platform md owm > > sap > > classes jar network panama > > slax > > converters javavm ocommon plsql > > sqlj > > ctx jdbc odg portal30 > > sqlplus > > > > Any help much appreciated. > > > > Regards, > > ..Chris.Received on Tue Apr 16 2002 - 02:50:32 CDT
 |
 |