本文共 4259 字，大约阅读时间需要 14 分钟。

??Oracle???C????

??Oracle??????????????????????????????Oracle???????????C???????

1. ??Oracle

1.1 ??swap???

???Oracle???????????swap????????????swap???????

/home/swap swap swap defaults 0 0

1.2 ????????????

??Oracle???????????????

fs.file-max = 6815744fs.aio-max-nr = 1048576kernel.shmall = 2097152kernel.shmmax= 2147483648kernel.shmmni= 4096kernel.sem = 250 32000100 128net.ipv4.ip_local_port_range= 9000 65500net.core.rmem_default= 262144net.core.rmem_max= 4194304net.core.wmem_default = 262144net.core.wmem_max= 1048576

oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle hard stack 10240

if [ $USER = "oracle" ]; then    if [ $SHELL = "/bin/ksh" ]; then        ulimit -p 16384        ulimit -n 65536    else        ulimit -u 16384 -n 65536    fifi

2. ??Oracle????

2.1 ??dba??oracle??

3. ??????????

3.1 ????

tar zxvf /tmp/oracle11g.tgz

3.2 ?????

vi /oracle/home/bin/dbstart

sqlplus / as sysdba &

[Unit]Description=Oracle RDBMS[Service]Type=simpleExecStart=/usr/bin/su - oracle -c "/oracle/home/bin/dbstart > /tmp/oracle.log"ExecReload=/usr/bin/su - oracle -c "/oracle/home/bin/dbrestart > /tmp/oracle.log"ExecStop=/usr/bin/su - oracle -c "/oracle/home/bin/dbshut > /tmp/oracle.log"RemainAfterExit=yes[Install]WantedBy=multi-user.target

4. C????Oracle

4.1 ??OCI?????

Oracle???OCI?Oracle Call Interface?????C???????????????????????

#include 
   
    #include 
    
     // ?????struct connection {    OCIEnv *env;    OCISession *session;};// ????????connection conn;if (conn.connecttodb("scott/tiger@snorcl11g", "UTF-8") != 0) {    printf("???????\n");    return -1;}// ??SQL??sqlstatement stmt(&conn);stmt.prepare("insert into goods values(:id, :name, :sal, :btime)");stmt.bindin(1, &id);stmt.bindin(2, &name);stmt.bindin(3, &sal);stmt.bindin(4, &btime);// ??SQL??if (stmt.execute() != 0) {    printf("????\n");    return -1;}// ????conn.commit();
    
   

4.2 ??Makefile??

?????C?????Makefile?

# Oracle?????-INCL = -I$(ORACLE_HOME)/rdbms/public# Oracle?????-L = -L$(ORACLE_HOME)/lib -L.# OCI?-LIBS = -lclntsh# ????CFLAGS = -g -Wno-write-strings -Wno-unused-variable# ???????all:    g++ $(CFLAGS) -o createtable createtable.cpp $(INCL) $(L) $(LIBS)# ??clean:    rm -f * .o * .exe

5. ???

5.1 ???

sqlplus / as sysdba <

5.2 ????

#include 
   
    #include 
    
     struct goods {    long id;    char name[31];    double sal;    char btime[20];};connection conn;sqlstatement stmt(&conn);// ??SQL??stmt.prepare("insert into goods values(:id, :name, :sal, :btime)");stmt.bindin(1, &id);stmt.bindin(2, &name);stmt.bindin(3, &sal);stmt.bindin(4, &btime);// ????for (int i = 1; i <= 10; ++i) {    memset(&goods, 0, sizeof(goods));    goods.id = i;    sprintf(goods.name, "??%d", i);    goods.s = i * 2.11;    memcpy(goods.btime, "2020-01-01 12:00:00", sizeof(goods.btime));    if (stmt.execute() != 0) {        printf("????\n");        return -1;    }    printf("???%d?????\n", i);}conn.commit();
    
   

???????????Oracle???????C???Oracle?????????????????????????Oracle????????????