The Connection descriptor used by the client

最新推荐文章于 2019-07-21 09:57:30 发布
原创 最新推荐文章于 2019-07-21 09:57:30 发布 · 829 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#数据库

本文介绍如何检查当前数据库连接数及最大连接数，并提供步骤指导如何调整最大连接数以解决因连接过多导致的问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

可能是数据库上当前的连接数目已经超过了它能够处理的最大值.


查看当前的连接数 

select count(*) from v$process;

 
数据库允许的最大连接数

select value from v$parameter where name='processes';

 

修改最大连接数:

alter system set processes=300 scope=spfile;

 
重启数据库:

shutdown immediate;
startup;

 shutdown   默认的是normal.可以省略；

 startup       默认的是open，也可以省略；

 

 

iteye_10057
关注
oracle 数据链接过多，导致后续链接链接不上
qq_40603125的博客
03-07 689
也可以根据 查询所有用户的对应的链接数。
强大的socat工具，可创建虚拟串口、在串口/网口间转发数据等，基本上无所不能的工具
哦，原来你也在这里。
01-20 1815
socat，一个强大的工具，串口工具
RA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was
热门推荐
gaoqiao1988的专栏
07-05 1万+
有时候连得上数据库,有时候又连不上。 可能是数据库上当前的连接数目已经超过了它能够处理的最大值。     select count(*) from v$process --当前的连接数     select value from v$parameter where name = 'processes' --数据库允许的最大连接数     修改最大连接数:     alter sy
ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was...
weixin_30436101的博客
01-15 540
数据库报错： 　　　　Caused by: java.sql.SQLException: Listener refused the connection with the following error:　　　　ORA-12519, TNS:no appropriate service handler found　　　　The Connection descriptor used by the ...
解决ORA-12514 监听程序当前无法识别连接描述符中的服务
ytsm04的专栏
07-21 588
解决ORA-12514 监听程序当前无法识别连接描述符中的服务 2008-11-13 12:49 连接数据库时出错如下： ORA-12505, TNS:listener does not currently know of SID given in connect descript or The Connection descriptor used by the client wa...
Connection termination(by client)” 错误的处理方法
weixin_30920853的博客
01-01 590
背景： 在一些项目，当我们使用LR录制脚本的时候，在我们安装认证我们无法启动[网址=]HTTPS[/url]的IE插件，页面显示空白，没有事件的记录，在Firefox也一样。 在记录日志，我们会发现“Connection termination(by client)” 的错误 分析：原因是是loadrunner 并不支持该格式的证书。我们安装的证书格式是.er,但是loadRu...
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was
01-11
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor错误是Oracle数据库连接错误的一种常见错误。它表示客户端使用的连接描述符中指定的SID在监听程序中未被识别。 连接描述符是...
/** * Copyright (C) Bosch Sensortec GmbH. All Rights Reserved. Confidential. * * Disclaimer * * Common: * Bosch Sensortec products are developed for the consumer goods industry. They may only be used * within the parameters of the respective valid product data sheet. Bosch Sensortec products are * provided with the express understanding that there is no warranty of fitness for a particular purpose. * They are not fit for use in life-sustaining, safety or security sensitive systems or any system or device * that may lead to bodily harm or property damage if the system or device malfunctions. In addition, * Bosch Sensortec products are not fit for use in products which interact with motor vehicle systems. * The resale and/or use of products are at the purchaser's own risk and his own responsibility. The * examination of fitness for the intended use is the sole responsibility of the Purchaser. * * The purchaser shall indemnify Bosch Sensortec from all third party claims, including any claims for * incidental, or consequential damages, arising from any product use not covered by the parameters of * the respective valid product data sheet or not approved by Bosch Sensortec and reimburse Bosch * Sensortec for all costs in connection with such claims. * * The purchaser must monitor the market for the purchased products, particularly with regard to * product safety and inform Bosch Sensortec without delay of all security relevant incidents. * * Engineering Samples are marked with an asterisk (*) or (e). Samples may vary from the valid * technical specifications of the product series. They are therefore not intended or fit for resale to third * parties or for use in end products. Their sole purpose is internal client testing. The testing of an * engineering sample may in no way replace the testing of a product series. Bosch Sensortec * assumes no liability for the use of engineering samples. By accepting the engineering samples, the * Purchaser agrees to indemnify Bosch Sensortec from all claims arising from the use of engineering * samples. * * Special: * This software module (hereinafter called "Software") and any information on application-sheets * (hereinafter called "Information") is provided free of charge for the sole purpose to support your * application work. The Software and Information is subject to the following terms and conditions: * * The Software is specifically designed for the exclusive use for Bosch Sensortec products by * personnel who have special experience and training. Do not use this Software if you do not have the * proper experience or training. * * This Software package is provided `` as is `` and without any expressed or implied warranties, * including without limitation, the implied warranties of merchantability and fitness for a particular * purpose. * * Bosch Sensortec and their representatives and agents deny any liability for the functional impairment * of this Software in terms of fitness, performance and safety. Bosch Sensortec and their * representatives and agents shall not be liable for any direct or indirect damages or injury, except as * otherwise stipulated in mandatory applicable law. * * The Information provided is believed to be accurate and reliable. Bosch Sensortec assumes no * responsibility for the consequences of use of such Information nor for any infringement of patents or * other rights of third parties which may result from its use. No license is granted by implication or * otherwise under any patent or patent rights of Bosch. Specifications mentioned in the Information are * subject to change without notice. * * It is not allowed to deliver the source code of the Software to any third party without permission of * Bosch Sensortec. * */ /*! * @file bsec_iot_example.c * * @brief * Example for using of BSEC library in a fixed configuration with the BME68x sensor. * This works by running an endless loop in the bsec_iot_loop() function. */ /*! * @addtogroup bsec_examples BSEC Examples * @brief BSEC usage examples * @{*/ /**********************************************************************************************************************/ /* header files */ /**********************************************************************************************************************/ #include "bsec_integration.h" /**********************************************************************************************************************/ /* functions */ /**********************************************************************************************************************/ /*! * @brief Write operation in either Wire or SPI * * param[in] reg_addr register address * param[in] reg_data_ptr pointer to the data to be written * param[in] data_len number of bytes to be written * param[in] intf_ptr interface pointer * * @return result of the bus communication function */ int8_t bus_write(uint8_t reg_addr, const uint8_t *reg_data_ptr, uint32_t data_len, void *intf_ptr) { // ... // Please insert system specific function to write to the bus where BME68x is connected // ... return 0; } /*! * @brief Read operation in either Wire or SPI * * param[in] reg_addr register address * param[out] reg_data_ptr pointer to the memory to be used to store the read data * param[in] data_len number of bytes to be read * param[in] intf_ptr interface pointer * * @return result of the bus communication function */ int8_t bus_read(uint8_t reg_addr, uint8_t *reg_data_ptr, uint32_t data_len, void *intf_ptr) { // ... // Please insert system specific function to read from bus where BME68x is connected // ... return 0; } /*! * @brief System specific implementation of sleep function * * @param[in] t_us Time in microseconds * @param[in] intf_ptr Pointer to the interface descriptor * * @return none */ void sleep_n(uint32_t t_us, void *intf_ptr) { // ... // Please insert system specific function sleep or delay for t_ms milliseconds // ... } /*! * @brief Capture the system time in microseconds * * @return system_current_time current system timestamp in microseconds */ int64_t get_timestamp_us() { int64_t system_current_time = 0; // ... // Please insert system specific function to retrieve a timestamp (in microseconds) // ... return system_current_time; } /*! * @brief Handling of the ready outputs * * @param[in] outputs output_t structure * @param[in] bsec_status value returned by the bsec_do_steps() call * * @return none */ void output_ready(output_t *outputs, bsec_library_return_t bsec_status) { // ... // Please insert system specific code to further process or display the BSEC outputs // ... } /*! * @brief Load previous library state from non-volatile memory * * @param[in,out] state_buffer buffer to hold the loaded state string * @param[in] n_buffer size of the allocated state buffer * * @return number of bytes copied to state_buffer */ uint32_t state_load(uint8_t *state_buffer, uint32_t n_buffer) { // ... // Load a previous library state from non-volatile memory, if available. // // Return zero if loading was unsuccessful or no state was available, // otherwise return length of loaded state string. // ... return 0; } /*! * @brief Save library state to non-volatile memory * * @param[in] state_buffer buffer holding the state to be stored * @param[in] length length of the state string to be stored * * @return none */ void state_save(const uint8_t *state_buffer, uint32_t length) { // ... // Save the string some form of non-volatile memory, if possible. // ... } /*! * @brief Load library config from non-volatile memory * * @param[in,out] config_buffer buffer to hold the loaded state string * @param[in] n_buffer size of the allocated state buffer * * @return number of bytes copied to config_buffer */ uint32_t config_load(uint8_t *config_buffer, uint32_t n_buffer) { // ... // Load a library config from non-volatile memory, if available. // // Return zero if loading was unsuccessful or no config was available, // otherwise return length of loaded config string. // ... return 0; } /*! * @brief Main function which configures BSEC library and then reads and processes the data from sensor based * on timer ticks * * @return result of the processing */ int main() { return_values_init ret; struct bme68x_dev bme_dev; memset(&bme_dev,0,sizeof(bme_dev)); /* Call to the function which initializes the BSEC library * Switch on low-power mode and provide no temperature offset */ ret = bsec_iot_init(BSEC_SAMPLE_RATE_LP, 0.0f, bus_write, bus_read, sleep_n, state_load, config_load, bme_dev, 0); if (ret.bme68x_status) { /* Could not intialize BME68x */ return (int)ret.bme68x_status; } else if (ret.bsec_status) { /* Could not intialize BSEC library */ return (int)ret.bsec_status; } /* Call to endless loop function which reads and processes data based on sensor settings */ /* State is saved every 10.000 samples, which means every 10.000 * 3 secs = 500 minutes */ bsec_iot_loop(sleep_n, get_timestamp_us, output_ready, state_save, 10000); return 0; } /*! @}*/ 根据这个例程使用stm32hal库用keil开发
最新发布
07-25
在STM32 HAL库项目中集成BSEC库以支持BME68x传感器功能，并在Keil开发环境中配置和运行，需要完成以下步骤： ### 3.1 准备工作 ...尽管该库是为Arduino设计的，但可以将其移植到STM32项目中[^1]。...
python Connection refused: getsockopt
01-09
Checking whether the server socket’s file descriptor appears ready within the read set via `select()` might help confirm readiness. #### Correct Address Configuration Double-check both client-side...
ORA-12505错误
bennett2009的专栏
07-04 203
在使用oracle时遇到了一个问题： ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: localhost:1521:orcl 查阅了很多网上的内容，知道了是oracle ...
ORA-12519, TNS:no appropriate service handler found(数据库上当前的连接数目已经超过最大值)...
ailv8451的博客
09-27 135
报错： ORA-12519, TNS:no appropriate service handler foundThe Connection descriptor used by the client was:192.1.1:1521:orcl 原因： 有时候连得上数据库,有时候又连不上. 可能是数据库上当前的连接数目已经超过了它能够处理的最大值. 解决方案： select...
oracle多次访问数据库，报错问题？？？？
cspepsc的博客
02-24 584
报错信息：ORA-12519, TNS:no appropriate service handler foundThe Connection descriptor used by the client was:localhost:1521:XE] with root causejava.sql.SQLException: Listener refused the connection with t...
ORA-12505: TNS: 监听程序当前无法识别连接描述符中所给出的SID等错误解决方法
dixu7849的博客
04-16 2686
程序连接orarle报ORA-12505错误 一、异常{ ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: 10.190.121.95:1521:sxzhdb } ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值