- 博客(90)
- 资源 (3)
- 收藏
- 关注
原创 ORA-12543:TNS:destination host unreachable
show parameter dest;select error,status from gv$archive_dest where dest_id=10;show parameter log_archive_dest_10tnsping primary_dbtnsping slave_dblsnrctl status | reload
2021-07-31 16:23:43 2608
原创 Oracle 归档相关知识
归档量查询select trunc(completion_time) as "Data", (sum(blocks*block_size))/1024/1024 as "MB"from v$archived_loggroup by trunc(completion_time)order by 1;select thread#,sequence#,deleted from v$archived_log order by 2;归档路径更换archive log list;alter
2021-07-31 16:10:31 3544
原创 查询v$asm_disk视图hang住
select path from v$asm_disk ;查看等待事件select inst_id,sid,username,event,count(*) from gv$session where wait_class<>'Idle' group by inst_id,sid,username,event order by 4;查看阻塞会话select inst_id,sid,username,event,state,blocking_session from gv$sessio
2021-07-24 15:18:01 2192
原创 sftp上传下载命令get/put
lcd 切换windows环境路径lpwd 查看windows环境路径cd 切换linux环境路径pwd 查看linux环境路径get 下载linux资源到windowsput 上传windows资源到linux
2021-07-24 15:03:06 4616
原创 SQLPlus远程连接
1 临时连接sqlplus 用户名/密码@IP地址[:端口]/service_name [as sysdba]2 永久连接vi $ORACLE_HOME/network/admin/tnsnames.ora连接串名 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口号)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAM
2021-07-24 10:37:36 5614
原创 Oracle Data Pump
Oracle Data Pump只能用于服务器端表、方案、表空间、整个数据库$ mkdir dump$ dbaSQL>create directory dump_dir as '/home/oracle/dump';SQL>grant read, write on directory dump_dir to system;表$ expdp system/oracle directory=dump_dir dumpfile=dumptable.dmp tabels=regio
2021-07-21 21:37:10 2454
原创 Log File Sync/Log File Parallel Write (单实例)
当用户执行完事务(insert插入数据)执行commit命令后,Oracle后台LGWR进程需要redo log buffer -> online redo log files,写入后返回Commit complete。这个过程过慢Log File Sync等待事件。Log File Parallel Write是LGWR进程开始执行到结束这个过程的等待事件。...
2021-07-19 22:44:44 3241
原创 OCR和Voting Disk
crsctl query css votedisk集群信息保存在OCR,同时记录着集群的信息以及由集群维护的资源信息。Voing File 记录的是节点成员身份信息。ocrconfig -showbackup auto
2021-07-19 21:21:07 2342
原创 19c多租户创建表空间和用户
create tablespace incremental datafile size 1g autoextend off; select tablespace_name from dba_tablespaces where tablespace_name='INCREMENTAL';create user c##incremental identified by test default tablespace incremental;select username, default_tablespa
2021-07-19 18:04:50 2012
原创 Oracle查看当前登陆用户的角色和权限
角色select * from user_role_privs;select * from session_privs;系统权限和表级权限select * from user_sys_privs;select grantee, owner, table_name, privilege from user_tab_privs;
2021-07-18 18:41:48 2312
原创 DBCA静默建库
11g 非CDBdbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName bpxtest -sid bpxtest -sysPassword oracle -systemPassword oracle -storageType ASM -diskGroupName DATADG -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -databaseType OLT
2021-07-18 18:06:20 2380
原创 ASM磁盘重平衡
asm磁盘select name, failgroup, group_number from v$asm_disk order by failgroup;asm磁盘属性select name, value, group_number from v$asm_attribute where name like 'compatible%';asm相关信息select a.group_number,b.name,a.failgroup,a.pathfrom v$asm_disk a,v$asm_di
2021-07-18 15:26:00 3827
原创 Oracle查看数据库文件大小
select sysdate from dual;select name from v$datafile;show parameter db_create_file_dest!df -h | grep /dataselect sum(bytes)/1024/1024/1024/1024 as dba_data_files from dba_data_files;select sum(bytes)/1024/1024/1024/1024 as dba_segments from dba_segmen
2021-07-18 10:43:46 3780
原创 物理 Standby <-> Snapshot Standby
1 Snapshot StandbySnapshot Standby 是 Oracle Data Guard 可以将备库置为“可读写状态”的一种备库类型,目的是为了进行模拟上线测试等在生产库上不能实现的任务。当读写状态的 Snapshot 备库测试任务完成后,可以方便地把 Snapshot Standby数据库角色切换回原先的备库角色,恢复与主库数据同步。在 Snapshot Standby 数据库状态下,备库可以接受主库传过来的日志,但不能够将主库的变化及时地应用在备库中,后续切回至物理备库时,所有写入
2021-07-16 23:36:38 2191
原创 CDB重启时如何保持PDB的状态
alter pluggable database all save state;select con_name, state from dba_pdb_saved_states;alter pluggable database pdba discard state;select CON_ID, NAME, OPEN_MODE, RESTRICTED, OPEN_TIME from gv$containers;
2021-07-16 23:22:22 2071
原创 查看服务器CPU核数
总核数 = 物理CPU个数 X 每颗物理CPU的核数 总逻辑CPU数 = 物理CPU个数 X 每颗物理CPU的核数 X 超线程数# CPU信息(型号)cat /proc/cpuinfo | grep name | cut -f2 -d: | uniq -c # 物理CPU个数 cat /proc/cpuinfo| grep "physical id"| sort| uniq| wc -l # 物理CPU中core的个数(即核数) cat /proc/cpuinfo| grep "cpu
2021-07-16 22:07:45 5017
原创 ADG搭建
1 查看主库状态select database_role, protection_mode from v$database;select force_logging from v$database;select group#, bytes/1024/1024 from v$log;2 备库-配置静态监听vi listener.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl19c)
2021-07-16 19:56:19 2545
原创 ORA-16053: DB_UNIQUE_NAME win12cbak is not in the Data Guard Configuration
show parameter log_archive_configalter system set log_archive_config='dg_config=(recover, win12cbak)';
2021-07-16 11:08:36 2714
原创 OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.
orapwd file=$ORACLE_HOME/dbs/orapw+实例名 password=oracle entries=5;orapwd file=$ORACLE_HOME/dbs/orapw+实例名 password=oracle format=12 force=y;
2021-07-16 10:46:10 3461
原创 SQL_ID查询不到
prev_sql_idselect sql_id,event,count(*) from gv$session where wait_class<>'Idele' group by event,sql_id order by count(*);
2021-07-14 21:22:58 2735
原创 Oracle重建控制文件
alter database backup controlfile to trace; select value from v$diag_info where name='Default Trace File';Oracle 控制文件的重建
2021-07-14 21:10:27 2135
原创 创建逻辑卷
attach_disk是在系统下做raid0,dd是往磁盘上写数据dd if=/dev/zero of=/dev/sdb bs=1M count=1024dd if=/dev/zero of=/dev/sdc bs=1M count=1024dd if=/dev/zero of=/dev/sdd bs=1M count=1024dd if=/dev/zero of=/dev/sde bs=1M count=1024dd if=/dev/zero of=/dev/sdf bs=1M count=..
2021-07-14 20:55:44 1999
StudentManagerSSM.rar
2020-08-06
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人