安装oracle 11g 遇到的问题ORA-01078 ORA-01034
来源:互联网 发布:java future get 超时 编辑:程序博客网 时间:2024/06/15 20:55
因为服务器挂载了磁盘阵列,磁盘阵列分了F,G两个盘
我将Oracle装在了F盘,在安装到最后一步的时候,出现了ora-01038 lrm-00109
链接运行:connect /as sysdba
在sqlplus中运行startup命令报错
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'F:\app\Administrator\product\11.2.0\dbhome_1\dbs\INITorcl.ora'
在F:\app\Administrator\product\11.2.0\dbhome_1\database下果然没有INITorcl.ora,于是我参考我自己的笔记本,拷贝了一份过去,修改相应链接和ip
INITorcl.ora文件内容如下
orcl.__db_cache_size=1442840576
orcl.__java_pool_size=16777216
orcl.__large_pool_size=16777216
orcl.__oracle_base='F:\app\Administrator'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=1308622848
orcl.__sga_target=1946157056
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=436207616
orcl.__streams_pool_size=0
*.audit_file_dest='F:\app\Administrator\admin\orcl\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='F:\app\Administrator\oradata\orcl\control01.ctl','F:\app\Administrator\flash_recovery_area\orcl\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='F:\app\Administrator\flash_recovery_area'
*.db_recovery_file_dest_size=4102029312
*.diagnostic_dest='F:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=192.168.2.199)(Port=1521)))' (这个ip是服务器的ip)
*.memory_target=3251634176
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
这个情况下运行startup命令,会报
ora-00119 ora-00130
是因为监听的host不对
这时修改监听文件:
F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
文件内容如下:
# listener.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:F:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.199)(PORT = 1521)) 【host是服务器IP】
)
)
ADR_BASE_LISTENER = F:\app\Administrator
再运行就不会报错了:
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 3240239104 bytes
Fixed Size 2180104 bytes
Variable Size 1778387960 bytes
Database Buffers 1442840576 bytes
Redo Buffers 16830464 bytes
数据库装载完毕。
数据库已经打开。
SQL> 从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
0 0
- 安装oracle 11g 遇到的问题ORA-01078 ORA-01034
- ORACLE 11G DG遇到的错误:ORA-01031,ORA-16191
- Oracle 11g RAC环境下的ORA - 19606问题
- oracle 11g R2安装报错ORA-00604及ORA-06553的原因及解决方法
- oracle 11g,ora-00257,ora-09945
- oracle 11g的ORA-28001 处理
- ORA-01078: failure in processing system parameters 问题的解决方法(oracle 11g)
- Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决(及ORA-15100和ora-1031)
- Oracle 11g参数修改错误导致数据库无法启动的处理方法.[ORA-01034,ORA-27101,ORA-00824]
- 解决连接oracle 11g报ORA-01034和ORA-27101的错误
- 解决连接Oracle 11g报ORA-01034和ORA-27101的错误
- Linux下oracle 10g的错误:ORA-01034, ORA-27101 and ORA-00600
- Oracle RAC 11g 通过SCAN连接遇到ORA-12170错误的解决办法
- oracle 11g ora-00972
- 【My Ora Life】Oracle Linux 下安装 Oracle 11g
- Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决
- Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决
- Oracle 10g ORA-12154: TNS: could not resolve the connect identifier specified 问题解决! 我同事遇到的问题。 用户名/
- 【转载】iBatis动态SQL标签用法
- oracle、sqlserver、mysql常用函数对比[to_char、to_number、to_date]
- MYSQL表分区操作错误1503解决与证明
- sql查询重复记录、删除重复记录方法大全
- 解决mysql安装是出现Error Nr2003、Error Nr1045错误
- 安装oracle 11g 遇到的问题ORA-01078 ORA-01034
- 完全卸载oracle11g步骤
- ORA-12541:TNS:无监听程序
- 日期
- axis2 webservice入门知识(JS,Java,PHP调用实例源码)
- eclipse插件实现Java调用 asmx 的Web Service
- oracle表数据用java导出为SQL文件的方法
- 【转载】MSSQL中返回刚插入记录的ID
- 启动oracle11监听器错误:本地计算机上的OracleOraDb11g_home1TNSListener服务启动后又停止了解决方案