Brian notepad

May 15, 2008

Sharepoint - 備分與還原

在 Sharepoint 的 8001 建立一個與 8000 一模一樣的網站.
使用 WSS 專用的 STSATM 指令，進行網站 8000 的備份，再還原至新增網站 8001！STSADM 網站指令放在 C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\ 之下.
備份網站備份之指令為 stsadm.exe -o backup -url http://server:8000 -filename backup.dat
還原網站備份之指令為 stsadm.exe -o restore –url http://server:8001 -filename backup.dat

May 13, 2008

Sharepoint - 管理員已經封鎖下列檔案

於 Sharepoint 上傳文件時, 遭遇 "管理員已經封鎖下列檔案" 錯誤訊息.
原因為:
Sharepoint server 在安全性上的考量,會封鎖如 exe , bat 等等的資料類型上傳 .
若ㄧ定需要允許上傳,則透過 Sharepoint 管理中心-> 作業 -> 安全性設定 -> 被拒的檔案類型, 即可進行變更

May 12, 2008

linux sar

SAR 範例:
取得本月20號 11:00:00~19:00:00 的 CPU/Memory/IO 方式.
CPU -> sar -u -s 11:00:00 -e 19:00:00 -f /var/log/sa/sa20
Memory -> sar -r -s 11:00:00 -e 19:00:00 -f /var/log/sa/sa20
IO -> sar -d -s 11:00:00 -e 12:00:00 -f /var/log/sa/sa20

取得本月18號整天 I/O 資料
IO -> sar -u -f /var/log/sa/sa18

May 7, 2008

Good and usful Metalink Notes

Applications FAQ

Note Id:285267.1 Oracle E-Business Suite 11i and Database FAQ
Note Id:177610.1 Oracle Forms in Applications FAQ

Cloning

Note Id:216664.1 FAQ: Cloning Oracle Applications Release 11i
Note Id:230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
Note Id:364565.1 Troubleshooting RapidClone issues with Oracle Applications 11i
Note Id:398619.1 Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)

Oracle Applications with Oracle Application Server

Note Id:186981.1 Oracle Application Server with Oracle E-Business Suite Release 11i FAQ
Note Id:233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note Id:295606.1 Oracle Application Server 10g with Oracle E-Business Suite Release 11i Troubleshooting

Autoconfig

Note Id:218089.1 Autoconfig FAQ
Note Id:315674.1 How To Verify if Autoconfig is Enabled on 11.5.x
Note Id:165195.1 Using AutoConfig to Manage System Configurations with Oracle Applications 11i
Note Id:341322.1 How to change the hostname of an Applications Tier using AutoConfig
Note Id:270519.1 Customizing an AutoConfig Environment

Oracle Applications and Database

Note Id:362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)

Oracle Applications And RAC

Note Id:220970.1 RAC: Frequently Asked Questions
Note Id:294652.1 E-Business Suite 11i on RAC : Configuring Database Load balancing & Failover
Note Id:312731.1 Configuring Oracle Applications Release 11i with 10g RAC and 10g ASM

DMZ with Oracle Applications

Note Id:287176.1 DMZ Configuration with Oracle E-Business Suite 11i
Note Id:377856.1 DMZ Reverse Proxy and Middle Tier In Different Domains

SSL and Oracle Applications

Note Id:123718.1 11i: A Guide to Understanding and Implementing SSL for Oracle Applications
Note Id:340178.1 Enabling SSL with Oracle Application Server 10g and the E-Business Suite

Shared APPL_TOP and Application Tier Filesystem

Note Id:243880.1 Shared APPL_TOP FAQ
Note Id:233428.1 Sharing the Application Tier File System in Oracle Applications 11i

Patching

Note Id:174436.1 Oracle Applications Patching FAQ
Note Id:224875.1 Installation, Patching & Upgrade Frequently Asked Questions (FAQ's)
Note Id:139684.1 Oracle Applications Current Patchset Comparison Utility - patchsets.sh
Note Id:374915.1 HRMS PATCH INSTALL FAQ
Note Id:130608.1 ADPATCH BASICS
Note Id:314540.1 What Log Files are Generated with Adpatch, and Where are They Located?
Note Id:229423.1 Troubleshooting adpatch complaining of apps.zip existence issues
Note Id:136342.1 How To Apply a Patch in a Multi-Server Environment

Concurrent Managers

Note Id:69336.1 Basic information about Concurrent Managers
Note Id:105133.1 Concurrent Manager Questions and Answers Relating to Generic Platform
Note Id:241370.1 Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment
Note Id:210062.1 Generic Service Management (GSM) in Oracle Applications 11i

System Administration

Note Id:189487.1 System Administration FAQ's

Troubleshooting

Note Id:342332.1 Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 – 11.5.10+)
Note Id:104531.1 Troubleshooting (Report Review Agent)

Portal with Oracle Applications

Note Id:305918.1 Using Oracle Portal 10g with Oracle E-Business Suite 11i

Single Sign-On with Oracle Applications

Note Id:233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note Id:114534.996 OFA Single Sign-on through Apps 11i
Note Id:295606.1 Troubleshooting SSO with Oracle Applications

Online hot backup

Using OS Level copy command to backup oracle database
1. Make sure database in archive log mode.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ora/ora920/archlog/PROD
Oldest online log sequence 41288
Next log sequence to archive 41294
Current log sequence 41294
SQL>

If not archive log mode , modify init parameter file , add following parameter
log_archive_start = true
log_archive_dest_1 = "location=/ora/ora920/archlog/PROD"
log_archive_format = PROD_%t_%s.arc

2. Bring tablespace one by one to backup mode(Exclude temp tablespace).
alter tablespace xxx begin backup;

or
bring whole database to backup mode.
alter database begin backup;

3. Copy all datafile to backup disk.

4. Bring tablespace one by one to end-backup(Exclude temp tablespace).
alter tablespace xxx end backup;

or
bring whole database to end-backup mode.
alter database end backup;

5. Generating after end backup redo log.
alter system archive log current;
or
alter system switch logfile;

6. Copy all archived logs that generated during backup period to backup disk.

May 6, 2008

將 AD 帳號全部 disabled

Const ADS_PROPERTY_UPDATE = 2
' multiple users
Set objOU = GetObject("ldap://cn=Users,dc=king,dc=com,dc=tw/")
' Filter on user objects.'objOU.Filter = Array("user")
' Enumerate user objects.
For Each objUser In objOU
'msgbox("name:"+objUser.name)
On Error Resume Next
objUser.Put "AccountDisabled", True
' Save changes.
objUser.SetInfo
Next
msgbox("Finished!")

若尋找單一帳號, 可用
Set oUser = GetObject("WinNT://simplo-tw/brian_chang,user")
msgbox(oUser.AccountDisabled)
'True 表示帳號停用狀態中