我的系统是 RHEL5 装oracle11g客户端 我有N个程序,在系统启动后,手工执行能正常工作,但是由于程序必须24小时不间断执行,所以我想把程序放在/etc/inittab里,让系统自动执行并且即使程序异常推出系统重启改程序 /etc/inittab设置如下: #beijin js define 24:235:respawn:/home/oracle/jsxq/code/shell/alarmadapter.sh alarmadapter 当程序启动后,连接数据库时提示“error while trying to retrieve text for error ora-12...
error while trying to retrieve text for error ora-12154 请问上面的错误如何解决?谢谢
我用php通过odbc访问oracle。 我用tsnping test 6 这个命令可以OK!呀 哭求!!
我用exp备份了一个用户的数据,用 imp导入,都是9i 导入好像倒是成功了,但是总会出这个报错: IMP-00003: oraCLE error 942 encountered ora-00942: table or view does not exist IMP-00017: following statement failed with oraCLE error 942: "CREATE DIMENSION "PRODUCTS_DIM" LEVEL "PRODUCT" IS ("PRODUCTS"."PROD_ID") L" "EVEL "SUBCATEGORY" IS ("PRODUCTS"."PROD_SUBCATEGORY") LEVEL "CATEGORY" IS (" ""PRODUCTS"....
有一个简单的脚本如下:
没有while循环的时候能工作, 加上while循环后就报错[code]#!/bin/ksh
while :
do
sqlplus -s abc/abc@abc <
大家好 当我在客户端有ie,用isql *plus 链接数据库时,提示如下错误,请帮忙分析下,是什么原因,谢谢 oracle 主机 Solaris 10 oracle 版本 10.2 客户端 : windows pc error - ora-12514: TNS:listener does not currently know of service requested in connect descriptor tnsnames.ora 文件内容 EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = zch08view19)(PORT = 1521)(...
数据库oracle Database 10g Enterprise Edition Release 10.1.0.4.0. 在alert_ssp1.log有很多ora-00600 error,如下: "errors in file /u01/app/oracle/admin/ssp/bdump/ssp1_s001_729.trc: ora-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []" 在"ssp1_s001_729.trc"文件中,如下报错: "ora-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], ...
我的temp表空间有65 gb,现在占用率已经是100%了,我想增大,结果就出现了ora-01144错误。 我知道这是数据库文件的值达到了最大。 db_block_size * 4194303 现在我想知道: 1. 4194303 是什么意思? 2.这样的情况如果我向这个表空间增一个新的数据库文件可以吗?--------------------- 3. 重建temp 表空间,步骤如下: 1)create temporary tablespace TEMP2 TEMPFILE '/home2/oracle/oradata/sysmon/te...
Hi, i'm very sorry for typing English, this Chinese input method cannot work properly now. I often encounter this error message: ora-04030, I can not resolve this issue completely. Surf the net to search the solution, but their answer are all the same: tuning the memory using (SGA, PGA): decrease the amount of the memory requirement. Now the AIX BOX i'm using have the 16G main memory, the main ...