免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1905 | 回复: 3
打印 上一主题 下一主题

oracle刚安装完就启动不了,大家帮帮忙!!!!! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2006-07-12 20:16 |只看该作者 |倒序浏览
os:aix4.3 oracle8.0.5(64位)数据库安装完启动不了
这是部分错误信息,高手给指点一下

SQL> connect system/manager
ERROR:
ORA-12705: invalid or unknown NLS parameter value specified



SVRMGR>  startup
ORACLE instance started.
ORA-01012: not logged on

SVRMGR> startup force nomount
ORA-01031: insufficient privileges


SVRMGR> startup
ORA-03106: fatal two-task communication protocol error



hread 1 advanced to log sequence 194
  Current log# 2 seq# 194 mem# 0: /ora_64/oradata/oradata/epr/redoepr02.log
Sat Jul  8 11:44:24 2006
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 22306
Sat Jul  8 11:55:04 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
  processes                = 50
  shared_pool_size         = 3500000
  control_files            = /ora_64/oradata/oradata/epr/control01.ctl, /ora_64/oradata/oradata/epr/control02.ctl, /ora_64/oradata/oradata/epr/control03.ctl
  db_block_buffers         = 200
  log_buffer               = 8192
  log_checkpoint_interval  = 10000
  db_files                 = 80
  db_file_multiblock_read_count= 8
  dml_locks                = 100
  rollback_segments        = r01, r02, r03, r04
  sequence_cache_entries   = 10
  sequence_cache_hash_buckets= 10
  global_names             = TRUE
  db_name                  = epr
  ifile                    = /ora_64/home/app/oracle/admin/epr/pfile/configepr.ora
  background_dump_dest     = /ora_64/home/app/oracle/admin/epr/bdump
  user_dump_dest           = /ora_64/home/app/oracle/admin/epr/udump
  max_dump_file_size       = 10240
  core_dump_dest           = /ora_64/home/app/oracle/admin/epr/cdump
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Sat Jul  8 11:55:44 2006
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 22354
Sat Jul  8 12:02:35 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
  processes                = 50
  shared_pool_size         = 3500000
  control_files            = /ora_64/oradata/oradata/epr/control01.ctl, /ora_64/oradata/oradata/epr/control02.ctl, /ora_64/oradata/oradata/epr/control03.ctl
  db_block_buffers         = 200
  log_buffer               = 8192
  log_checkpoint_interval  = 10000
  db_files                 = 80
  db_file_multiblock_read_count= 8
  dml_locks                = 100
  rollback_segments        = r01, r02, r03, r04
  sequence_cache_entries   = 10
  sequence_cache_hash_buckets= 10
  global_names             = TRUE
  db_name                  = epr
  ifile                    = /ora_64/home/app/oracle/admin/epr/pfile/configepr.ora
  background_dump_dest     = /ora_64/home/app/oracle/admin/epr/bdump
  user_dump_dest           = /ora_64/home/app/oracle/admin/epr/udump
  max_dump_file_size       = 10240
  core_dump_dest           = /ora_64/home/app/oracle/admin/epr/cdump
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Sat Jul  8 12:03:25 2006
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 24682
Sat Jul  8 12:13:52 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
  processes                = 50
  shared_pool_size         = 3500000
  control_files            = /ora_64/oradata/oradata/epr/control01.ctl, /ora_64/oradata/oradata/epr/control02.ctl, /ora_64/oradata/oradata/epr/control03.ctl
  db_block_buffers         = 200
  log_buffer               = 8192
  log_checkpoint_interval  = 10000
  db_files                 = 80
  db_file_multiblock_read_count= 8
  dml_locks                = 100
  rollback_segments        = r01, r02, r03, r04
  sequence_cache_entries   = 10
  sequence_cache_hash_buckets= 10
  global_names             = TRUE
  db_name                  = epr
  ifile                    = /ora_64/home/app/oracle/admin/epr/pfile/configepr.ora
  background_dump_dest     = /ora_64/home/app/oracle/admin/epr/bdump
  user_dump_dest           = /ora_64/home/app/oracle/admin/epr/udump
  max_dump_file_size       = 10240
  core_dump_dest           = /ora_64/home/app/oracle/admin/epr/cdump
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Sat Jul  8 12:15:55 2006
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 22388
Sat Jul  8 12:28:34 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
  processes                = 50
  shared_pool_size         = 3500000
  control_files            = /ora_64/oradata/oradata/epr/control01.ctl, /ora_64/oradata/oradata/epr/control02.ctl, /ora_64/oradata/oradata/epr/control03.ctl
  db_block_buffers         = 200
  log_buffer               = 8192
  log_checkpoint_interval  = 10000
  db_files                 = 80
  db_file_multiblock_read_count= 8
  dml_locks                = 100
  rollback_segments        = r01, r02, r03, r04
  sequence_cache_entries   = 10
  sequence_cache_hash_buckets= 10
  global_names             = TRUE
  db_name                  = epr
  ifile                    = /ora_64/home/app/oracle/admin/epr/pfile/configepr.ora
  background_dump_dest     = /ora_64/home/app/oracle/admin/epr/bdump
  user_dump_dest           = /ora_64/home/app/oracle/admin/epr/udump
  max_dump_file_size       = 10240
  core_dump_dest           = /ora_64/home/app/oracle/admin/epr/cdump
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Sat Jul  8 12:28:59 2006
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 21542
Sat Jul  8 12:37:43 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
  processes                = 50
  shared_pool_size         = 3500000
  control_files            = /ora_64/oradata/oradata/epr/control01.ctl, /ora_64/oradata/oradata/epr/control02.ctl, /ora_64/oradata/oradata/epr/control03.ctl
  db_block_buffers         = 200
  log_buffer               = 8192
  log_checkpoint_interval  = 10000
  db_files                 = 80
  db_file_multiblock_read_count= 8
  dml_locks                = 100
  rollback_segments        = r01, r02, r03, r04
  sequence_cache_entries   = 10
  sequence_cache_hash_buckets= 10
  global_names             = TRUE
  db_name                  = epr
  ifile                    = /ora_64/home/app/oracle/admin/epr/pfile/configepr.ora
  background_dump_dest     = /ora_64/home/app/oracle/admin/epr/bdump
  user_dump_dest           = /ora_64/home/app/oracle/admin/epr/udump
  max_dump_file_size       = 10240
  core_dump_dest           = /ora_64/home/app/oracle/admin/epr/cdump
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Sat Jul  8 12:38:13 2006
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 21554
Sat Jul  8 12:47:26 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
  processes                = 50
  shared_pool_size         = 3500000
  control_files            = /ora_64/oradata/oradata/epr/control01.ctl, /ora_64/oradata/oradata/epr/control02.ctl, /ora_64/oradata/oradata/epr/control03.ctl
  db_block_buffers         = 200
  log_buffer               = 8192
  log_checkpoint_interval  = 10000
  db_files                 = 80
  db_file_multiblock_read_count= 8
  dml_locks                = 100
  rollback_segments        = r01, r02, r03, r04
  sequence_cache_entries   = 10
  sequence_cache_hash_buckets= 10
  global_names             = TRUE
  db_name                  = epr
  ifile                    = /ora_64/home/app/oracle/admin/epr/pfile/configepr.ora
  background_dump_dest     = /ora_64/home/app/oracle/admin/epr/bdump
  user_dump_dest           = /ora_64/home/app/oracle/admin/epr/udump
  max_dump_file_size       = 10240
  core_dump_dest           = /ora_64/home/app/oracle/admin/epr/cdump
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7

论坛徽章:
0
2 [报告]
发表于 2006-07-12 20:33 |只看该作者
invalid or unknown NLS parameter value specified
查看你的NLS_LANGUAGE是否设置正确????

论坛徽章:
0
3 [报告]
发表于 2006-07-13 09:24 |只看该作者
if [ -s "$MAIL" ]           # This is at Shell startup.  In normal
then echo "$MAILMSG"        # operation, the Shell checks
fi                          # periodically.
ORACLE_BASE=/ora_64/home/app/oracle
ORACLE_HOME=/ora_64/home/app/oracle/product/8.0.5
ORACLE_OWNER=ora_64
ORACLE_SID=epr
ORACLE_TERM=vt100
LD_LIBRARY_PATH=/ora_64/home/app/oracle/product/8.0.5/lib:/ora_64/home/app/oracle/product/8.0.5/network/lib
export ORACLE_BASE ORACLE_HOME ORACLE_OWNER ORACLE_SID ORACLE_TERM LD_LIBRARY_PATH
DISPLAY=182.22.22.5:0.0
NLS_LANG=american_america.zhs16cgb231280
ORA_NLS33=$ORACLE_Home/ocommon/nls/admin/data
TNS_ADMIN=$ORACLE_HOME/network/admin
LIBPATH=$ORACLE_HOME/lib
export DISPLAY ORA_NLS33 NLS_LANG TNS_ADMIN
umask 022
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucbHOME/bin:/usr/bin/X11:/sbinPATHORACLE_HOME/bin:.;export PATH
LINK_CNTRL=L_PTHREADS_D7;export LINK_CNTRL
OBJECT_MODE=32;export OBJECT

这是我设置的环境变量,我觉得NLS_LANG=american_america.zhs16cgb231280这个不应该没有问题吧
不知道其他的环境变量是否有问题
而且我在打补丁时,需要我输入$ORACLE_LINK不知道这个环境变量应该怎样设置,我设置成$ORACLE_HOME/lib,最后link不成功
在线等,各位老大帮帮忙!!!!!!!!!

论坛徽章:
0
4 [报告]
发表于 2006-07-13 19:07 |只看该作者
谢谢了,我解决了ORA_NLS33设置错了
改过来就好了
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP