aix环境装oracle客户端,AIX安装Oracle 11g客户端、Pro*C/C++编译环境

将解压出来的instantclient_11_1目录整个上传至AIX用户目录下。

添加ORACLE_HOME等环境变量。

在.profile中添加如下内容：

export ORACLE_HOME=$HOME/instantclient_11_1

export ORACLE_SID=orcl

export LD_LIBRARY_PATH=$ORACLE_HOME:${LD_LIBRARY_PATH}

export PATH=$ORACLE_HOME:$ORACLE_HOME/sdk:$PATH

建立TNS文件。

mkdir -p $ORACLE_HOME/network/admin

touch $ORACLE_HOME/ network/admin/tnsnames.ora

编辑tnsnames.ora内容大致如下：

orcl =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.1.2.202)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

测试

sqlplus unionkms@orcl

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Feb 23 16:41:07 2011

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Enter password:

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> desc branch;

Name Null? Type

----------------------------------------- -------- ----------------------------

UNID NOT NULL CHAR(40)

UNBRANCHTYPEID NOT NULL CHAR(40)

UNBRANCHFIELD NUMBER(38)

UNBRANCHID CHAR(50)

UNKMCID CHAR(40)

UNIDOFMNGSVR CHAR(40)

UNSECUSERVICESVRID CHAR(40)

UNMONITORSVRID CHAR(40)

UNMANAGER CHAR(128)

UNPHONE CHAR(128)

UNFAX CHAR(128)

UNEMAIL CHAR(128)

UNHTTPADDR VARCHAR2(256)

UNREMARK CHAR(128)

UNINPUTTELLER CHAR(20)

UNINPUTDATE CHAR(8)

UNINPUTTIME CHAR(6)

UNUPDATETELLER CHAR(20)

UNUPDATEDATE CHAR(8)

UNUPDATETIME CHAR(6)

SQL>

Pro*C文件pc_test中。

pcscfg.cfg :

sys_include=(/u2/chenlong/instantclient_11_1/sdk/include,/usr/include)

ltype=short

define=__64BIT__

define=_IBM_C

define=_LONG_LONG

a1.pc :

#include

#include

#include

#include "sqlca.h"

int main(void)

{

EXEC SQL INCLUDE sqlca;

EXEC SQL BEGIN DECLARE SECTION;

char *user = "unionkms";

char *passwd = "unionkms";

char *db = "orcl";

EXEC SQL END DECLARE SECTION;

EXEC SQL CONNECT :user IDENTIFIED BY :passwd USING :db;

if (sqlca.sqlcode == 0)

printf("connect success!\n");

else

printf("connect fail!\n");

return 0;

}

makefile :

all: a1.pc

proc config=pcscfg.cfg iname=a1.pc

cc -q64 -I /u2/chenlong/instantclient_11_1/sdk/include/ -c a1.c

cc -q64 -L/u2/chenlong/instantclient_11_1/ -lclntsh -o a1 a1.o

clean:

rm a1.lis a1.o

(转载时请注明作者和出处。未经许可，请勿用于商业用途)

更多文章请访问我的Blog: http://www.cnblogs.com/logicbaby