-
ora 205 during 1st time Startup after Installation
Hi
I am new to Oracle.
I am trying to install Oracle 7.3.2 Workgroup Server Edition
on SCO-UNIX Release 5.
After the installation process got completed,
1)I have made the necessary changes in listener.ora & tnsnames.ora.
2)Have also added TWO_TASK & TNS_ADMIN environment variables.
3)Listener is getting started normally.
4)When I try to run svrmgrl,
connect internal (does not ask for the "manager" password, which is
weird), it gets connected.
When I try to startup the database, it gives:
ora 00205 error in identifying control file '?/dbs/cntrl@.dbf'
ora 07360 sfifi stat error, unable to obtain information about file
no such file or directory
There is no such file in the said location.
Now as I understand it, during the CD installation itself,
Oracle has created the database.
Then is it not but obvious that it should also create a control file??
How do I get my database to startup & proceed with remaining steps??
-
have you actually created a database, are you sure there is one
-
havent created database explicitly.
but as a part of the CD Installation, I received a message saying DB Creation Successful
-
well check if there are database files created
-
only the default ones are created like usersLIVE.dbf & toolsLIVE.dbf etc
-
I am trying to install Oracle 7.3.2 Workgroup Server Edition
on SCO-UNIX Release 5.
Oracle 7.3.2 ??
Now 10g is available, why do you want to learn 15 years old tech, you will soon unlearn when you come to 10g.
Tamil
-
Guys.... i know the technology is old...
but im stuck in a soup here...
my client wants to restore an old application
& get some history data
& the clock is ticking...
so plzzzz help me
-
The error message says clearly the control file does not exist in ./dbs/ dir.
Cross check with init.ora file or config.ora file
If you have backup control (ascii format) file, you can recreate it.
Tamil
-
Exactly, the controlfile does not exist.
If Oracle created the database during CD Installation, shud a controlfile also not get created??
Am pasting the initLIVE.ora below :
#
# $Header: initx.orc 1.1 95/02/27 12:14:56 wyim Osd $ Copyr (c) 1992 Oracle
#
db_name = oracle
compatible = 7.3.2.0.0
remote_login_passwordfile = exclusive
rollback_segments = (r01,r02,r03,r04)
# include async I/O configuration parameters, for Solaris Intel only
#async_write = TRUE
#async_read = TRUE
#_lgwr_async_write = TRUE
#use_ism = FALSE
# include post-wait driver parameters, for UnixWare only
#use_post_wait_driver = TRUE
#post_wait_device = /dev/pw
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you customize
# your RDBMS installation for your site. Important system parameters
# are discussed, and example settings given.
#
# Some parameter settings are generic to any size installation.
# For parameters that require different values in different size
# installations, three scenarios have been provided: SMALL, MEDIUM
# and LARGE. Any parameter that needs to be tuned according to
# installation size will have three settings, each one commented
# according to installation size.
#
# Use the following table to approximate the SGA size needed for the
# three scenarious provided in this file:
#
# -------Installation/Database Size------
# SMALL MEDIUM LARGE
# Block 2K 4500K 6800K 17000K
# Size 4K 5500K 8800K 21000K
#
# To set up a database that multiple instances will be using, place
# all instance-specific parameters in one file, and then have all
# of these files point to a master file using the IFILE command.
# This way, when you change a public
# parameter, it will automatically change on all instances. This is
# necessary, since all instances must run with the same value for many
# parameters. For example, if you choose to use private rollback segments,
# these must be specified in different files, but since all gc_*
# parameters must be the same on all instances, they should be in one file.
#
# INSTRUCTIONS: Edit this file and the other INIT files it calls for
# your site, either by using the values provided here or by providing
# your own. Then place an IFILE= line into each instance-specific
# INIT file that points at this file.
###############################################################################
# tuning parameters
db_files = 20
db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM
# db_file_multiblock_read_count = 32 # LARGE
db_block_buffers = 200 # SMALL
# db_block_buffers = 550 # MEDIUM
# db_block_buffers = 3200 # LARGE
shared_pool_size = 3500000 # SMALL
# shared_pool_size = 6000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
log_checkpoint_interval = 10000
processes = 50 # SMALL
# processes = 100 # MEDIUM
# processes = 200 # LARGE
dml_locks = 100 # SMALL
# dml_locks = 200 # MEDIUM
# dml_locks = 500 # LARGE
log_buffer = 8192 # SMALL
# log_buffer = 32768 # MEDIUM
# log_buffer = 163840 # LARGE
sequence_cache_entries = 10 # SMALL
# sequence_cache_entries = 30 # MEDIUM
# sequence_cache_entries = 100 # LARGE
sequence_cache_hash_buckets = 10 # SMALL
# sequence_cache_hash_buckets = 23 # MEDIUM
# sequence_cache_hash_buckets = 89 # 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
# log_archive_start = true # if you want automatic archiving
# global_names = TRUE
What should be my course of action. Please help.
Thanks :-)
-
Originally Posted by anuttam_b
Hi
I am new to Oracle.
I am trying to install Oracle 7.3.2 Workgroup Server Edition
on SCO-UNIX Release 5.
After the installation process got completed,
1)I have made the necessary changes in listener.ora & tnsnames.ora.
2)Have also added TWO_TASK & TNS_ADMIN environment variables.
3)Listener is getting started normally.
4)When I try to run svrmgrl,
connect internal (does not ask for the "manager" password, which is
weird), it gets connected.
When I try to startup the database, it gives:
ora 00205 error in identifying control file '?/dbs/cntrl@.dbf'
ora 07360 sfifi stat error, unable to obtain information about file
no such file or directory
There is no such file in the said location.
Now as I understand it, during the CD installation itself,
Oracle has created the database.
Then is it not but obvious that it should also create a control file??
How do I get my database to startup & proceed with remaining steps??
As you said,
svrmgrl
connect internal
gives you "connected" status.
Also, your init.ora doesn't specify the path of controlfile. Are you sure a default database has been created.
I don't know much about oracle 7x, but the init.ora should have the path of control, udump, bdump, etc. which is not seen in yours.
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
|