IBM_TXSeries_CICS Connect to Oracle troubleshooting Notes

下午在配置cics 连接oracle时,在编译oracle1pc.mk遇到报错。下面为排障过程:

1、执行make -f oracle1pc.mk oracle 遇到报错:如下所示:

PCC-S-02201, Encountered the symbol “size_t” when expecting one of the following
:

… auto, char, const, double, enum, float, int, long,
ulong_varchar, OCIBFileLocator OCIBlobLocator,
OCIClobLocator, OCIDateTime, OCIExtProcContext, OCIInterval,
OCIRowid, OCIDate, OCINumber, OCIRaw, OCIString, register,
short, signed, sql_context, sql_cursor, static, struct,
union, unsigned, utext, uvarchar, varchar, void, volatile,
a typedef name, exec oracle, exec oracle begin, exec,
exec sql, exec sql begin, exec sql type, exec sql var,
The symbol “exec,” was substituted for “size_t” to continue.

5/usr/include/stdio.h:
715, /usr/include/stdio.h
extern size_t fwrite (const void *__restrict __ptr, size_t __size,
1
PCC-S-02201, Encountered the symbol “extern” when expecting one of the following
:

, )

0, oracle1pc.pc
PCC-F-02102, C Ԥʱ,

make: *** [oracle1pc.c] Error 1

2、确认profile 文件,oracle的环境变量设置正确:

root@zymh Oracle]# vi /etc/profile

阅读更多

Centos Linux oracle11g客户端安装笔记实录

工作需要在Linux上部署Oracle客户端。

网上有很多教程,我也看了很多,好多不是写的很清楚,主要留给自己做笔记 .
1、下载对应rpm文件,rpm可以从oracle官网下载。

2、把下载好的rpm文件上传到Linux
3、执行安装命令

[root@ibmsyss oracle]# rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

准备中…                          ################################# [100%]

正在升级/安装…

1:oracle-instantclient11.2-basic-11################################# [100%]

[root@ibmsyss oracle]# rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

准备中…                          ################################# [100%]

正在升级/安装…

1:oracle-instantclient11.2-sqlplus-################################# [100%]

[root@ibmsyss oracle]#

4、上传tnsnames.ora文件,Oracle客户端默认安装在/usr/lib下
/usr/lib/oracle
第一次安装缺少文件夹,需要在client64下创建文件夹network/admin,再把tnsn文件上传上去

5、设置环境变量,因项目用户是root用户所以不需要创建Oracle用户

(1)编辑root用户下的profile文件

[root@ibmsyss oracle]# vi /etc/profile

(2)在文件的最后添加以下内容

export ORACLE_HOME=/usr/lib/oracle/11.2/client64/

export LD_LIBRARY_PATH=:$ORACLE_HOME/lib:/usr/local/lib:$LD_LIBRARY_PATH:.

export TNS_ADMIN=$ORACLE_HOME

export PATH=$PATH:$ORACLE_HOME/bin:

export NLS_LANG=”SIMPLIFIED CHINESE_CHINA.ZHS16GBK”

(3)执行source命令,使配置文件生效.

[root@ibmsyss oracle]# source /etc/profile

好,到这里就结束.