Re: Cannot connect to Oracle 10g database

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