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

Scout wrote:

>> Right, and is this also the oracle_home of the sqlplus session you start?
>> Start it from C:\oracle\product\10.2.0\db\bin

That usually is a tell-tale sign of Windows services not started.

You should be able to start the service either from the services panel (My Computer->Right Mouse, Manage, iirc, or via Control Panel). Start OracleServiceORCL (capitalization is mine. Even from a DOS-box: net start OracleServiceORCL should either report the service is already started, or start it.

I think you should not use the listener at all (and for local sessions you do not need the listener); just set the correct environment (set ORACLE_SID=ORCL, %ORACLE_HOME%/bin is in your path, %ORACLE_HOME% is set, etc), and you're done.

I think all problems are from the fact you sometimes are logged on to a domain, and when you are, you are not a local administrator. When you logon to your computer (using your computer's name for a "domain"), you are local admin.
That, or vice versa.

You should be able to logon to your default domain, even when you are not connected to it - Windows uses a cache mechanism that still allows you to login, even though your credentials cannot be verified.
Just give it a try, and let us know when things do work.

I'd be happy if you got an ORA-01031, ORA-01034 or 1107. Again - do not worry about the listener - local access does not need one! It just needs a correct environment!

BTW how did you create an instance (the ORCL thing)?!?

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up