JDE - 執行fat-client必須要有的兩個security授權

在JDE 9.0，在fat-client執行solution explorer，必須要有兩個security授權，如下圖。

JDE - Oracle HTTP Server - start using oracle account

Oracle 10g HTTP Server: Solving "[crit] (13)Permission denied: make_sock: could not bind to port 83"

There is a trick that httpd port under 1024 need to run as root initially. (e.g. port=83)
Here's the configuration steps:

1. su -

2. cd /u01/OracleAS_1/Apache/Apache/bin

3. chown root .apachectl

4. chmod 6750 .apachectl

5. ls -al .apachectl

6. su - oracle
   cd /u01/OracleAS_1/opmn/bin
   ./opmnctl stopall
   ./opmnctl startall



[root@e1oas03 init.d]# cat /etc/init.d/ias
#!/bin/sh
#
# Author : Arun Singh, Novell Inc.
#
# 1. Add root to dba and oinstall group to function this script properly
#
# 2. Create this file in /etc/init.d directory (ias) and use "chkconfig ias on"
# You can put these and other commands in a single file (startup or shutdown)
# and use as single command. This example is to make instruction clear.
# $ORACLE_HOME/dcm/bin/dcmctl startup
# $ORACLE_HOME/opmn/bin/opmnctl start
# $ORACLE_HOME/bin/emctl start iasconsole
#
### BEGIN INIT INFO
# Provides: ias
# Required-Start: $network $syslog $remote_fs raw
# Required-Stop:
# Default-Start: 3 5
# Default-Stop: 0 1 2 6
# Description: Start the Oracle iAS
### END INIT INFO
ORACLE_BASE=/u01
ORACLE_HOME=$ORACLE_BASE/OracleAS_1
ORA_OWNER=oracle
case "$1" in
'start')
echo -n "Satring Oracle iAS"
#su - $ORA_OWNER --command="$ORACLE_HOME/dcm/bin/dcmctl start" &
#su - $ORA_OWNER --command="$ORACLE_HOME/opmn/bin/opmnctl start" &
su - $ORA_OWNER --command="$ORACLE_BASE/JDE_HOME/bin/startAgent" &
su - $ORA_OWNER --command="$ORACLE_HOME/opmn/bin/opmnctl startall" &
#su - $ORA_OWNER --command="$ORACLE_HOME/bin/emctl start iasconsole" &
;;
'stop')
echo -n "Stopping Oracle iAS"
#su - $ORA_OWNER --command="$ORACLE_HOME/dcm/bin/dcmctl shutdown" &
su - $ORA_OWNER --command="$ORACLE_HOME/opmn/bin/opmnctl stopall" &
su - $ORA_OWNER --command="$ORACLE_BASE/JDE_HOME/bin/stopAgent" &
#su - $ORA_OWNER --command="$ORACLE_HOME/bin/emctl stop iasconsole" &
;;
'status')
echo -n "Checking for Oracle iAS"
su - $ORA_OWNER --command="$ORACLE_HOME/bin/emctl status iasconsole" &
;;
*)
echo "Usage: $0 {start|stop|status}"
exit 1
esac
#
exit
[root@e1oas03 init.d]#

cd /sbin
chkconfig --add ias
chkconfig --list|grep ias

單車 - 花東

路線圖
http://goo.gl/maps/0Bs3g

JDE - 簡易版的DR for Deployment Server

JDE Deployment Server 上面的檔案數量很多，所以他的 異地備援，特別是跨國際的異地備援，如果沒有使用Storage level or file system level的工具，會是一個困難。

這邊想到一個簡單的方式，可以解決這個問題。
1. 將Deployment Server(ServerA) P2V 轉換成 VM(ServerB)，並更改主機名稱後開機。
2. 在此ServerB上面安裝FastCopy軟體，排成每天利用Fastcopy sync ServerA的JDE目錄到dropbox folder。

3. 則dropbox目錄會自動被分到雲端。
4. 將ServerB 的 VM image file copy 到遠端機房，並且改名為ServerC後開啟。
5. 在ServerC也安裝dropbox，設定好 Dropbox location。
6. 之後如果ServerA上面有任何檔案異動，則會每天自動透過dropbox機制sync到遠端去。


另可以參考其他的copy and sync工具:
http://www.wretch.cc/blog/dlinktwblog/10029894

蘋果這是哪一招?

蘋果推出了 iPad 4 and iPad mini

iPad mini
http://www.apple.com/ipad-mini/specs/

Depth 7.2mm, Weight 0.68 lb
Dual-core A5 CPU
7.9-inch display with IPS technology
1.2MP photos, 720 HD video
Lightning t oUSB Cable


iPad 4

Dual-core A6X CPU with quad-core graphics

Oracle VM - OVMAPI_4010E Attempt to send command: discover_server to server: 192.168.xxx.xxx failed.

[Error Message on VM Manager Console]
OVMAPI_4010E Attempt to send command: discover_server to server: 192.168.xxx.xxx failed.


[/var/log/ovs-agent.log on VM Server]


[2012-10-15 15:05:21 2478] DEBUG (OVSCommons:124) discover_server: ()
[2012-10-15 15:05:21 2478] ERROR (OVSCommons:143) catch_error: rpmdb open failed
Traceback (most recent call last):
  File "/opt/ovs-agent-3.0/OVSCommons.py", line 141, in wrapper
    return func(*args)
  File "/opt/ovs-agent-3.0/OVSDiscoverServer.py", line 129, in discover_server
    pkgs = host.list_package('ovs-agent')
  File "/opt/ovs-agent-3.0/host.py", line 235, in list_package
    mi = ts.dbMatch("name", name)
TypeError: rpmdb open failed


這時就是VM Server端的rpmdb出了問題，用下列方式run一遍，重建rpmdb後，再到VM manager的console做rediscover即可解決。

# tar cvzf rpmdb-backup.tar.gz /var/lib/rpm
# rm /var/lib/rpm/__db.00*
# rpm --rebuilddb
# rpm -qa | sort ---> # to make sure everything's okay

Oracle DB Basis - Authentication and SQL LOADER

Authentication 

OS authentication

1. 設定方式: In parameter file, remote_login_passwordfile = none

Use a password file

remote_login_passwordfile = exclusive

1. 用orapwd程式，來建立password file
2. 如果是用dbca來建立database的，則系統會自動建立password file

SQL Loader

sqlldr system/second3@second3 control=first_tbl.ctl log=first_tbl.log

Segment Space Management

轉載自  http://www.dba-oracle.com/t_automatic_segment_space_management.htm

Automatic segment space management (ASSM, or bitmap freelists) is a simpler and more efficient way of managing space within a segment. It completely eliminates any need to specify and tune the pctused, freelists, and freelist groups storage parameters for schema objects created in the tablespace. If any of these attributes are specified, they are ignored.