安装错误,帮忙看看
aix下装ORACLE变量export DISPLAY=IPADD:0.0也加了,就是还是出不来安装界面。很郁闷!xhost + ORACLE和ROOT全无法打开$ xhost +1356-200 xhost unable to open display "10.1.48.243:0.0"# xhost +1356-200 xh...
关于ZBK转换成UTF8
现在有个生产环境的数据库,要迁移到另一个应用的ORACLE10G中,数据要由GBK转成UTF8的,但有些数据无法进入。大家谁有这方面的经验和方法?麻烦给讲讲,提供下吧。谢谢!...
关于HP下安装的问题?
在我配置的.profile中如下:# @(#)B11.23_LR # Default user .profile file (/usr/bin/sh initialization).# Set up the terminal: if [ "$T...
hp unix 1123 kerent设置?
现在的机器是4CPU 8G内存Parameter Recommended Formula or Valueksi_alloc_max executable_stack max_thread_proc maxdsiz maxdsiz_64bit maxssiz maxssiz_64bit maxuprc msgmap msgmni msgseg 这些...
hp unix 1123 oracle10.2 补丁?
大家谁有hp unix 1123 oracle10.2 的补丁包?麻烦给我一个,谢谢!!!– PHCO 32426: Reboot(1M) cumulative patch– PHKL 32646: wsio.h header file patch– PHKL 32632: Message Signaled Interrupts (MSI an...
NVARCHAR2字段超长问题:ORA-00910: specified length too long for its datatype
NVARCHAR2字段超长问题:ORA-00910: specified length too long for its datatype前几天在IMP的时候遇到了个问题:IMP-00017: following statement failed with ORACLE error 910: "CREATE TABLE "T_CSL_DYNAITEM...
NVARCHAR2字符限制问题?
NVARCHAR2在SOLARIS_X86_64的版本中限制是2000可查了最大限制为4000,这种限制是否和环境版本有关呢?现在正式环境liinux_x86_64的10g,支持4000.测试环境的没办法把正式的数据导进去,曾经试验过吧正式的从4000...
遇到个问题,BUDU没找到,请帮忙分析下原因?
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.02.01 via conventional path...
sga_target过小的问题?
10G环境下修改:alter system set sga_target = 800M scope=both;之后:数据库启动失败:ORA-00824: cannot set sga_target due to existing internal settings, see alert log for more information改为:SQ...
安装配置问题?
PATH中改如何加载?SOLARISX86下装的10G但安装后起不来,通过ENV后发现是PATH的问题,不知道改怎么配置了?-bash-3.00$ envHZ=LC_MONETARY=en_CA.UTF-8SHELL=/usr/bin/bashTERM=dttermLC_NUMERIC=en_CA.UTF-...
SOLARIS安装10G 无法启动
刚刚在SOLARIS10G X86下装的10G,安装后时没有一点错误。但安装后连LSNRCTL也起不来,非常奇怪。大家遇到过这种问题吗?是什么原因呢?怎么解决????...
SOLARIS10 X86下安装ora10g错误
SOLARIS10 X86下安装ora10g错误:OUI-10151:There was an error while loading library passwordQuenes麻烦问下这是什么情况??????
求10g中回滚的命令
没看归档,麻烦问下回滚操作可以实现吗?麻烦给两个回滚的命令吧!急!谢谢了!
exp问题?
麻烦给点意见同建议,谢谢!$ exp neam/password full=y file=/xxx/xxx/xxx/x.dmpEXP-00008: ORACLE error 4031 encounteredORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/uti...
启动多实例问题???
bash-3.00$ export ORACLE_SID=ora10gbash-3.00$ sqlplus '/as sysdba'SQL*Plus: Release 10.2.0.2.0 - Production on Tue Apr 17 19:04:20 2007Copyright (c) 1982, 2005, Oracle. All Rights Rese...
ORA-01031: insufficient privileges
ORA-01031: insufficient privileges现在连SQLPLUS也上不去了,麻烦大家给点意见谢谢!
关于监听的问题???
更改了IP后重新配置了还不成,索性就DEL了重新建,但总是报以下这个错误,即使该成IP地址也不成。总是适配器错误,很郁闷!麻烦给点提示吧,谢谢了!Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=OR...
IMP0003同00019问题?!!!
帮忙看下,谢谢!Column 2 USER FLAVOR FUNCTIONIMP-00019: row rejected due to ORACLE error 1IMP-00003: ORACLE error 1 encounteredORA-00001: unique constraint (SYSTEM.REPCAT$_RESOL_METHOD_PK) violat...
ORA-01157急!!!!谢谢了!!
帮看下是什么原因?该怎么恢复?急!!!!谢谢了!SQL> startupORACLE instance started.Total System Global Area 687865856 bytesFixed Size &n...
多实例问题?
麻烦问下,数据库多个实例,怎么进入SQLPLUS正常启动和关闭相应的实例呀?谢谢!