Lin Hong's TECH Blog!

【学习】 2025年阅读清单

Oracle 19c load awr report

2020-03-17

Oracle

Oracle awr Tips

Oracle 19c load awr report

Tips:

Load data from datapump file created by awrload.sql.

Use awrextr.sql extract data from AWR into a datapump file.

Use same db version is good choise(the awr format are different from db versions.)

Need to check tablespace’s size while load awr data due to the limit of tablespace.

Read All

Oracle Recover Tips

2020-03-17

Oracle

Oracle Recover Tips

1.Recover oracle password file

Oracle Recover Tips

Tips:

1.Recover oracle password file

Wrong msg:

ERROR:
ORA-01017: invalid username/password; logon denied

Solution:

Use orapwd command to recover the password file.

orapwd file=$ORACLE_HOME/dbs/orapwORCL password=Welcome1 force=y  // force=y (if the password file is existed, will replace the password file instead by force)

Read All

Oracle 19c Analysis SQL in AWR report Tips

2020-02-12

Oracle

Oracle SQLloader Tips
Oracle 19c Analysis SQL in AWR report

There are some sql in SQL ordered by CPU Time AWR report.

These sql were using so many cpu time…
```
/* SQL Analyze(0) */ select /*+ full(t) parallel(t, 6) parallel_index(t, 6) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl no_substrb_pad */to_char...
 
```
What are these sqls? what are they doing?
Read All
Oracle 19c online statistics gathering Tips

2020-02-11

Oracle

Oracle SQLloader Tips

Oracle 19c Online statistics gathering between sqlloader and insert append Tips

This is test with sqlloader/insert append sql.

Read All
Oracle SQL loader Tips

2020-02-10

Oracle

Oracle SQLloader Tips scripts

Oracle SQL loader Tips

Read All
Unix SSH Timeout Tips

2020-02-09

Unix

Unix SSH Tips

Unix SSH Timeout Tips

Read All
Centos 7.6 + Postgresql 10 Install Tips

2020-02-03

Postgresql

Centos Postgres Postgresql Tips

Centos 7.6 + Postgresql 10 Install Tips

实战介绍在 CentOS 7.6 环境下如何源码安装 Postgresql 10

Read All

Ubuntu Change default editor Tips

2019-12-01

Unix

Unix Tips

1. Modify .bashrc
2. Modify OS config editor
3.remove other editors

Ubuntu Change default editor Tips

1. Modify .bashrc

$ echo export EDITOR=/usr/bin/vim >> ~/.bashrc 

2. Modify OS config editor

$ update-alternatives --config editor 
-> 3 (vim.basic)

root@inst-hk01:~# update-alternatives --config editor 
There are 4 choices for the alternative editor (providing /usr/bin/editor).

  Selection    Path                Priority   Status
------------------------------------------------------------
  0            /bin/nano            40        auto mode
  1            /bin/ed             -100       manual mode
  2            /bin/nano            40        manual mode
* 3            /usr/bin/vim.basic   30        manual mode
  4            /usr/bin/vim.tiny    10        manual mode

Press <enter> to keep the current choice[*], or type selection number: 3
root@inst-hk01:~# 

3.remove other editors

$ sudo apt-get remove nano

test

$crontab -e

Read All

Oracle Linux pstack Tips

2019-10-16

Oracle

Oracle Tips 12c pstack trace
- Install pstack in Oracle Linux 7.
Oracle Linux pstack Tips

Install pstack in Oracle Linux 7.

Install gdb by yum and there are pstack and gstack in gdb.
Read All
Oracle Linux yum/wget proxy Tips

2019-10-16

Oracle

Oracle Linux Tips

Oracle Linux yum/wget proxy Tips

Linux Yum/Wget proxy setting

Read All
Oracle 12c PDB LOCKDOWN Profiles Tips

2019-09-04

Oracle

Oracle Tips 12c

Oracle 12c PDB LOCKDOWN Profiles Tips

Oracle Database 12.2 New Feature – PDB Lockdown Profiles

Having fun with PDB LOCKDOWN PROFILES

oracle 12cR2新特性-PDB lockdown profile

Have a good work&life! 2019/09 via LinHong

Read All

Oracle 19c Query the patch Tips

2019-08-23

Oracle

Oracle Scripts SQL 19c

Oracle 19c Query the patch Tips

Query the patch applied on database 19c.

SYS@orcl> !cat patch_list.sql
set line 300
col action form a12
col version  form a40
col comments form a60
col action_date form a20

select comments, action, to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, version from registry$history order by action_date;

set line 300
col action form a12
col version  form a40
col description form a60
col action_date form a20
select description, action, to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, ' ' version from dba_registry_sqlpatch;

SYS@orcl>

Read All

16/37

1.Recover oracle password file

1. Modify .bashrc

2. Modify OS config editor

3.remove other editors

Install pstack in Oracle Linux 7.