- 论坛徽章:
- 0
|
现在的情况是Oracle软件安装上去了
尝试用dbca建库,老报oracle is not available.
改用脚本操作。
vi initora11g.ora
"initora11g.ora" 28 lines, 977 characters
#***********************************************************************
# Database parameters
#***********************************************************************
db_block_size = 8192
db_files = 1000
#***********************************************************************
# Memory parameters
#***********************************************************************
memory_target=6871318528
db_file_multiblock_read_count = 16
#***********************************************************************
# Materialized view parameters
#***********************************************************************
compatible=11.1.0.0.0
#***********************************************************************
# Other Parameters
#***********************************************************************
db_name =ora11g
db_unique_name=ora11g
control_files=("/opt/oracle/db/oradata/ora11g/control01.ctl", "/opt/oracle/db/oradata/ora11g/control02.ctl", "/opt/oracle/db/oradata/ora11g/control03.ctl")
最简单的参数文件。
sqlplus /nolog
SQL> conn /as sysdba
Connected to an idle instance
SQL> startup nomount pfile='/opt/oracle/db/product/11.1.0/db_1/dbs/initora11g.ora';
ORA-00000: normal, successful completion
报错ORA-0000
SQL> CREATE DATABASE "ora11g"
2 MAXDATAFILES 500
3 MAXINSTANCES 8
4 MAXLOGFILES 32
5 CHARACTER SET "ZHS16GBK"
6 NATIONAL CHARACTER SET AL16UTF16
7 ARCHIVELOG
8 DATAFILE '/opt/oracle/db/oradata/ora11g/system01.dbf' size 1024M
9 EXTENT MANAGEMENT LOCAL
10 DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/opt/oracle/db/oradata/ora11g/tempts01.dbf' SIZE 1024M EXTENT MANAGEMENT LOCAL
11 UNDO TABLESPACE "UNDOTBS1" DATAFILE '/opt/oracle/db/oradata/ora11g/undotbs01.dbf' SIZE 1024M
12 LOGFILE
13 GROUP 1 (
14 '/opt/oracle/db/oradata/ora11g/redo01.rdo'
15 )SIZE 100M,
16 GROUP 2 (
17 '/opt/oracle/db/oradata/ora11g/redo02.rdo'
18 )SIZE 100M,
19 GROUP 3 (
20 '/opt/oracle/db/oradata/ora11g/redo03.rdo'
21 )SIZE 100M;
CREATE DATABASE "ora11g"
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
啥也做不了。
晕死了。也不知是数据库的问题还是OS的问题。 以前一直没碰过。 |
|