try to use
startup force
> Please Shutdown Database and reboot the System
>
> -----Ursprüngliche Nachricht-----
> Von: Sreedhar_ bhaskararaju [mailto:oracledba-ezmlmshield-x28139519.[Email
> address protected]
> Gesendet: Dienstag, 28. September 2004 14:24
> An: LazyDBA Discussion
> Betreff: RE: ERROR:ORA-01034, ERROR: ORA-12514
>
> Dear All,
>
> Now I started database again, again the following errors.
>
> SQL> connect sys/oracle as sysdba
> Connected to an idle instance.
> SQL> startup mount
> ORACLE instance started.
>
> Total System Global Area 118255568 bytes
> Fixed Size 282576 bytes
> Variable Size 83886080 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 532480 bytes
> Database mounted.
> SQL> select * from tab;
> select * from tab
> *
> ERROR at line 1:
> ORA-01219: database not open: queries allowed on fixed tables/views only
>
>
> SQL> alter database open;
> alter database open
> *
> ERROR at line 1:
> ORA-01092: ORACLE instance terminated. Disconnection forced
>
> Thanks & Regards,
> Bhas
>
> -----Original Message-----
> From: Kevin Venter [mailto:[Email address protected]
> Sent: Tuesday, September 28, 2004 5:21 PM
> To: Sreedhar_ bhaskararaju
> Subject: RE: ERROR:ORA-01034, ERROR: ORA-12514
>
>
> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
> normal
> **Anything below this line is the original email text
>
>
> The database started up in noumount ??
>
> -----Original Message-----
> From: Sreedhar_ bhaskararaju
> [mailto:oracledba-ezmlmshield-x7016358.[Email address protected]
> Sent: 28 September 2004 01:43
> To: LazyDBA Discussion
> Subject: ERROR:ORA-01034, ERROR: ORA-12514
>
>
> Dear All,
>
> Can any body tell how to solve this problem
>
> I Created Database manually,
>
> 1. If I do tnsping
>
> TNS Ping Utility for 32-bit Windows: Version 9.0.1.1.1 - Production on
> 28-SEP-20
> 04 16:33:54
>
> Copyright (c) 1997 Oracle Corporation. All rights reserved.
>
> Used parameter files:
> D:\oracle\ora90\network\admin\sqlnet.ora
> D:\oracle\ora90\network\admin\tnsnames.ora
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL
> =
> TCP)
> (HOST = bir-pc0237)(PORT = 1524))) (CONNECT_DATA = (SERVICE_NAME =
> TestDb1)))
> OK (30 msec)
>
> 2.
>>sqlplus "sys/oracle as sysdba"
>
> SQL*Plus: Release 9.0.1.0.1 - Production on Tue Sep 28 16:44:06 2004
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> Connected to an idle instance.
>
> SQL> show user
> USER is "SYS"
>
> SQL> select * from tab;
> select * from tab
> *
> ERROR at line 1:
> ORA-01034: ORACLE not available
>
> 4. If I try to connect through SQL *PLUS sys/[Email Address Removed] ERROR: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in
> connect descriptor
>
> Any idea how do I connect to database and work.
>
> Thanks & Regards,
> Bhas
> **************************************************************************
> This email (including any attachments) is intended for the sole use of the
> intended recipient/s and may contain material that is CONFIDENTIAL AND
> PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
> or
> distribution or forwarding of any or all of the contents in this message
> is
> STRICTLY PROHIBITED. If you are not the intended recipient, please contact
> the sender by email and delete all copies; your cooperation in this regard
> is appreciated.
> **************************************************************************
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> **************************************************************************
> This email (including any attachments) is intended for the sole use of the
> intended recipient/s and may contain material that is CONFIDENTIAL AND
> PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
> or
> distribution or forwarding of any or all of the contents in this message
> is
> STRICTLY PROHIBITED. If you are not the intended recipient, please contact
> the sender by email and delete all copies; your cooperation in this regard
> is appreciated.
> **************************************************************************
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
Fahed Ibraham Yoseph
Senior DBA and System Analysis
MCDBA
OCP
Government of Qatar
974 528-4617
Oracle LazyDBA home page