随笔分类 -  oracle

学习记录
Authentication token is no longer valid; new one required You (oracle) are not allowed to access to (crontab) because of pam configuration.
摘要:-bash-4.1$ crontab -e Authentication token is no longer valid; new one requiredYou (oracle) are not allowed to access to (crontab) because of pam conf 阅读全文

posted @ 2020-10-30 11:23 winecork 阅读(226) 评论(0) 推荐(0)

存储过程
摘要:create or replace procedure Hello is h number; g char(20); begin select extract(hour from systimestamp)+8 into h from dual; if h >=20 or h<=5 then g:= 阅读全文

posted @ 2020-10-26 15:48 winecork 阅读(47) 评论(0) 推荐(0)

oracle extract()函数
摘要:select extract(year from sysdate) as year , extract(month from sysdate) as month, extract(day from sysdate) as day from dual; //使用extract()函数,分别取出年月日 阅读全文

posted @ 2020-10-26 15:30 winecork 阅读(328) 评论(0) 推荐(0)

oracle用户被锁死
摘要:select username,lock_date from dba_users where username ='USERNAME‘ //查看被锁定用户时间; 阅读全文

posted @ 2020-07-19 22:40 winecork 阅读(148) 评论(0) 推荐(0)

修改用户登陆次数
摘要:1、查看FAILED_LOGIN_ATTEMPTS的值 select * from dba_profiles2、修改为30次 alter profile default limit FAILED_LOGIN_ATTEMPTS 30;3、修改为无限次(安全起见,不建议使用) alter profile 阅读全文

posted @ 2019-07-30 15:51 winecork 阅读(219) 评论(0) 推荐(0)

使用plsql developer报错
摘要:转自:https://blog.csdn.net/root_veraq/article/details/33728423 64位机器上了64位的oracle客户端,安装PL/SQL Developer报错 Initialization error SQL*Net not properly insta 阅读全文

posted @ 2019-07-30 15:14 winecork 阅读(592) 评论(0) 推荐(0)

oracle客户端卸载
摘要:已安装的oracle_home目录下找deinstall目录,卸载过程中选择Yes。 转自:https://blog.csdn.net/zhanghai412/article/details/8160483 由于Toad不支持64位的oracle客户端,因此要卸载已经安装的客户端官网卸载说明:htt 阅读全文

posted @ 2019-07-30 15:11 winecork 阅读(2966) 评论(0) 推荐(0)

导航