ora-01092错误怎么解决?
本帖最后由 loushuibazi 于 2013-10-15 13:40:31 编辑
我是冷备份恢复数据。
startup upgrade
这种也启动不了,错误
ora-24324,ora-01041
这两个错误有解决方法说是监听的实例信息没找到,重新登录就好了,可是我重启服务器都没好
错误日志
Tue Oct 15 13:23:36 2013
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
The value of parameter db_cache_size is below the required minimum
The new value is 4MB multiplied by the number of cpus
Tue Oct 15 13:23:36 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = F:\ORACLEDATA\ORADATA\GIS\CONTROL01.CTL, F:\ORACLEDATA\ORADATA\GIS\CONTROL02.CTL, F:\ORACLEDATA\ORADATA\GIS\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 33554432
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.1.0\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=GISXDB)
job_queue_processes = 10
background_dump_dest = C:\ORACLE\PRODUCT\10.1.0\ADMIN\GIS\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.1.0\ADMIN\GIS\UDUMP
core_dump_dest &nbs