|
Create database. HELP!
|
|||
---|---|---|---|
#18+
Существует скрипт: spool /oracle/admin/dir_name/create/crdbdb_name.lst connect internal startup nomount pfile=/oracle/admin/dir_name/pfile/initdb_name_0.ora create database "db_name" maxinstances 8 maxlogfiles 32 character set "CL8ISO8859P5" national character set "CL8ISO8859P5" datafile '/oracle/oradata/dir_name/system01.dbf' size 200M logfile '/oracle/oradata/dir_name/redodb_name01.log' size 2M, '/oracle/oradata/dir_name/redodb_name02.log' size 2M, '/oracle/oradata/dir_name/redodb_name03.log' size 2M; disconnect spool off При запуске получается следующее: SVRMGR> @/oracle/admin/dir_name/create/crdbdb_name.sql Connected. ORACLE instance started. Total System Global Area 6003688 bytes Fixed Size 52200 bytes Variable Size 4235264 bytes Database Buffers 1638400 bytes Redo Buffers 77824 bytes create database "db_name" * ORA-01501: CREATE DATABASE failed ORA-00200: controlfile could not be created ORA-00202: сontrolfile: '/oracle/oradata/db_name/control01.ctl' ORA-27038: skgfrcre: file exists Disconnected. Все control файлы и redo файлы после отработки скрипта создаются. Oracle 8.0.6.2.0 ОС HP-UX 11.0 Заранее благодарен за помощь. ... |
|||
:
Нравится:
Не нравится:
|
|||
06.09.2002, 11:06 |
|
Create database. HELP!
|
|||
---|---|---|---|
#18+
наверное надо: create database "db_name" controlfile reuse ... ... |
|||
:
Нравится:
Не нравится:
|
|||
06.09.2002, 12:42 |
|
|
start [/forum/topic.php?fid=52&fpage=2843&tid=1993130]: |
0ms |
get settings: |
11ms |
get forum list: |
13ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
33ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
45ms |
get tp. blocked users: |
2ms |
others: | 14ms |
total: | 141ms |
0 / 0 |