[Oralce] Enlarge redo log files

Enlarge redo log files
1. create new log files
su - orabp1sqlplus /nolog
SQL>connect / as sysdba
alter database add logfile group 21 ('/oracle/BP1/origlogA/log_g21_m1.dbf', '/oracle/BP1/mirrlogA/log_g21_m2.dbf') size 500M;
alter database add logfile group 23 ('/oracle/BP1/origlogA/log_g23_m1.dbf', '/oracle/BP1/mirrlogA/log_g23_m2.dbf') size 500M;
alter database add logfile group 22 ('/oracle/BP1/origlogB/log_g22_m1.dbf', '/oracle/BP1/mirrlogB/log_g22_m2.dbf') size 500M;
alter database add logfile group 24 ('/oracle/BP1/origlogB/log_g24_m1.dbf', '/oracle/BP1/mirrlogB/log_g24_m2.dbf') size 500M;

2.Initiate a log switch beforehand alter system switch logfile;

3.delete old redo log files
alter database drop logfile group 11;
alter database drop logfile group 12;
alter database drop logfile group 13;
alter database drop logfile group 14;

[SAP]安裝online document(直接連網方式)

SAP中設定Document PATH,直接連網至SAP help網站,確保取得最新online document.

限制為需確保user端可連上internet!

A.T-code SR13(或SPROà "SAP Reference IMG" buttonà SAP Netweaver -> General Settings -> Setting Variants for Help (SAP library))

B. in the "PlainHtmlHttp" folder to modify the help file path
Variant : OnlineDocs

Platform: WN32

Area : IWBHELP

Server Names:http:///help.sap.com

Path : saphelp_nw70/helpdata

Lanuage : EN

Default : V

[SAP]change system time zone

T-code: STZAC

Steps

1.choose yes

2.change the time zone you want and remember to save.

[SAP][PI]How To Install and configure external drivers for the JDBC & JMS Adapters on SAP PI 7.0

Prerequisite:
1.download related jdbc drivers,for example oracle 10g:ojdbc14.jar(you could download here )
### Chinese notes for Louis-self ###
### ojdbc driver有分oracle版本要注意 ###
2.download drivertool provided by SAP(you could download here or here)
------------------------------------------------------------------------------------------------
STEPS
1.1 backup an Existing aii_af_jmsproviderlib.sda
/usr/sap//DVEBMGS/SDM/root/origin/sap.com/com.sap.aii.af.jmsproviderlib/SAP AG/3.0.0220040608173429.0000/aii_af_jmsproviderlib .sda

1.2 Creating an Empty aii_af_jmsproviderlib.sda













1.3 Adding Driver JARs to aii_af_jmsproviderlib.sda

Then the aii_af_jmsproviderlib.sda file is ready to deploy to your PI system by SDM.

1.4 Deploying aii_af_jmsproviderlib.sda on the J2EE Engine

A. start SDM GUI(RemoteGUI.bat locate on D:\usr\sap\\DVEBMGS02\SDM\program)

B.Login SDM and select Deployment tabC.Choose the ADD icon and select theaii_af_jmsproviderlib.sda file youjust created.

D.choose Next->Next->start Deployment->confirm

1.5 finally, restart your J2EE server.It's done!

Reference document:

https://www.sdn.sap.com/irj/sdn/howtoguides

How to Install and Configure External Drivers for JDBC JMS

[SAP]設定SAPOSS連線(RFC)

1.Tcode:SM59

2. 點選編輯圖示-->Logon&Security頁籤,然後輸入oss帳號(如Sxxxxxxxxx)與密碼

3. 切換到Technical setting頁籤,分別在target host跟system number欄位輸入相關資訊

如target host:/H/10.10.129.39/S/3299/H/194.39.131.34/S/3299/H/oss001

然後按儲存按鈕,最後執行connection test

4.執行正確結果如下圖

[AIX] 啟動CDE環境(X-Window)

1.check if the X11.Dt are installed :

# lslpp -l grep X11.Dt

2.If installed start the daemon :

/usr/dt/bin/dtlogin –daemon

3.check if the daemon is running :

# ps -ef grep dt

[SAP]define standard jobs (housekeeping)

1.T-CODE:SM36-->點Standard jobs按鈕

2.再點Define Scheduling即完成,會出現許多預設的standard job

[SAP]設定印表機(使用User電腦上之印表機方式)

1.T-code(spad)-->Configuration-->Output Devices

2.change(按鈕)-->Output Devices-->create

3.輸入相關欄位

Output Device:想要的印表機名稱

Short name:想要的印表機代號

Device Type:必須選 SAPWIN

Device Class:必須選Standard printer

4.切換至Access Method頁籤

Host Printer:必須輸入 __DEFAULT

5.最後按Save按鈕即完成

[SAP]安裝online document

Installing the SAP Online Documentation

1.決定Online Document類型(通常使用PlainHtmlFile)

2.安裝Online Document至可供其他電腦透過File Share(檔案分享)存取的伺服器

A.取得Documentation DVD(通常為紫色)

B.執行E:\English\PlainHTML\PLAINHTM\INSTALL\WINDOWS\Install.exe

輸入要安裝Online Document的路徑

3.SAP中設定Document PATH

A.T-code SR13(或SPROà "SAP Reference IMG" buttonà SAP Netweaver -> General Settings -> Setting Variants for Help (SAP library))

B. in the "PlainHtmlFile" folder to modify the help file path

Variant : Online_Help
Platform : WN32
Area : IWBHELP
Path : file://cmymides/C$/SAPHelp/PlainHTML/helpdata
Lanuage : EN
Default : V

[SAP] Client Copy

1.create logical system

1.1 Login to client 001

1.2 T-CODE(spro)-->SAP Reference IMG-->SAP NetWeaver-->Application Server-->IDoc Interface / Application Link Enabling (ALE)-->Logical Systems-->Define Logical System

1.3 New Entries-->輸入Log.System與Name欄位-->Save後離開








2.create new client

2.1 Login to client 000

2.2 T-CODE(scc4)-->Display to Change-->在client000上按右鍵copy as

2.3 填入相關欄位與依據client定位設定object overwrite權限






3.Activate kernel user SAP*

3.1 Set the profile parameter login/no_automatic_user_sapstar to 0. 3.2 Restart the application server.


4.perform client copy
4.1 Log on to the new client with kernel user SAP* and password PASS.
4.2 Copy client 000 with transaction SCCL and profile SAP_CUST.
4.3 Check the log files with transaction SCC3.





5.Deactivate kernel user SAP*
5.1 Reset login/no_automatic_user_sapstar to 1

[SAP]設定預設語言與Login text

Q:設定SAPGui預設語言
A:修改profile中之參數(M為繁體中文)
zcsa/system_language = M

Q:設定登入畫面之Login Text
A:SE61


Q：Login text設定之後，預設英文有用但改成繁體中文就沒用
A：先確認ZLOGIN_SCREEN_INFO object是否需要translate
SE16table name(DOKIL)


如果有X就表示需要translate


再到 SE63




完成這些步驟即可

[SAP]

Q:設定SAPGui預設語言
A:修改profile中之參數(M為繁體中文) zcsa/system_language = M

Q:設定登入畫面之Login Text
A:SE61à

Q：Login text設定之後，預設英文有用但改成繁體中文就沒用
A：先確認ZLOGIN_SCREEN_INFO object是否需要translate
SE16àtable name(DOKIL)
如果有X就表示需要translate

再到 SE63
完成這些步驟即可