摘要:DEFINE sqlprompt=SQL COLUMN sqlprompt NEW_VALUE sqlprompt SET TERMOUT OFF SELECT USER || '@' || NVL('&_CONNECT_IDENTIFIER', global_name ) sqlprompt FR
阅读全文
摘要:关闭审计 alter system set audit_trail = none scope=spfile; 180天密码过期 alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;
阅读全文
摘要:ORA-01001: invalid cursor 找了一下资资料说是打开的游标太多。 -- 有三千多条 select count(*) from v$cursor; 准备使用show parameter cursor看一下最大游标数有多少 sqlplus "/ as sysdba" -- 报错:n
阅读全文
摘要:The listener supports no services The command completed successfully 这是因为实例没有注册到监听上 查看listener.ora Started with pid=25113 Listening on: (DESCRIPTION=(
阅读全文
摘要:PS C:\Users\10170> ssh-keygen -R 192.168.154.19 # Host 192.168.154.19 found: line 11 # Host 192.168.154.19 found: line 12 # Host 192.168.154.19 found:
阅读全文
摘要:数据库版本:单机环境19c 实例是正常的 [oracle@sit19c admin]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 1 16:39:16 2023 Version 19.7.0.0.
阅读全文