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

From: Scout <scout1024_at_gmail.com>
Date: Mon, 21 Jan 2008 09:51:22 -0800 (PST)
Message-ID: <effb5584-c946-4fdb-8ac0-aee60b59eb2d@v17g2000hsa.googlegroups.com>


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

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)

>- 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

Enter user-name: 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!! Received on Mon Jan 21 2008 - 11:51:22 CST

Original text of this message