RE: AW: ERROR:ORA-01034, ERROR: ORA-12514

RE: AW: ERROR:ORA-01034, ERROR: ORA-12514

 

  

Look in the laert log
And post the error

The answer will be in the alert log and possibly a system process trace file



Regards

John Fak
Oracle DBA
_____________________
Accenture Workforce Solutions

mobile: +44 (0)778 655 1214
landline: +44 (0)207 844 6981
Octel : (46981)
mailto:john.[Email address protected]



-----Original Message-----
From: Yoseph Ibraham Fahed [mailto:oracledba-ezmlmshield-x62776876.[Email address protected]
Sent: 30 September 2004 16:00
To: LazyDBA Discussion
Subject: Re: AW: ERROR:ORA-01034, ERROR: ORA-12514

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



--------
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 message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

Oracle LazyDBA home page