ORA-01079 [message #487451] |
Mon, 27 December 2010 04:34 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
debakor
Messages: 1 Registered: November 2009 Location: Dhaka
|
Junior Member |
|
|
When i want to create manual database its give the error message ORA-01092 Here i give the create database command and my parameter file.
SQL> create database dba16
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 5
4 MAXLOGHISTORY 1
5 MAXDATAFILES 200
6 MAXINSTANCES 1
7 logfile group 1 ('D:\oracle\oradata\dba16\redo1.log') size 100M,
8 group 2 ('D:\oracle\oradata\dba16\redo2.log') size 100M,
9 group 3 ('D:\oracle\oradata\dba16\redo3.log') size 100M
10 character set WE8ISO8859P1
11 national character set utf8
12 datafile 'D:\oracle\oradata\dba16\system01.dbf'
13 size 500M
14 extent management local
15 sysaux datafile 'D:\oracle\oradata\dba16\sysaux01.dbf'
16 size 300M
17 undo tablespace UNDOTBS1
18 datafile 'D:\oracle\oradata\dba16\undotbs01.dbf'
19 size 200M
20 default temporary tablespace temp
21 tempfile 'D:\oracle\oradata\dba16\temp01.dbf'
22 size 100M;
create database dba16
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
++++++++++++++++++++Parameter File++++++++++++++++++++++
*.audit_file_dest='D:\oracle\admin\dba16\adump'
*.background_dump_dest='D:\oracle\admin\dba16\bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:\oracle\oradata\dba16\control01.ctl','D:\oracle\oradata\dba16\control02.ctl','D:\oracle\oradata\dba16\control03.ct l'
*.core_dump_dest='D:\oracle\admin\dba16\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='dba16'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=MIDDLEDBXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=150M
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=500M
*.shared_pool_size=150M
*.large_pool_size=8M
*.db_cache_size=100M
*.log_buffer=2097152
*.java_pool_size=24M
*.undo_management='AUTO'
*.undo_tablespace='undotbs01'
*.user_dump_dest='D:\oracle\admin\dba16\udump'
can anyone help me. I want to install the manual database on my pc with 1 GB RAM.
Waiting for your help.
|
|
|
Re: ORA-01079 [message #487452 is a reply to message #487451] |
Mon, 27 December 2010 04:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
ORA-01092: ORACLE instance terminated. Disconnection forced
*Cause: The instance this process was connected to was terminated
abnormally, probably via a shutdown abort. This process
was forced to disconnect from the instance.
*Action: Examine the alert log for more details. When the instance has been
restarted, retry action.
Quote:Examine the alert log for more details
Regards
Michel
|
|
|