下載更新:
2012年12月4日 星期二
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 dbconsoleOracle 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 founde2fsprogs-devel
./configure --prefix=/usr ; make ; make install ; make install-libs
訂閱:
文章 (Atom)