Sir,
I am written a pro * C program. Which is used to fetch around 100,000 from the database. This program is working perfectly in one machine. In another machine, while I am trying to connect to database, it gives the follwing two error messages.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does no
My connect function is as follows:
/* if flag = 0, then Connect to the Default DATABASE, otherwise connect to "oracle" database */
int open_ora_database(char *oracle_db_con,char ora_dbParms [],int flag) {
if(flag == 0) {
EXEC SQL CONNECT :oracle_dbParms IDENTIFIED BY :oracle_dbParms; /* Default connection */
} else if (flag==1){
EXEC SQL CONNECT :oracle_dbParms IDENTIFIED BY :oracle_dbParms AT : oracle_db_con USING :oracle_dbParms;
} else {
printf("Error Invalid Connection flag value ..\n");
return -1;
}
if(sqlca.sqlcode < 0) {
printf("Error Failed to Connect Oracle to Database\n");
printf("% .70s \n", sqlca.sqlerrm.sqlerrmc);
return -2;
} else {
printf("Oracle Connection is uccessfu...\n\n",oracle_db_con);
return 0;
}
}
Please help me. Where shud I make changes This is Urgent for me.
With Regards.
Chinmaya