Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

problem for startup

Posted on 2011-03-24
1
Medium Priority
?
528 Views
Last Modified: 2012-05-11
Here is some problems issued with startup
could you help me with that?

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  535662592 bytes                                      
Fixed Size                  1334380 bytes                                      
Variable Size             192938900 bytes                                      
Database Buffers          335544320 bytes                                      
Redo Buffers                5844992 bytes                                      
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted


Elapsed: 00:00:00.04
SQL> connect /as sysdba
Connected.
SQL> show parameters control_files;

NAME                                 TYPE        VALUE                          
------------------------------------ ----------- ------------------------------
control_files                        string      C:\APP\MATHEW\ORADATA\COMPANY\
                                                 CONTROL01.CTL, C:\APP\MATHEW\O
                                                 RADATA\COMPANY\CONTROL02.CTL,  
                                                 C:\APP\MATHEW\ORADATA\COMPANY\
                                                 CONTROL03.CTL                  
SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area  535662592 bytes                                      
Fixed Size                  1334380 bytes                                      
Variable Size             192938900 bytes                                      
Database Buffers          335544320 bytes                                      
Redo Buffers                5844992 bytes                                      
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted

0
Comment
Question by:nobleit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
data_n_poker earned 2000 total points
ID: 35212021
Try this before you open the database

alter database mount;

Open in new window

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question