Re: Cannot connect to Oracle 10g database

On 30 Apr, 21:38, joel garry <joel-ga..._at_home.com> wrote:
> On Apr 30, 11:46 am, Raj <jkama..._at_gmail.com> wrote:
>
>
>
> > SQL> alter database open
> >   2  /
> > alter database open
> > *
> > ERROR at line 1:
> > ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
> > ORA-01110: data file 7:
> > 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\EMEA\STAHOP_DATA01.DBF'
>
> Does this file exist?  Is it being locked by a virus scanner or backup
> program or editor or something?
>
>
>
>
>
>
>
> > I ran the lsnrctl status and got the following output:
>
> > C:\Documents and Settings\Administrator>lsnrctl status
>
> > LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 30-
> > APR-2008 11:21
> > :05
>
> > Copyright (c) 1991, 2006, Oracle.  All rights reserved.
>
> > Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
> > STATUS of the LISTENER
> > ------------------------
> > Alias                     LISTENER
> > Version                   TNSLSNR for 32-bit Windows: Version
> > 10.2.0.3.0 - Produ
> > ction
> > Start Date                12-APR-2008 03:11:41
> > Uptime                    18 days 8 hr. 9 min. 24 sec
> > Trace Level               off
> > Security                  ON: Local OS Authentication
> > SNMP                      OFF
> > Listener Parameter File   C:\oracle\product\10.2.0\db_1\network\admin
> > \listener.o
> > ra
> > Listener Log File         C:\oracle\product\10.2.0\db_1\network\log
> > \listener.log
>
> > Listening Endpoints Summary...
> >   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe
> > \EXTPROC1ipc)))
> >   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=support-db3)(PORT=1521)))
> > Services Summary...
> > Service "PLSExtProc" has 1 instance(s).
> >   Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> > service...
> > Service "orcl10g" has 1 instance(s).
> >   Instance "orcl10g", status READY, has 1 handler(s) for this
> > service...
> > # Generated by Oracle configuration tools.
>
> > ORCL10G =
> >   (DESCRIPTION =
> >     (ADDRESS_LIST =
> >       (ADDRESS = (PROTOCOL = TCP)(HOST = support-db3.actuate.com)(PORT
> > = 1521))
> >     )
> >     (CONNECT_DATA =
> >       (SERVICE_NAME = orcl10g)
> >     )
> >   )
>
> Maybe a mismatch between your hostname and your fully qualified
> hostname?  Try briefly renaming your listener.ora to something else
> (or comment out the parts that refer to this db) and reload your
> listener and let your db register itself, see if the host is different
> with lsnrctl status.  That is, if you can get your db open.  I'm not
> sure whether you've ever had it open?  What does your alert log say
> about that?  Do you have a listener.trc file?  What is the last TNS-
> error in your listener.log?  Are there blocking errors?
>
> jg
> --
> @home.com is bogus.
> Let the stupidity begin!  http://www.signonsandiego.com/news/metro/20080429-1514-bn29videogam.html- Hide quoted text -
>

Er... is there a DBA handy?

HTH -g Received on Thu May 01 2008 - 04:24:29 CDT