Re: Get Oracle 9i2 to run again after WinXP reinstallation ... ?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 29 Jun 2007 21:54:12 +0200
Message-ID: <f63o0t$k5r$2@news3.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Martin T. wrote:
> On Jun 27, 11:34 pm, "Martin T." <bilbothebagginsb..._at_freenet.de>
> wrote:

>> On Jun 27, 8:21 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
>> wrote:
>>
>>
>>
>>> Martin T. wrote:
>>>> Greetings.
>>>> [Oracle 9i2 9.0.1.3.0, Windows XPsp2]
>> (....)
>>
>>> - - 9iR2 starts with 9.2.0.1.0 - you have release 1!
>> Hmmm ... I thought that version string looked fishy ... I need to
>> double check (copied it from the sqlplus /nolog prompt, so maybe it
>> was some client side thing) ... thanks for pointing it out.
>>

>
> Yep. Stupid Application Server Home ...
>
> ----------------
> Microsoft Windows XP [Version 5.1.2600]
> (C) Copyright 1985-2001 Microsoft Corp.
> C:\Documents and Settings\Administrator>cd \Oracle\OraHome92\bin
> C:\Oracle\OraHome92\bin>.\sqlplus.exe
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jun 28 12:14:13 2007
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter user-name:
> C:\Oracle\OraHome92\bin>cd ..\..\OraHome92AS\bin
> C:\Oracle\OraHome92AS\bin>.\sqlplus.exe
>
> SQL*Plus: Release 9.0.1.3.0 - Production on Thu Jun 28 12:14:49 2007
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> Enter user-name:
> C:\Oracle\OraHome92AS\bin>
> --------------
>
> I find this rather confusing ... installed both the DB and the AS from
> the same install set and they use different sqlplus version ... ?
>
> br,
> Martin
>

Yes they do.

But even that does not tell what *server* version you operate. The banner, after logging in to the database, does tell.

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGhWNkLw8L4IAs830RAgDBAJ9oPx9+OPmC5u+1IFPmk9peGCpK3QCaAoop R0bb9C/r3NDwS/HrL8G/RoA=
=1ndc
-----END PGP SIGNATURE----- Received on Fri Jun 29 2007 - 14:54:12 CDT