Re: Create 8.1.7 instance on Win2000 fails, no controlfile

Hi Peter.

When did you fall under the impression that oradim creates a database for you??

It doesn't -it creates the service that will support your Instance. And yes, you do have an Instance, even if you never have a database ('cos an Instance is just a bit of memory looking for something to manage).

I suggest you investigate the 'create database' command. A beautiful piece of SQL syntax that will create you, in short order, a control file, a datafile and a couple of redo logs. (Incidentally, and relating to no-one in particular, but it will also create you a system rollback segment in the system datafile).

And please: go read a manual or two. The fact that a control file is not created does NOT mean an Instance hasn't been started. All Instances are started long before anyone worries about looking for a control file to read.

Regards
HJR "Peter Laursen" <ptl_at_edbgruppen.dk> wrote in message news:9ctmu2$ra3$1_at_news.inet.tele.dk...
> Hi,
>
> I am trying to create a testinstance on Win2000. Software is 8.1.7.0.0.
 When
> running oradim the service is created, but no controlfile is created, and
> thus the instance is not started. I am logged in as local administrator. I
> guess I am missing something simple, but I just cannot see what?
> Please if anyone can spot the error in the files given below!
>
> RUN FROM COMMANDLINE:
> oradim -new -sid HBMS -startmode a -pfile "D:\Eg\Database\inithbms_8i.ora"
>
> PARAMETERFILE:
> control_files = ("D:\EG\Database\hbmsora1.ctl")
>
>
> # "d:\eg\database\hbmsora2.ctl",
> # "d:\eg\database\hbmsora3.ctl")
>
> db_name = "HBMS"
>
> #rollback_segments = (rbs1, rbs2, rbs3)
> db_files = 100
> db_block_size = 4096
> db_file_multiblock_read_count = 32
> db_block_buffers = 2048
> shared_pool_size = 5000000
> large_pool_size = 614400
> java_pool_size = 0
> log_checkpoint_interval = 12000
> processes = 50
> dml_locks = 800
> log_buffer = 32768
> sort_area_size = 1048576
> #sort_area_size = 10000000 #Ved reindex
> max_dump_file_size = 1024000
> open_cursors = 300
> optimizer_mode=rule
> #cursor_space_for_time=true
> #log_archive_start=true
> #log_archive_dest=/oraclearchive/arch
> #log_archive_format = %s.dbf
> timed_statistics=true
> compatible = 8.1.0
>
> global_names = TRUE
> remote_login_passwordfile = shared
>
> ORADIM.LOG
> ORA-00205: fejl ved identificering af kontrolfil. Se advarsel for flere
> oplyninger
>
> ALERTLOG:
> Dump file D:\oracle\ora81\RDBMS\trace\hbmsALRT.LOG
> Fri May 04 08:18:42 2001
> ORACLE V8.1.7.0.0 - Production vsnsta=0
> vsnsql=e vsnxtr=3
> Windows 2000 Version 5.0 Service Pack 1, CPU type 586
> Starting up ORACLE RDBMS Version: 8.1.7.0.0.
> System parameters with non-default values:
> processes = 50
> timed_statistics = TRUE
> shared_pool_size = 5000000
> large_pool_size = 614400
> java_pool_size = 32768
> control_files = D:\EG\Database\hbmsora1.ctl
> db_block_buffers = 2048
> db_block_size = 4096
> compatible = 8.1.0
> log_buffer = 32768
> log_checkpoint_interval = 12000
> db_files = 100
> db_file_multiblock_read_count= 32
> dml_locks = 800
> remote_login_passwordfile= SHARED
> global_names = TRUE
> sort_area_size = 1048576
> db_name = HBMS
> open_cursors = 300
> optimizer_mode = rule
> max_dump_file_size = 1024000
> PMON started with pid=2
> DBW0 started with pid=3
> LGWR started with pid=4
> CKPT started with pid=5
> SMON started with pid=6
> RECO started with pid=7
> Fri May 04 08:18:44 2001
> alter database mount exclusive
> Fri May 04 08:18:45 2001
> ORA-00202: controlfile: 'D:\EG\Database\hbmsora1.ctl'
> ORA-27041: unable to open file
> OSD-04002: kan ikke åbne fil
> O/S-Error: (OS 2) The system cannot find the file specified.
>
> Fri May 04 08:18:45 2001
> ORA-205 signalled during: alter database mount exclusive...
> Shutting down instance (abort)
> License high water mark = 1
> Instance terminated by USER, pid = 1532
>
>
> /Peter
>
>
Received on Fri May 04 2001 - 09:33:36 CDT