Re: ORA-12514 with 10g Install (LONG...)
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:> -- type "set oracle_sid=orcl"
> -- open a command prompt ("DOS box")
> -- 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