-
ORA-00205: error in identifying control file
No i dint use dbca tool
i manually created started creating database
i dont hv any data
i learnt DBA 1month back nw i started working out
creatind database wt i did
step 1 : Set Environment
this is hw itt looks
# .bash_profile.
export ORACLE_SID=sun
export ORACLE_HOME=/u01/ofa/product/10.2.0
export PATH=$ORACLE_HOME/bin:$PATH:
:wq
2)created Pfile or Init file
[oracle@ambi ~]$ cd $ORACLE_HOME/dbs [oracle@ambi dbs]$ ls
hc_sun.dat initdw.ora init.ora initsun.ora lkSUN
[oracle@ambi dbs]$ cd vi initsun.ora
# replace DEFAULT with your database name
db_name=sun
db_files = 80 # SMALL
# db_files = 400 # MEDIUM
# db_files = 1500 # LARGE
db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM
# db_file_multiblock_read_count = 32 # LARGE
db_block_buffers = 100 # SMALL
# db_block_buffers = 550 # MEDIUM
# db_block_buffers = 3200 # LARGE
#shared_pool_size = 3500000 # SMALL
# shared_pool_size = 5000000 # MEDIUM
shared_pool_size = 90000000 # LARGE
log_checkpoint_interval = 10000
processes = 50 # SMALL
# processes = 100
undo_tablespace=UNDOTBS
undo_management=auto
user_dump_dest='/disk2/sun/udump'
background_dump_dest='/disk2/sun/bdump'
core_dump_dest='/disk2/sun/cdump'
parallel_max_servers = 5 # SMALL
# parallel_max_servers = 4 x (number of CPUs) # MEDIUM
# parallel_max_servers = 4 x (number of CPUs) # LARGE
log_buffer = 32768 # SMALL
# log_buffer = 32768 # MEDIUM
# log_buffer = 163840 # LARGE
# audit_trail = true # if you want auditing
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
global_names = TRUE
# define two control files by default
control_files='/disk1/sun/controlfile/contro101.ctl'
3)step i created dumps
[oracle@ambi sun]$ pwd
/disk2/sun
[oracle@ambi sun]$ ls
bdump cdump create udump
[oracle@ambi sun]$
4) created databasescript i.e createsun.sql
[oracle@ambi create]$ pwd
/disk2/sun/create
[oracle@ambi create]$ ls
createsun.sql
[oracle@ambi create]$ vi createsun.sql
create database sun
datafile '/disk1/sun/datafile/system.dbf' size 170m
sysaux datafile '/disk1/sun/datafile/sysaux.dbf' size 150m
default temporary tablespace TEMP tempfile
'/disk1/sun/datafile/temp1.dbf' size 10m
default tablespace USERS datafile
'/disk1/sun/datafile/user1.dbf' size 20m
undo tablespace UNDOTBS datafile
'/disk1/sun/datafile/undo1.dbf' size 20m
logfile
group 1 ('/disk1/sun/redologfile/redolog1a.log') size 4m,
group 2 ('/disk1/sun/redologfile/redolog2a.log') size 4m;
[oracle@ambi ~]$ sqlplus '/as sysdba';
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 8 23:54:34 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 125829120 bytes
Fixed Size 1218052 bytes
Variable Size 117443068 bytes
Database Buffers 4194304 bytes
Redo Buffers 2973696 bytes
ORA-00205: error in identifying control file, check alert log for more info
this is wt i did
-
Since you are learning Oracle, I would suggest that you delete the old database and use dbca to create a new database. You should also review the concepts manual, http://download.oracle.com/docs/cd/B...b28301/toc.htm, to see what the various parts of an Oracle database are and how they interact. Recreating the database should help you to learn more about Oracle.
-
ORA-00205: error in identifying control file
wt i hv to do nw
should i delete
/u01 folder contents
and
.bash_profile.
and
initsun.ora which is in [oracle@ambi ~]$ cd $ORACLE_HOME/dbs
and
[oracle@ambi sun]$ ls
bdump cdump create udump
delete this dimps nad
delete createsun.sql
-
ORA-00205: error in identifying control file
-
ORA-00205: error in identifying control file
one more problem i hv [oracle@ambi ~]$ su
Password:
[root@ambi 10.2.0]# cd
[root@ambi ~]# su - oracle
-bash-3.00$
-bash-3.00$
-bash-3.00$
-bash-3.00$
-bash-3.00$
-bash-3.00$
if i do
-bash-3.00$ logout
[root@ambi ~]#
if i give
[root@ambi ~]# su oracle
its going
[oracle@ambi ~]$
-
go to otn.oracle.com and read the concepts manual
then go and learn the difference between su and su - in a unix environemnt, the help you needc cannot be give on a forum.
I even severely doubt that you have even created a database
-
so hw should i follow the steps
wt i hv to do nw
should i delete
/u01 folder contents
and
.bash_profile.
and
initsun.ora which is in [oracle@ambi ~]$ cd $ORACLE_HOME/dbs
and
[oracle@ambi sun]$ ls
bdump cdump create udump
delete this dimps nad
delete createsun.sql
-
have you even created a database?
-
You need to learn this yourself. I think you have been given enough help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|