手动创建数据库,运行创建脚本,无任何响应。请帮忙指点下。谢谢!

xiaoyaoliuyun 2010-04-29 04:05:04
windows xp_sp3,oracle9.2
sql>CREATE DATABASE xmj
LOGFILE 'D:\Oracle\oradata\xmj\redo01.log' SIZE 2048K,
'D:\Oracle\oradata\xmj\redo02.log' SIZE 2048K,
'D:\Oracle\oradata\xmj\redo03.log' SIZE 2048K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'D:\Oracle\oradata\xmj\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET ZHS16GBK
sql>

日志如下:
Dump file d:\oracle\admin\xmj\bdump\alert_xmj.log
Thu Apr 29 15:43:08 2010
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 3, CPU type 586
Thu Apr 29 15:43:08 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\xmj\control01.ctl, D:\oracle\oradata\xmj\control02.ctl, D:\oracle\oradata\xmj\control03.ctl
db_block_size = 4096
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 600
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = xmj
dispatchers = (PROTOCOL=TCP) (SERVICE=sxj)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\xmj\bdump
user_dump_dest = D:\oracle\admin\xmj\udump
core_dump_dest = D:\oracle\admin\xmj\cdump
sort_area_size = 524288
db_name = xmj
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Apr 29 15:43:11 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Apr 29 15:43:47 2010
Starting ORACLE instance (normal)
Thu Apr 29 15:45:02 2010
Starting ORACLE instance (normal)
Thu Apr 29 15:47:22 2010
Starting ORACLE instance (normal)
...全文
49 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复

17,377

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧