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] 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
Oracle LazyDBA home page