Re: ORA-12514 with 10g Install (LONG...)
Date: Tue, 22 Jan 2008 10:53:38 +0100
> On Jan 21, 5:08 am, Frank van Bortel <frank.van.bor..._at_gmail.com>
>> 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:
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.
> ORA-01031: Message 1031 not found; No message file for product=RDBMS,
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:
> ORA-01034: Message 1034 not found; No message file for product=RDBMS,
> ORA-27101: Message 27101 not found; No message file for product=RDBMS,
> 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 upReceived on Tue Jan 22 2008 - 03:53:38 CST