因为服务器挂载了磁盘阵列,磁盘阵列分了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 断开
oracle安装出现01078,安装oracle 11g 遇到的问题ORA-01078 ORA-01034
最新推荐文章于 2023-08-07 11:26:44 发布