Dear All,
The command which I used is the following.
>oradim -new -sid TestDb -intpwd oracle -startmode a -pfile
D:\oracle\admin\TestDb\pfile\init.ora -shuttype srvc
Typing mistake in my previous mail.
Regards,
Bhas.
-----Original Message-----
From: chrisguillaume [mailto:[Email address protected]
Sent: Thursday, September 30, 2004 8:32 PM
To: Sreedhar_ bhaskararaju
Subject: Re: ORA-00202: controlfile
**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
A couple of things:
1) your oradim command is creating a service for an instance TestCoin, but
your parmeter file references the instance TestDB
2) oradim creates the Oracle Service and Password File (in you specify
-intpwd). It does not create the controlfiles or other database files.
3) check your ORACLE_SID env variable, make sure it is set the correct
instance name
To create database:
1) oradim to create the service/pwd file (oradim is windows specific)
2) create init.ora file
3) startup nomount
4) create database ....
Dear All,
While creating new database manually
>oradim -new -sid TestCoin -intpwd oracle -startmode a -pfile
D:\oracle\admin\TestDb\pfile\init.ora -shuttype srvc
It did not showed any error on command prompt
But if I see testDbALRT.LOG
Thu Sep 30 19:04:36 2004
alter database mount exclusive
Thu Sep 30 19:04:36 2004
ORA-00202: controlfile: 'D:\oracle\oradata\TestDb\CONTROL01.CTL'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Thu Sep 30 19:04:36 2004
ORA-205 signalled during: alter database mount exclusive...
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 2100
If I check oradim.ora
Thu Sep 30 19:04:36 2004
ORA-00205: error in identifying controlfile, check alert log for more info
Thu Sep 30 19:04:36 2004
Instance created.
If I do next step
>sqlplus "sys/oracle as sysdba"
ERROR:
ORA-01017: invalid username/password; logon denied
Can some body tell what is this error.
init.ora
############################################################################
##
# Copyright (c) 1991, 2001 by Oracle Corporation
############################################################################
##
###########################################
# Cache and I/O
###########################################
db_block_size=4096
db_cache_size=33554432
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=D:\oracle\admin\TestDb\bdump
core_dump_dest=D:\oracle\admin\TestDb\cdump
timed_statistics=TRUE
user_dump_dest=D:\oracle\admin\TestDb\udump
###########################################
# Distributed, Replication and Snapshot
###########################################
db_domain=""
remote_login_passwordfile=EXCLUSIVE
###########################################
# File Configuration
###########################################
control_files=("D:\oracle\oradata\TestDb\CONTROL01.CTL",
"D:\oracle\oradata\TestDb\CONTROL02.CTL",
"D:\oracle\oradata\TestDb\CONTROL03.CTL")
###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP)(SER=MODOSE)",
"(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)",
"(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
###########################################
# Miscellaneous
###########################################
compatible=9.0.0
db_name=TestDb
###########################################
# Network Registration
###########################################
instance_name=TestDb
###########################################
# Pools
###########################################
java_pool_size=52428800
large_pool_size=10485760
shared_pool_size=33554432
###########################################
# Processes and Sessions
###########################################
processes=150
###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
sort_area_size=524288
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS
Regards,
Bhas
Ph: +91 80 2235333 <3746>
**************************************************************************
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.
**************************************************************************
Oracle LazyDBA home page