一体机dbca建库报错：Cluster Node(s)[dm01dbadm01] are not accessibleCheck if these nodes are accessible using ssh/rshand have Oracle Grid Infrastructure running.Database Instance may not come up on these nodes
通常情况下，DML/DDL在命令行执行时没有任何问题，在存储过程中调用时会显示ora-01031，报错的解析如下：$ oerr ora 1031 01031, 00000, "insufficient privileges" // *Cause: An attempt was made to change the current username or password // wi
UBAuba: 0x00c20d9b.00c8.0fwith v as (select REPLACEREGEXP_REPLACE ('&uba','0x','',1,1) uba from dual)select v.uba, dbms_utility.data_block_address_file(TO_NUMBER(substr(v.uba, 1, instr(v.uba, '.
切换pdb时报错：SQL> alter session set container=pdb3;ERROR:ORA-44787: Service cannot be switched into.SQL> !oerr ora 4478744787, 0000, "Service cannot be switched into."// *Document: Yes// *Cause: The
笔记本无线网卡不能连网了，如下图：方法1：安装驱动，官网、精灵、人生，直到你怀疑人生。。。方法2（没试）：https://answers.microsoft.com/zh-hans/windows/forum/all/%E8%AF%A5%E8%AE%BE%E5%A4%87%E6%97%A0%E6%B3%95/3f646c44-2414-4a69-a982-b971c6508ae3您可以尝试
按网上的说法Typora 0.11.18版本是最后一个免费版本，下载安装了还是一样的提示。Typora 0.11.18绕过办法：打开注册表，计算机-HKEY_CURRENT_USER\SOFTWARE\Typora 将Typora文件夹权限设置有拒绝：发现一个0.9.96的版本可用：下载地址：https://github.com/iuxt/src/
本地登录出现ORA-01017的两种可能情况：情况1：参数设置不正确除了sys用户，其他普通用户均登录失败： $ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 24 13:44:52 2022Version 19.9.0.0.0Copyright (c) 1982, 2020, Oracle. Al
adg tcp/ip方式连接，在11g及以上库中最大支持30个级联备库，10g支持9个级联备库。
12c+适用select table_name, partition_name, table_owner, mods, num_rows, case when stale_reason_code is null then to_char('---') else XMLTYPE(replace(
create or replace procedure set_spm_plan (for_sqlid varchar2, new_plan_sqlid varchar2, new_phv number) as num pls_integer; sqlh varchar2(100); cursor existing_spb_handle is select distinct b
数据库1个节点crash，alert报错：In the alert log we are seeing:WARNING: The 'LOG_ARCHIVE_CONFIG' init.ora parameter settingsare inconsistent with another started instance. This may becaused by the 'DB_UNIQUE_NAM
创建目录CREATE OR REPLACE DIRECTORY data_dir AS '/home/oracle/direct';CREATE OR REPLACE DIRECTORY bad_dir AS '/home/oracle/direct';CREATE OR REPLACE DIRECTORY log_dir AS '/home/oracle/direct';.gz文件外部表CREA
For release up to 11.1:--pre.sql :spool pre.lstalter session set nls_date_format='dd-mon-rr hh24:mi:ss';select sysdate from dual;select sum (time_waited_micro/1000000) time_waited_secs from v$system_
CREATE OR REPLACE FUNCTION get_internal_value( p_value IN VARCHAR2) RETURN VARCHAR2IS temp_n NUMBER := 0;BEGIN FOR i IN 1..15 LOOP temp_n := temp_n + POWER(256, 15 - i) * ASCII(SUBSTR(RPAD(p
PDB SEED（种子 PDB）通常以只读模式打开，只有在执行 Oracle 数据库补丁的数据补丁时才会更新scn，这样会导致PDB SEED备份要比其他数据文件的scn小，为了保证恢复，归档日志会一直保留，即使已经超过了保留时间依然无法删除。解决办法：$ cat reopen_seed.sqlalter session set container = PDB$SEED;alter session
利用以下脚本可以在数据库迁移中对原库中的表的直方图进行收集copy_hist.sqlPROMPT ======================================================================================PROMPT Generate script to create extended statistics based on an
ORA-29857问题SQL> drop tablespace demotsdata including contents and datafiles;drop tablespace demotsdata including contents and datafiles*ERROR at line 1:ORA-29857: domain indexes and/or secondary ob
dsc集群，dm_svc.conf配置如下：$ cat /etc/dm_svc.confTIME_ZONE=(480)LANGUAGE=(cn)DMDB=(172.16.10.20:5236,172.16.10.22:5236)DIRECT=(Y)[DMDB]LOGIN_MODE=(1)SWITCH_TIME=(3)SWITCH_INTERVAL=(10)测试连接时报：[dmdba@dmdsc2
直方图中有low_value、high_value值，如果显示为10进制可以使用下面方法：字符串select utl_raw.cast_to_number(low_value) from dual;declare n varchar2(2000); begin dbms_stats.convert_raw_value('100001',n); dbms_output.put_line(n); en
通用写法：select * from (select /*+ FIRST_ROWS(n) */ a.*, ROWNUM rnum from (select object_id, object_name, LAST_DDL_TIME from tt order by 1) a wh
_optimizer_unnest_scalar_sq参数是12.1引入的隐含参数，目的是支持标量子查询展开，通常能展开的子查询被改写为hash外连接的形式，能够看到HASH GROUP BY关键字，可能导致临时表空间激增或升级前sql异常缓慢。默认该参数启用：set linesize 132column name format a30column value format a25sel
impdp导入错误：错误1impdp *****/*** directory=DATA_PUMP_DIR dumpfile=scott_%U.dmp logfile=scott.log parallel=2ORA-31693: Table data object "NC65"."PUB_WORKINGTASKLOG" failed to load/unload and is being skip
索引插入通常发生在索引的右边，当在单调递增的列上定义索引时，大量且高并发的DML（先删除后插入）会导致索引不能及时的放入指定的位置，oracle内部会根据索引的实际存储情况，对索引进行叶块的分裂操作，以满足索引的维护需求，这个过程会导致该等待事件的产生。可考虑的解决办法：1.创建hash或REVERSE索引可根据 AWR 报告的 'Segments by Row Lo
MOVE丢弃不满足条件的数据12c+版本支持,https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/ALTER-TABLE.html#GUID-552E7373-BF93-477D-9DA3-B2C9386F2877FILM_IDTITLEUK_RELEASE_DATELENGTH_IN_MINUTE
Lag和Lead分析函数可以在同一次查询中取出同一字段的前N行的数据(Lag)和后N行的数据(Lead)作为独立的列。LAG语法https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/LAG.html#GUID-68081CD0-72BE-4C0A-AA6B-AD39FFA7BCF2LEAD语法htt
测试脚本create table movies ( year_of_release number(4), name varchar2(60), gross_sales number(12) );insert into movies (year_of_release,name,gross_sales) values (1977,'star wars ep. iv: a new ho
create table toys ( toy_id integer not null primary key, toy_name varchar2(20) not null);declare start_time pls_integer; num_rows pls_integer := 100000;begin start_time := dbms_utility.ge
脚本1create table deliveries ( delivery_id integer not null constraint delivery_pk primary key, tracking_code varchar2(20) not null constraint deli_tracking_u unique, delivery_date date
---字符转二进制utl_raw.cast_to_raw---二进制转数字utl_raw.cast_to_number---二进制转字符utl_raw.cast_to_varchar2通常在统计信息中我们需要看直方图对应的low_value，high_value可以使用此函数转换SQL> select d.low_value,d.high_value,utl_raw.cast_to_varc
Copyright © 2005-2023 51CTO.COM 版权所有 京ICP证060544号
