Re: ORA-12514 with 10g Install (LONG...)

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 22 Jan 2008 10:53:38 +0100
Message-ID: <3b5dd$4795bd23$524b5c40$20805@cache3.tilbu1.nb.home.nl>


Scout wrote:
> On Jan 21, 5:08 am, Frank van Bortel <frank.van.bor..._at_gmail.com>
> wrote:

>> That would kind of invalidate all previous attempts.

> Thanks for your patience despite my attempts.
>
>> Let's start at the beginning:
>> - did you create an instance, called "ORCL", or is it still
>> "XE"? (You did tnsping XE - hence the question...)

>
> You are right. My mistake. I re-pinged and here are the results:
>
> Tnsping results
> -----------------------
> C:\>tnsping ORCL
>
> TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production
> on 21-JAN-2008 12:42:45
>
> Copyright (c) 1997, 2005, Oracle. All rights reserved.
>
> Used parameter files:
> C:\oracle\product\10.2.0\db\network\admin\sqlnet.ora

OK - %ORACLE_HOME% is C:\oracle\product\10.2.0\db
>
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST
> = scout.domain.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICAT
> ED) (SERVICE_NAME = orcl)))
> OK (60 msec)

OK - your network seems to be defined, oracle wise. Your tnsnames.ora file know about ORCL, and so does the listener. Remains to be seem if orcl exists.
>
>

>> - can you:
>> -- open a command prompt ("DOS box")
>> -- type "set oracle_sid=orcl"
>> -- type "sqlplus / as sysdba"
>> both times without the quotes.
>> Post the results of that.

>
> Results of SQLPLUS/ as sysdba:
> ------------------------------------------------
>
> C:\>sqlplus / as sysdba
>
> SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 21 12:47:57 2008
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> ERROR:
> ORA-01031: Message 1031 not found; No message file for product=RDBMS,
> facility=ORA
>

That is odd - seems as if your environment is not correct. You did type the "set oracle_sid=orcl" before this, did you?

>
> Enter user-name: SYSDBA

username would have been "/ as sysdba".

> Enter password:
> ERROR:
> ORA-01034: Message 1034 not found; No message file for product=RDBMS,
> facility=ORA
> ORA-27101: Message 27101 not found; No message file for product=RDBMS,
> facility=ORA
>
>
> Enter user-name:
>

>> I never had to install a loopback adapter on XP (btw - which version
>> of XP do you use?!?).

> When I read the installation guide for Oracle Std Edition, it
> indicated that the loopback was mandatory if you connected to the
> internet using a DHCP. Hence I installed it.
> My version of XP is XP Professional, Service Pack 2
>
> Thanks again, Frank!!

XP Pro is a supported and certified version, so things should work. The loopback was a NT3.51/NT4 thing, documentation simply never got adjusted. XP (and Win2K) have it by default (127.0.0.1 is the loopback address - if you can ping that, you'll have the loopback adapter).

Are you on a domain (sometimes, not always?), by any chance?

Could you inspect your path variable and see if anything from previous installs is still there? DOS used to have a limit of 128 characters, but XP uses 4k (iirc) - if you have installed/de-installed a lot, you may have crossed that boundary... Oracle does not do a good job cleaning up on de-installs...
Check if C:\oracle\product\10.2.0\db is in your path (preferably at the beginning)

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Tue Jan 22 2008 - 03:53:38 CST

Original text of this message