好用百家乐软件-大学成绩单用什么纸打印

首页

AD联系:507867812

好用百家乐软件

时间:2019-11-20 03:00:06 作者:ag讯视百家乐 浏览量:61584

好用百家乐软件ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux,见下图

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决,见下图

ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux,如下图

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

如下图

ORA-12519: TNS:no appropriate service handler found 解决,如下图

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux,见图

好用百家乐软件

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决。

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

好用百家乐软件

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决。

ORA-12519: TNS:no appropriate service handler found 解决

1.

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

2.

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

3.

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxORA-12519: TNS:no appropriate service handler found 解决

4.ORA-12519: TNS:no appropriate service handler found 解决。

ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决ORA-12519: TNS:no appropriate service handler found 解决

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux。好用百家乐软件

展开全文
相关文章
哪家百家乐最好

ORA-12519: TNS:no appropriate service handler found 解决

盈丰百家乐技术打法

ORA-12519: TNS:no appropriate service handler found 解决....

百利宫百家乐园

ORA-12519: TNS:no appropriate service handler found 解决....

百家乐最好的平台

ORA-12519: TNS:no appropriate service handler found 解决....

百家乐输赢

ORA-12519: TNS:no appropriate service handler found 解决....

相关资讯
百家乐视频ag

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

足球比赛直播百家乐输死

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

百家乐大赌场

ORA-12519: TNS:no appropriate service handler found 解决

有时候连得上数据库,有时候又连不上.

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

select count(*) from v$process --当前的连接数

select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:

alter system set processes = 300 scope = spfile;

重启数据库:

shutdown immediate;startup;

--查看当前有哪些用户正在使用数据

SELECT oSUSEr, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;

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

Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm

在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htm

Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htm

Debian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm

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

附数据库系统数据查询

1、查询oracle的连接数select count(*) from v$session;2、查询oracle的并发连接数select count(*) from v$session where status='ACTIVE';3、查看不同用户的连接数select username,count(username) from v$session where username is not null group by username;4、查看所有用户:select * from all_users;5、查看用户或角色系统权限(直接赋值给用户或角色的系统权限):select * from dba_sys_privs;select * from user_sys_privs;6、查看角色(只能查看登陆用户拥有的角色)所包含的权限select * from role_sys_privs;7、查看用户对象权限:select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;8、查看所有角色:select * from dba_roles;9、查看用户或角色所拥有的角色:select * from dba_role_privs;select * from user_role_privs;10、查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select * from V$PWFILE_USERS;修改数据库允许的最大连接数:alter system set processes = 300 scope = spfile;查看游标数量Select * from v$open_cursor Where user_name=''查询数据库允许的最大连接数:select value from v$parameter where name = 'processes';或者:show parameter processes;查询数据库允许的最大游标数:select value from v$parameter where name = 'open_cursors'查看oracle版本select banner from sys.v_$version;按降序显示用户"SYSTEM"为每个会话打开的游标数select o.sid, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where user_name = 'SYSTEM' and o.sid=s.sid group by o.sid, osuser, machine order by num_curs desc;

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

热门资讯