2012年12月4日 星期二

讓 Windows XP支援 exFAT檔案格式

 
下載更新:

WebAPP .bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
 . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/usr/lib/oracle/11.2/instantclient_11_2

export PATH
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/instantclient_11_2
export TNS_ADMIN=/usr/lib/oracle/11.2/instantclient_11_2/tns
SQLPATH=/usr/lib/oracle/11.2/instantclient_11_2
export SQLPATH
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_LANG

APACHE_HOME=/usr/local/apache2
export APACHE_HOME
WL_HOME=/home/gs34/Oracle/Middleware/wlserver_10.3
export WL_HOME
DOMAIN_HOME=/home/gs34/Oracle/Middleware/user_projects/domains/base_domain
export DOMAIN_HOME
INSTALL_HOME=${DOMAIN_HOME}/INSTALL/gs34
export INSTALL_HOME

EBAO_HOME=${DOMAIN_HOME}/EBAO_HOME
export EBAO_HOME

EBAO_TMP_HOME=${DOMAIN_HOME}/EBAO_TMP_HOME
export EBAO_TMP_HOME

EBAO_ARCH_HOME=${DOMAIN_HOME}/EBAO_ARCH_HOME
export EBAO_ARCH_HOME

EXT_LIB_HOME=${EBAO_HOME}/share_lib
export EXT_LIB_HOME


BATCH_HOME=${EBAO_HOME}/applications/batch/bin
export BATCH_HOME

EBAO_CLASSPATH=${EBAO_HOME}/share_lib:${EBAO_HOME}/applications:${EBAO_HOME}/applications/export_tool:${EBAO_HOME}/applications/export_tool/export_lib::${EBAO_HOME}/applications/batch/lib:${EBAO_HOME}/EAR_FILE:${EBAO_HOME}/app_config:${EBAO_HOME}/:${EBAO_HOME}/applications/batch/lib:${DOMAIN_HOME}/applications/insurance/web/WEB-INF/lib/
export EBAO_CLASSPATH

#JAXP="-Djavax.xml.transform.TransformerFactory=org.apache.xalan.processor.TransformerFactoryImpl -Djavax.xml.xpath.XPathFactory=org.apache.xpath.jaxp.XPathFactoryImpl -Djavax.xml.parsers.SAXParserFactory=org.apache.xerces.jaxp.SAXParserFactoryImpl -Djavax.xml.parsers.DocumentBuilderFactory=org.apache.xerces.jaxp.DocumentBuilderFactoryImpl -Djavax.xml.validation.SchemaFactory:http://www.w3.org/2001/XMLSchema=org.apache.xerces.jaxp.validation.XMLSchemaFactory -Djavax.xml.datatype.DatatypeFactory=org.apache.xerces.jaxp.datatype.DatatypeFactoryImpl"
#export JAXP



#CLASSPATH=${INSTALL_HOME}/EBAO_HOME/share_lib
#export CLASSPATH

CLASSPATH="${CLASSPATH}:${CLASSPATHSEP}:${EBAO_CLASSPATH}"
export CLASSPATH

unset USERNAME

GS3.4 script

mount /dev/sdb5 /home/oracle/oracledb
mount /dev/sdc5 /home/oracle/ebao
sh upgrade_db.sh install -prod gs  -seq_value 06 -tbs GS34_SUITE_INIT_TBS \
-tnsname orcl -owner gsuser -ownerpwd gsuserpwd -appuser gsappuser -apppwd \
gsappuserpwd -readuser gsreaduser -readpwd gsreaduserpwd -approle gs_app_role \
-readrole gs_read_role -demodata
 
 
出現錯誤
]$./db/initial_dmp/initial_db_2012-12-04_17-46-57.log

ORA-00959: tablespace 'GS_342_INIT_TBS' does not exist
. . importing table                  "T_AUDIT_LOG"          0 rows imported
. . importing table          "T_AUDIT_OBJECT_TYPE"          7 rows imported
. . importing table           "T_AUDIT_SUB_SYSTEM"         25 rows imported
. . importing table            "T_AUDIT_TRAN_TYPE"         34 rows imported
. . importing table        "T_AUDIT_WARNING_LEVEL"          3 rows imported
. . importing table                 "T_BANK_CLASS"          0 rows imported

2012年12月3日 星期一

Oracle 啟動程序

startup db

sqlplus "/as sysdba"
STARTUP OPEN

listener start

lsnrctl start
lsnrctl status
[root@orcl oracle]# lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-DEC-2012 16:29:27

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                04-DEC-2012 16:22:14
Uptime                    0 days 0 hr. 7 min. 13 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/home/network/admin/listener.ora
Listener Log File         /oracle/diag/tnslsnr/orcl/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

Oracle Enterprise Manager start

emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://orcl:1158/em/console

Virtual Disk 壓縮語法

Mount-VHD -Path "D:\Hyper-V\VMM\Virtual Hard Disks\win2012.vhdx" -ReadOnly
Optimize-VHD -Path "D:\Hyper-V\VMM\Virtual Hard Disks\win2012.vhdx" -Mode Full
Dismount-VHD -Path "D:\Hyper-V\VMM\Virtual Hard Disks\win2012.vhdx"

GParted in RHEL 5.9

http://www.linuxfromscratch.org/blfs/view/svn/general/intltool.html Intltool-0.50.2
./configure --prefix=/usr && make

make install &&
install -v -m644 -D doc/I18N-HOWTO \
    /usr/share/doc/intltool-0.50.2/I18N-HOWTO
gparted
./configure
configure: error: *** uuid library (libuuid) not found
e2fsprogs-devel
./configure --prefix=/usr ; make ; make install ; make install-libs

yum proxy的設定

修改 /etc/yum.conf 
proxy=http://proxy_ip:port