nagios插件之监控呼叫量（pro*c访问oracle）

最新推荐文章于 2022-01-07 12:20:01 发布
最新推荐文章于 2022-01-07 12:20:01 发布
阅读量699 收藏 1
点赞数
分类专栏： c基础
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ccjsj1/article/details/19398161
版权

PRO*C是Oracle提供的应用程序专用开发工具，它以C语言为宿主语言，能在C程序中嵌入SQL语句，进行数据库操作。

将.pc文件转文.c文件
proc MODE=ORACLE UNSAFE_NULL=YES check_oracle.pc

编译.c文件
gcc -L /home/oracle/product/OraHome/lib -l clntsh -o check_oracle check_oracle.c

vi check_oracle.pc

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <time.h>
#include "/home/oracle/product/OraHome/precomp/public/sqlca.h"

#define OK       0
#define WARNING  1
#define CRITICAL 2
#define UNKNOWN  3

#define LEN 1023
#define AVGTALK_LEN 64

EXEC SQL INCLUDE SQLCA;

time_t timestamp;
struct tm *tp;

char date_start[LEN];
char date_end[LEN];

/*
struct avg_talk_t {
	char ICall_Chinese[AVGTALK_LEN];
	char ICall_English[AVGTALK_LEN];
	char RemoteService[AVGTALK_LEN];
};
*/

void sql_error(char *msg) {
        printf("\n%s,%ld,%s\n", msg,sqlca.sqlcode,(char *)sqlca.sqlerrm.sqlerrmc);

	EXEC SQL ROLLBACK RELEASE;
	
	exit(-1);
}

int before_x_minute_range(int minutes) {
	int hour,minute;
	int minute_a,minute_b;
	int start,end;

	time_t time_tmp;

	hour=tp->tm_hour;
	minute=tp->tm_min;

	minute_a=minute/10;
	minute_b=minute%10;

	if(minutes==5) {
		if(minute<10) {
			if(hour==0 && minute<5) {
			//	printf("======\n");
			//	return 0;

				time_tmp=timestamp-86400;
                                tp=localtime(&time_tmp);
                                hour=23;
                                start=55;
                                end=59;
			}
			else if(minute_b<5) {
			//	start=minute_a-5;
			//	end=minute_a;
				hour=hour-1;
				start=55;
				end=59;
			}
			else if(minute_b>=5) {
				start=minute_a*10;
				end=minute_a*10+4;
			}
		}
		else {
			if(minute_b<5) {
				start=minute_a*10-5;
				end=minute_a*10-1;
			}
			else if(minute_b>=5) {
				start=minute_a*10;
				end=minute_a*10+4;
			}
		}
	}
	else if(minutes==10) {
                        if(hour==0 && minute<10) {
			//	printf("1111111111111\n");
                        //	printf("======\n");
                        //	return 0;

				time_tmp=timestamp-86400;
                                tp=localtime(&time_tmp);
                                hour=23;
                                start=50;
                                end=59;
                        }
                        else if(minute_a==0) {
			//	printf("222222222222\n");
				hour=hour-1;
                                start=50;
                                end=59;
                        }
                        else if(minute_a>=1) {
			//	printf("333333333333333\n");
                                start=minute_a*10-10;
                                end=minute_a*10-1;
                        }
	}
        else if(minutes==30) {
                        if(hour==0 && minute<30) {
			//	printf("1111111111111\n");
                        //	printf("======\n");
                        //	return 0;

				time_tmp=timestamp-86400;
                                tp=localtime(&time_tmp);
                                hour=23;
                                start=30;
                                end=59;
			}
                        else if(minute_a<3) {
                        //	printf("222222222222\n");
                                hour=hour-1;
                                start=30;
                                end=59;
                        }
                        else if(minute_a>=3) {
                        //	printf("333333333333333\n");
			/*	
			//	old algorithm before 30 minute
                                start=minute_a*10-30;
                                end=minute_a*10-1;
			*/

				start=0;
				end=29;
                        }
        }
	else if(minutes==60) {
		if(hour>0) {
			hour=hour-1;
			start=0;
			end=59;
		}
		else {
			time_tmp=timestamp-86400;
			tp=localtime(&time_tmp);
			hour=23;
			start=0;
			end=59;
		}
	}


//	printf("date=%s,start=%d,end=%d\n",date,start,end);

	sprintf(date_start,"%d-%02d-%02d %02d-%02d-00",1900+tp->tm_year,(1+tp->tm_mon),tp->tm_mday,hour,start);
	sprintf(date_end,"%d-%02d-%02d %02d-%02d-59",1900+tp->tm_year,(1+tp->tm_mon),tp->tm_mday,hour,end);

//	printf("date_start=%s\n",date_start);
//	printf("date_end=%s\n",date_end);

	return 0;
}

int main(void) {
	int ret;

	// set env
	setenv("ORACLE_BASE","/home/oracle",0);
	setenv("ORACLE_HOME","/home/oracle/product/OraHome",0);
	setenv("ORACLE_SID","bmwdata",0);
	setenv("ORACLE_TERM","vt100",0);
	setenv("PATH","$ORACLE_HOME/bin:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH:/usr/bin:/usr/sbin",0);
	setenv("LD_LIBRARY_PATH","$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib",0);
	setenv("CLASSPATH","$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib:CLASSPATH",0);
	setenv("ORA_NLS33","$ORACLE_HOME/nls/admin/data",0);
/*
*/

//	EXEC SQL WHENEVER SQLERROR DO sql_error("ORACLE ERROR: ");


	EXEC SQL BEGIN DECLARE SECTION;


	char conn_db[LEN]="cc_prod/cc_prod@bmwdata";

	int icall_all=0;
	int icall_all_data_voice=0;
	int icall_all_data_only=0;
	int icall_all_voice_only=0;

	int icall_chinese_all=0;
	int icall_chinese_data_voice=0;
	int icall_chinese_data_only=0;
	int icall_chinese_voice_only=0;
	

	int icall_english_all=0;
	int icall_english_data_voice=0;
	int icall_english_data_only=0;
	int icall_english_voice_only=0;

	int remote_service=0;

	int before_5_minute_call_count=0;
	int before_30_minute_call_count=0;
	int before_60_minute_call_count=0;

//	int before_10_minute_talk;
//	float before_10_minute_i_chinese_talk;
//	float before_30_minute_i_chinese_talk;

	int before_5_minute_i_chinese_talk_avg=0;
	int before_5_minute_i_english_talk_avg=0;

	int before_30_minute_i_chinese_talk_avg=0;
	int before_30_minute_i_english_talk_avg=0;

	int before_60_minute_i_chinese_talk_avg=0;
	int before_60_minute_i_english_talk_avg=0;

	char date[LEN];

//	struct avg_talk_t avg_talk;

	int exitstatus=OK;
	char *exit_status[4]={"OK","WARNING","CRITICAL","UNKNOWN"};

	char status_information[LEN];
	char performance_data[LEN];

	EXEC SQL END DECLARE SECTION;

	EXEC SQL CONNECT :conn_db;

	if(sqlca.sqlcode!=0) {
		printf("%s",sqlca.sqlerrm.sqlerrmc);
		return -1;
	}

	timestamp=time(NULL);
	tp=localtime(×tamp);

	sprintf(date,"%d-%02d-%02d",1900+tp->tm_year,(1+tp->tm_mon),tp->tm_mday);
//	printf("date=%s\n",date);


/*
	if(sqlca.sqlcode==0) {
		printf("Connect oracle success...\n");
		
	}
	else {
		printf("%s",sqlca.sqlerrm.sqlerrmc);
		return -1;
	}
*/


	//------------------------------------------------------
	//icall_all
	EXEC SQL SELECT count(*) INTO :icall_all FROM calldata t where to_char(time_eventdata_request,'yyyy-mm-dd')=:date and servicetype='I-Call';

	//icall_all_have_data_voice
	EXEC SQL SELECT count(*) INTO :icall_all_data_voice FROM calldata t where to_char(time_eventdata_request,'yyyy-mm-dd')=:date and servicetype='I-Call' and callfrom is not null;

	//icall_all_data_only
	EXEC SQL SELECT count(*) INTO :icall_all_data_only FROM calldata t where to_char(time_eventdata_request,'yyyy-mm-dd')=:date and servicetype='I-Call' and callfrom is null;

	//icall_all_voice_only
	EXEC SQL SELECT count(*) INTO :icall_all_voice_only FROM calldata t where to_char(time_callstart,'yyyy-mm-dd')=:date and servicetype='I-Call' and time_eventdata_request is null;


	//-----------------------------------------------------
	//icall_chinese
	EXEC SQL SELECT count(*) INTO :icall_chinese_all FROM calldata t where to_char(time_eventdata_request,'yyyy-mm-dd')=:date and queueid='ICall_Chinese';

	//icall_chinese_have_data_voice
	EXEC SQL SELECT count(*) INTO :icall_chinese_data_voice FROM calldata t where to_char(time_eventdata_request,'yyyy-mm-dd')=:date and queueid='ICall_Chinese' and callfrom is not null;

	//icall_chinese_data_only
	EXEC SQL SELECT count(*) INTO :icall_chinese_data_only FROM calldata t where to_char(time_eventdata_request,'yyyy-mm-dd')=:date and queueid='ICall_Chinese' and callfrom is null;

	//icall_chinese_voice_only
	EXEC SQL SELECT count(*) INTO :icall_chinese_voice_only FROM calldata t where to_char(time_callstart,'yyyy-mm-dd')=:date and queueid='ICall_Chinese' and time_eventdata_request is null;


	//-----------------------------------------------------
	//icall_english
	EXEC SQL SELECT count(*) INTO :icall_english_all FROM calldata t where to_char(time_eventdata_request,'yyyy-mm-dd')=:date and queueid='ICall_English';

	//icall_english_have_data_voice
	EXEC SQL SELECT count(*) INTO :icall_english_data_voice FROM calldata t where to_char(time_eventdata_request,'yyyy-mm-dd')=:date and queueid='ICall_English' and callfrom is not null;

	//icall_english_data_only
	EXEC SQL SELECT count(*) INTO :icall_english_data_only FROM calldata t where to_char(time_eventdata_request,'yyyy-mm-dd')=:date and queueid='ICall_English' and callfrom is null;

	//icall_english_voice_only
	EXEC SQL SELECT count(*) INTO :icall_english_voice_only FROM calldata t where to_char(time_callstart,'yyyy-mm-dd')=:date and queueid='ICall_English' and time_eventdata_request is null;


	//----------------------------------------------------
	//remote_service
	EXEC SQL SELECT count(*) INTO :remote_service FROM calldata t where to_char(time_callstart,'yyyy-mm-dd')=:date and servicetype='RemoteService';


/*
	//printf
	printf("icall_all=%d\n",icall_all);
	printf("icall_all_data_voice=%d\n",icall_all_data_voice);
	printf("icall_all_data_only=%d\n",icall_all_data_only);
	printf("icall_all_voice_only=%d\n",icall_all_voice_only);


	printf("icall_chinese_all=%d\n",icall_chinese_all);
	printf("icall_chinese_data_voice=%d\n",icall_chinese_data_voice);
	printf("icall_chinese_data_only=%d\n",icall_chinese_data_only);
	printf("icall_chinese_voice_only=%d\n",icall_chinese_voice_only);

	printf("icall_english_all=%d\n",icall_english_all);
	printf("icall_english_data_voice=%d\n",icall_english_data_voice);
	printf("icall_english_data_only=%d\n",icall_english_data_only);
	printf("icall_english_voice_only=%d\n",icall_english_voice_only);

	printf("remote_service=%d\n",remote_service);
	//
*/

	//before_5_minute_call_count
	ret=before_x_minute_range(5);

	EXEC SQL SELECT count(*) INTO :before_5_minute_call_count FROM calldata where to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')>=:date_start and to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')<=:date_end;

//	printf("before_5_minute_call_count=%d\n\n",before_5_minute_call_count);

	//before_5_minute_icall_talk_avg_chinese

	EXEC SQL SELECT sum((time_callend-time_callconnect)*24*3600)/count(*) INTO :before_5_minute_i_chinese_talk_avg from calldata t where to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')>=:date_start and to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')<=:date_end and queueid='ICall_Chinese'; //is not null group by queueid;
//	printf("10 avg ok.\n");

//	printf("before_5_minute_i_chinese_talk=%d\n\n",before_5_minute_i_chinese_talk_avg);


	//before_5_minute_icall_talk_avg_english

	EXEC SQL SELECT sum((time_callend-time_callconnect)*24*3600)/count(*) INTO :before_5_minute_i_english_talk_avg from calldata t where to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')>=:date_start and to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')<=:date_end and queueid='ICall_English'; //is not null group by queueid;
//	printf("10 avg ok.\n");

//	printf("before_5_minute_i_english_talk=%d\n\n",before_5_minute_i_english_talk_avg);
	//------------------------

	//before_30_minute_call_count
	ret=before_x_minute_range(30);

	EXEC SQL SELECT count(*) INTO :before_30_minute_call_count FROM calldata where to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')>=:date_start and to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')<=:date_end;

//	printf("before_30_minute_call_count=%d\n\n",before_30_minute_call_count);

	//before_30_minute_talk_avg_chinese

	EXEC SQL SELECT sum((time_callend-time_callconnect)*24*3600)/count(*) INTO :before_30_minute_i_chinese_talk_avg from calldata t where to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')>=:date_start and to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')<=:date_end and queueid='ICall_Chinese'; //is not null group by queueid;
//	printf("30 avg ok.\n");

//	printf("before_30_minute_i_chinese_talk=%d\n\n",before_30_minute_i_chinese_talk_avg);

	//before_30_minute_talk_avg_english

	EXEC SQL SELECT sum((time_callend-time_callconnect)*24*3600)/count(*) INTO :before_30_minute_i_english_talk_avg from calldata t where to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')>=:date_start and to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')<=:date_end and queueid='ICall_English'; //is not null group by queueid;
//	printf("30 avg ok.\n");

//	printf("before_30_minute_i_english_talk=%d\n\n",before_30_minute_i_english_talk_avg);
	//------------------------

	//--------------------------------------
	//before_60_minute_call_count
	ret=before_x_minute_range(60);

	EXEC SQL SELECT count(*) INTO :before_60_minute_call_count FROM calldata where to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')>=:date_start and to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')<=:date_end;

//	printf("before_60_minute_call_count=%d\n\n",before_60_minute_call_count);

	//before_60_minute_talk_avg_chinese

	EXEC SQL SELECT sum((time_callend-time_callconnect)*24*3600)/count(*) INTO :before_60_minute_i_chinese_talk_avg from calldata t where to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')>=:date_start and to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')<=:date_end and queueid='ICall_Chinese'; //is not null group by queueid;
//	printf("60 avg ok.\n");

//	printf("before_60_minute_i_chinese_talk=%d\n\n",before_60_minute_i_chinese_talk_avg);

	//before_60_minute_talk_avg_english

	EXEC SQL SELECT sum((time_callend-time_callconnect)*24*3600)/count(*) INTO :before_60_minute_i_english_talk_avg from calldata t where to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')>=:date_start and to_char(time_callstart,'yyyy-mm-dd hh24-mi-ss')<=:date_end and queueid='ICall_English'; //is not null group by queueid;
//	printf("60 avg ok.\n");

//	printf("before_60_minute_i_english_talk=%d\n\n",before_60_minute_i_english_talk_avg);

	//---------------------------------------------


	sprintf(status_information,"current icall_all=%d, icall_all_data_voice=%d, icall_all_data_only=%d, icall_all_voice_only=%d, icall_chinese_all=%d,icall_chinese_data_voice=%d, icall_chinese_data_only=%d, icall_chinese_voice_only=%d, icall_english_all=%d, icall_english_data_voice=%d, icall_english_data_only=%d, icall_english_voice_only=%d, remote_service=%d, 5_minute_before_call_count=%d, 30_minute_before_call_count=%d, 60_minute_before_call_count=%d, 5_minute_i_cn_talk_avg=%d, 5_minute_i_en_talk_avg=%d, 30_minute_i_cn_talk_avg=%d, 30_minute_i_en_talk_avg=%d, 60_minute_i_cn_talk_avg=%d, 60_minute_i_en_talk_avg=%d", icall_all,icall_all_data_voice,icall_all_data_only,icall_all_voice_only, icall_chinese_all,icall_chinese_data_voice,icall_chinese_data_only,icall_chinese_voice_only, icall_english_all,icall_english_data_voice,icall_english_data_only,icall_english_voice_only, remote_service, before_5_minute_call_count,before_30_minute_call_count,before_60_minute_call_count, before_5_minute_i_chinese_talk_avg,before_5_minute_i_english_talk_avg,before_30_minute_i_chinese_talk_avg,before_30_minute_i_english_talk_avg,before_60_minute_i_chinese_talk_avg,before_60_minute_i_english_talk_avg);


	sprintf(performance_data,"icall_all=%d;;;; icall_all_data_voice=%d;;;; icall_chinese_data_only=%d;;;; icall_chinese_voice_only=%d;;;; icall_chinese_all=%d;;;; icall_chinese_data_voice=%d;;;;  icall_chinese_data_only=%d;;;; icall_chinese_voice_only=%d;;;; icall_english_all=%d;;;; icall_english_data_voice=%d;;;; icall_english_data_only=%d;;;; icall_english_voice_only=%d;;;; remote_service=%d;;;; before_5_minute_call_count=%d;;;; before_30_minute_call_count=%d;;;; before_60_minute_call_count=%d;;;; before_5_minute_cn_talk_avg=%d;;;; before_5_minute_en_talk_avg=%d;;;; before_30_minute_cn_talk_avg=%d;;;; before_30_minute_en_talk_avg=%d;;;; before_60_minute_cn_talk_avg=%d;;;; before_60_minute_en_talk_avg=%d;;;;", icall_all,icall_all_data_voice,icall_chinese_data_only,icall_chinese_voice_only, icall_chinese_all,icall_chinese_data_voice,icall_chinese_data_only,icall_chinese_voice_only, icall_english_all,icall_english_data_voice,icall_english_data_only,icall_english_voice_only, remote_service, before_5_minute_call_count,before_30_minute_call_count,before_60_minute_call_count, before_5_minute_i_chinese_talk_avg,before_5_minute_i_english_talk_avg,before_30_minute_i_chinese_talk_avg,before_30_minute_i_english_talk_avg,before_60_minute_i_chinese_talk_avg,before_60_minute_i_english_talk_avg);

	printf("%s: %s | %s\n",exit_status[exitstatus],status_information,performance_data);

        return exitstatus;
}
ccjsj1
关注
专栏目录
nagios监控ORACLE插件
06-20
nagios监控ORACLE插件，监控内容非常多！
Nagios WAS 是个用来监控 IBM 的 WebSphere 应用服务器的 Nagios 插件
最新发布
03-04
【Nagios WAS 插件详解】 Nagios WAS，全称为Nagios WebSphere Application Server Monitoring Plugin，是一款专门针对IBM WebSphere应用服务器设计的监控工具。它属于Nagios监控系统的一个扩展，旨在帮助DevOps...
巧用nagios脚本监控oracle连接
weixin_34025151的博客
02-23 106
场景： 程序修改完成后，上传到应用服务器tomcat，重启tomcat后，发现启动异常！前端nginx负载均衡出现504错误，网站无法打开！ 排查： 经过排查tomcat日志，发现连接数据库异常；登陆数据库后以"conn /as sysdba"方式登陆正常，数据库轻载，无压力；于是检查数据库的监听器，输入"lsntctl services"命令，卡住，半天不出结果… 故障处理： 输入"l...
用于Nagios中监控服务器连接数脚本
weixin_33975951的博客
06-16 140
最近因为服务器不断有增加新的业务，需要对服务器的最大连接数进行调整评估，所以就利用Nagios去监控相应的连接数，脚本也是利用Nagios发送相应的转态来实现监控，实现也很简单#/bin/bash #UsedtomonitorthenumberofsocketconnectionsinNagios #writerjim #histor #2017.6...
ProC实例-Linux下的Oracle Pro*C应用程序实例
wjzhang5514的博客
06-06 2759
最近帮做的一个数据库实验，过程中觉得网上 Pro*C 的资源和例子太有限，于是想记录一下。 简单说下 Pro*C 程序简单原理：编写一个后缀名为 .pc 的源代码，内容是正常的 C 代码嵌入 Pro*C 语句，然后预编译成后缀名为 .c 的文件，再编译为 exe 可执行文件。 如Linux下执行命令： precompiledimensxcn1:pgirard> chmod 700 preco
48141
weixin_43768924的博客
06-02 369
laravel框架提供了两种方式处理会话（Session ）数据： （1）全局的辅助函数 session （2）通过 Request 实例 1.获取并设置默认值 $request->session()->get(‘key’, ‘default’); session(‘key’, ‘default’); 2.判断 Session 中是否存在指定项 has 方法可用于检查数据项在 Session 中是否存在。如果存在并且不为 null 的话返回 true： if ($request->sess
Nagios配置之监控远程主机插件安装（案例）.pdf
07-11
完成上述步骤后，Nagios服务器就能通过NSClient++插件监控远程Windows主机了。记得重启Nagios服务以应用配置变更。 **注意事项** - 确保Nagios服务器与被监控主机之间网络通畅，且防火墙设置允许Nagios服务器通过...
Shell脚本编写Nagios插件监控程序资源占用
09-04
本文将深入探讨如何使用Shell脚本编写Nagios插件，以监控程序资源占用，确保系统稳定运行。 首先，我们需要了解需求分析。在编写监控程序资源占用的Shell脚本时，有两个主要需求： 1. 脚本应能够设定CPU和内存的...
Nagios Check Weblogic:监控 Weblogic 的 Nagios 插件-开源
06-29
Nagios是一款强大的网络监视系统，能够实时监控网络服务的状态，包括服务器、网络设备和应用程序。WebLogic是Oracle公司的一款企业级Java应用服务器，广泛用于部署和管理Java应用程序。将Nagios与WebLogic结合，可以...
oracle 12c 48141,Oracle 12C 之 CDB/PDB用户的创建与对象管理
weixin_33280038的博客
04-06 275
在Oracle 12C中，账号分为两种，一种是公用账号，一种是本地账号(亦可理解为私有账号)。共有账号是指在CDB下创建，并在全部PDB中生效的账号，另一种是在PDB中创建的账号。针对这两种账号的测试如下：1.1 在PDB中创建测试账号SQL> alter session set container=pdb01;Session altered.SQL> select username ...
诡异的错误：ORA-48141: error creating directory during ADR initialization--原来是单引号惹的祸
Expec-乐的博客
04-04 3444
错误信息 SQL> startup nomount pfile='/tmp/initorcl.ora'; ORA-48141: error creating directory during ADR initialization [/u01/app/oracle/diag/rdbms//u01/app/oracle/fast_recovery] ORA-48189: OS comman...
oracle 12c 48141,诡异的错误：ORA-48141: error creating directory during ADR initialization--原来是单引号惹的祸...
weixin_28957321的博客
04-06 485
错误信息SQL> startup nomount pfile='/tmp/initorcl.ora';ORA-48141: error creating directory during ADR initialization [/u01/app/oracle/diag/rdbms//u01/app/oracle/fast_recovery]ORA-48189: OS command to c...
oracle 12 pro*c 使用注意
guoxin_0724的专栏
05-15 1156
oracle12c安装后，用oracle用户执行proc命令，正常。当换oracle以外用户执行时，报错：dbgc_init_all failed with ORA-48141原因：/u01/app/oracle/diag/plsql文件夹访问权限不足。修正方法：chmod 775 /u01/app/oracle/diag/plsql...
11g两个节点RAC搭建单实例DG过程问题以及解决方法
cke63021的博客
03-07 741
本人菜鸟一枚，工作和学习真的是天壤之别，以前搭建过单实例数据库的DG，感觉挺简单的，后来来到公司第一个项目是给RAC搭建DG，信心满满的自己，真的是费尽心思啊，各种请教，各种百度，终于艰难的完成了任务，下面细说在下遇见的问题。 ...
使用PLSQL连接ORACLE出现“ORA-12541: TNS: 无监听程序”或是“ERROR - ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务”解决方案
新欢`的博客
11-08 2385
使用PLSQL连接ORACLE出现“ORA-12541: TNS: 无监听程序”或是“ERROR - ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务”这样的错误时，解决方案： 1、打开任务管理器，查看服务“OracleService”和“TNS监听”是否打开； 2、查看系统配置是否填写正确。 首先要确认自己的ORACEL的安装目录和下载的instantclient_11_2目录。 （1）变量“PATH” ​ 确认是否已添加instantclient_11_2的
Configuration of ASM ... failed
喝醉酒的小白
01-07 3431
问题 Configuration of ASM ... failed see asmca logs at /opt/ogrid/cfgtoollogs/asmca for details Did not succssfully configure and start ASM at /opt/grid/products/11.2.0/crs/install/crsconfig_lib.pm line 6912. /opt/grid/products/11.2.0/perl/bin/perl -I/opt/gr
12C ORA-错误汇总19
热门推荐
badman250的专栏
03-02 4万+
KUP-00552: internal XAD package failed to load Cause: An error was encountered while attempting to initialize the XAD package. Action: This message should be accompanied by other error message(s) in
Nagios监控扩展：NRPE与插件配置详解
完成以上步骤后，Nagios服务器就能通过nrpe插件监控客户端的远程主机了。为了确保监控的准确性和安全性，还需要在Nagios服务器上配置相应的服务定义和主机定义，以便指定要监控的指标和报警阈值。 总结来说，Nagios...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值