Re: Ora-12514(B

From: <johnbhurley_at_sbcglobal.net(B>
Date: Wed, 4 Mar 2009 08:33:39 -0800 (PST)
Message-ID: <ec83a9d6-7230-4fd6-aed0-2e25300150c7_at_o8g2000pre.googlegroups.com>

On Mar 4, 11:15 am, Ming$BGl(B <l..._at_tech-trans.com> wrote:

snip

> > What version of oracle and windows?
>
> > Maybe the instance is down or something wrong in your listener config?
>
> > Can you check if both instances are running?
>
> > What exactly do your listener.ora, tnsnames.ora and sqlnet.ora files
> > contain?
>
> Windows 2003 server Enterprise Edition with Oracle 10.2.0.4.0
> At the same time, I go to check the status of Oracle instance
> therefore I use sqlplus /nolog

Well you did give answers to one of the questions ... I did not see the .ora files listed above.

Like I said I don't do oracle on windows much but if you go into a command prompt ( dos ) window and set the ORACLE_SID correctly you should be able to just do a sqlplus / as sysdba without supplying a connect string.

Are you guys really using oracle names still?

Is there a DBA for the server that you can work with or is that you? What does lsnrctl status give you as output? Received on Wed Mar 04 2009 - 10:33:39 CST