ORABaseMgmt
Lowy Shin edited this page Feb 28, 2021
·
3 revisions
- Product by edition and additional products(jp)
- Starting Oracle service
- Switching Oracle Account
root@localhost#>su - oracle
- execute sqlplus
oracle@localhost$>sqlplus / as sysdba
- start oracle instance
SQL>startup
- exit from sqlplus
SQL>quit
- startup listener
oracle@localhost$>lsnrctl start
- referral docs
- Switching Oracle Account
- Stop oracle service
-
su - oracle
- change oracle account
-
emctl stop dbconsole
- Stop oracle enterprise manager
-
lsnrctl stop
- Stop listener
-
sqlplus / as sysdba
- Login sqlplus
-
shutdown immediate
- shutdown oracle process when waiting exist connection
-
shutdown abort
- shutdown oracle process aborting all connection
- use when take too long time on
shutdown immediate
command
-
- Listner log delete
$ adrci
adrci> show homepath
adrci> show control
adrci> purge -age 50000 -type alert
- -aget 50000 : 50000min.
- when purge, deleted xml log files.
$> lsnrctl
LSNRCTL> show log_status
LSNRCTL> show log_directory
LSNRCTL> show log_file
LSNRCTL> set log_status off
$> mv <log_file> <bak_file>
LSNRCTL> set log_status on
- Select Log
select
originating_timestamp,
module_id,
message_text
from v$diag_alert_ext
- Change different schema
- NLS_LANG
●UTF8
NLS_LANG=Japanese_Japan.AL32UTF8
●SJIS
NLS_LANG=Japanese_Japan.JA16SJIS
●EUC
NLS_LANG=Japanese_Japan.JA16EUC
※DatabaseをUS7ASCIIに設定して日本語を入れてもDBには正常に記録されるが、読み取りの際にUS7ASCIIにしてもORACLEの仕様上勝手にUTF8に変更される。これはOCI経由ではNLS_LANGパラメータを利用してクライアントのCharactersetを強制に指定できるが、Direct ConnectまたはODBC、JDBCを経由するとUnicodeに変換され文字化けになってしまう。なので文字化けした場合には必ず次の内容をチェックする
- OCIがサポートするクライアントツール
- NLS_LANG = US7ASCIIになっている(ClientまたはOS Parameter)
- クライアントツール側に自動変換をOFFにしている
- Oracle Instant Client
- Orange Client
- Toad
- KB wiki is multi-lingual writing. If you want translate to your language, use google translate!
- Go to giip service Page : http://giipweb.littleworld.net
- Documentation : https://github.com/LowyShin/giip/wiki
- Sample automation scripts : https://github.com/LowyShin/giip/tree/gh-pages/giipscripts
See more : https://github.com/LowyShin/giip/wiki
- Token exchanges : https://tokenjar.io/GIIP
- Token exchanges manual : https://www.slideshare.net/LowyShin/giipentokenjario-giip-token-trade-manual-20190416-141149519
- GIIP Token Etherscan : https://etherscan.io/token/0x33be026eff080859eb9dfff6029232b094732c52
If you want get GIIP, contact us any time!
- LowyWorkEnv : https://github.com/LowyShin/Lowyworkenv/wiki
- CLoud RDBMS比較
- MachineLearning
- SQL Server
- ORACLE
- MySQL
- mariadh
- Redis with MySQL
- Mongodb
- Apache-Drill
- A5MK2-MultiDBMSTool
- BI
- Referrals
- Juliaの自動微分パッケージ Zygote の紹介
- color code table
- Canva - free Online Design tool
- vscode
- git(github)
- GoogleSheet
- UiPath(RPA)
- WinAutomation(official)
- Excel
- VNC
- VPN
- Note Tool
- Blog
- google news alert
- Online PDF to JPG
- LoadTest " putty
- Shell/bash
- crontab
- PowerShell
- Windows(DOS) batch
- Wscript/wsf
- AWS
- Azure
- File Sync(rsync, scp...)
- KnownPort(wikipedia)
- CentOS(Linux)
- Windows10
- Android