歷史文章::JohnChen

改 NLS_CHARACTERSE 方法

2013-07-29 23:29

要更改NLS_CHARACTERSET的值, 例如要改成 AL32UTF8 , 步驟如下: 以 sysdba 角色進入 sqlplus 之後執行以下 shutdown immediate; STARTUP MOUNT; ALTER SESSION SET SQL_TRACE=TRUE; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; ALTER DATABASE...

查 flash recovery usage

2013-07-29 21:48

SQL> set newpage 2 SQL> set pagesize 500 linesize 200 SQL> select * from v$flash_recovery_area_usage; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES -------------------- ------------------...

查 DataBase 的語系

2013-07-29 18:27

SQL> col PARAMETER format a30 SQL> col VALUE format a50 SQL> set pages 5000 line 200 SQL> select * from v$nls_parameters; PARAMETER VALUE ------------------------------ -------------------------------------------------- NLS_LANGUAGE ...

查使用者自己的 table

2013-07-29 18:24

SQL> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- CALL ...

移除 Oracle 時，另外要手動移除的檔案

2013-07-29 18:20

[root@voipdb1 ~]# cat /etc/oraInst.loc inventory_loc=/u01/app/oraInventory inst_group=oinstall [root@voipdb1 ~]# cat /etc/oratab # # This file is used by ORACLE utilities. It is created by root.sh # and updated by either Database...

排除 sudo : sorry, you must have a tty to run sudo 狀況

2013-07-27 22:43

Linux 主機升級系統後開始收到系統的通知信，某幾個 cron 排程指令有了問題， sudo: sorry, you must have a tty to run sudo 因為是重要的流程，先用 visudo 修改設定將下列參數註解掉 Defaults requiretty 就可以解決這個問題。關於requiretty的解釋如下: If set, sudo will only run when the user is logged in to a real tty. When this...

查某一位使用者所擁有的 Table

2013-07-26 13:42

SQL> set pagesize 100 SQL> column owner format a20 SQL> column OBJECT_NAME format a20 SQL> select owner,object_name from dba_objects where owner='VOIP' and object_type='TABLE'; OWNER ...

查 Datafile 大小

2013-07-26 13:34

[oracle@SIPDB ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 26 13:31:48 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit...

當 ssh-copy-id 出現 ERROR: No identities found

2013-07-23 15:32

$ ssh-keygen -t rsa $ ssh-copy-id remote-machine 公鑰、私鑰已經建立，執行上述指令後出現以下錯誤 /usr/bin/ssh-copy-id: ERROR: No identities found 發現缺少公鑰路徑，使用 -i 參數並加上路徑即可 $ ssh-copy-id -i ~/.ssh/id_dsa.pub user@remote_ip

iSCSI initiator 設定

2013-07-15 22:37

更改 initiatorname [root@voipdb1 iscsi]# cat initiatorname.iscsi InitiatorName=iqn.2013-07.voipdb1:51294dc59990 尋找 iSCSI Server 的 Lun [root@voipdb1 iscsi]# iscsiadm -m discovery -t st -p 192.168.101.1 掛載 iSCSI Server 的...

歷史文章列表