[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 532
  • Last Modified:

problem for startup

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
nobleit
Asked:
nobleit
1 Solution
 
data_n_pokerCommented:
Try this before you open the database

alter database mount;

Open in new window

0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now