Thứ Tư, 16 tháng 10, 2013

VNCVIEWER via ssh

1) from destination server we need install and configuration vncserver
    a) install vncserver with yum  
     #su - 
     #yum --install vncserver 

    b) start and config vncserver
         start vncserver
         #service start vncserver    
     #vncserver :5901
    
        Config password for vncserver
     #vncpasswd 
 
2) install vncviewer on client  
   #yum install vncviewer
        or
        #rpm -ivh vncviewer*

3) vnc via ssh
     #vncviewer -via "user@host -p port" localhost:1

Thứ Sáu, 13 tháng 9, 2013

Config DNS on OEL5,REHL5

Step1: setup static IP for DNS server #system-config-network
Step2: Install DNS package by yum a)install pakages # yum install bind-libs bind bind-utils b)install GUI DNS editor # yum install bind-libs bind bind-utils
Step3: Create Default config file by system-config-bind #system-config-bind after click various ok we can exit.

Step4: Config server network parameter
a) config hostname, modify content of /etc/sysconfig/network as below
#vi /etc/sysconfig/network
hostname=serapp.gms.com

b) config /etc/resolv.conf file:
#vi /etc/resolv.conf
search prasanna.com
nameserver 192.168.10.60

c) config /etc/hosts file:
#vi /etc/hosts
192.168.10.60 svrapp.gms.com svrapp

Step5: Modify /etc/named.conf follow: #vi named.conf
//start modify
option{
    directory "/var/named";
    dump-file "/var/named/data/cache_dump.db";
    statistics-file "/var/named/data/named_stats.txt";
    listen-on pot 53{127.0.0.1; 192.168.0.254;};
    };
//end modify
//-----------------------------
//start add
zone "gms.com" IN {
    type master;
    file "for.gms.com";
    allow-update { none; };
};
zone "10.168.192.in-addr.arpa." IN {
    type master;
    file "rev.gms.com";
    allow-update { none; };
};
//end add

Step 6: Create of Edit file for.gms.com and rev.gms.com in location /var/named
a) Create or edit for.gms.com: vi /var/named/for.gms.com
$TTL 86400
@ IN SOA srvapp.gms.com. root.srvapp.gms.com. (
    42 ; serial (d. adams)
    3H ; refresh
    15M ; retry
    1W ; expiry
    1D ) ; minimum
    IN NS localhost
localhost IN A 127.0.0.1
ol6-112-rac1 IN A 192.168.10.41
ol6-112-rac2 IN A 192.168.10.42
ol6-112-rac1-priv IN A 192.168.8.41
ol6-112-rac2-priv IN A 192.168.8.42
ol6-112-rac1-vip IN A 192.168.10.43
ol6-112-rac2-vip IN A 192.168.10.44
ol6-112-rac-scan IN A 192.168.10.45
ol6-112-rac-scan IN A 192.168.10.46
ol6-112-rac-scan IN A 192.168.10.47

b) Create or edit rev.gms.com:
$TTL 86400
@ IN SOA srvapp.gms.com. root.srvapp.gms.com. (
         42 ; Serial
         28800 ; Refresh
         14400 ; Retry
         3600000 ; Expire
         86400 ) ; Minimum
     IN NS localhost.
1 IN PTR localhost.
41 IN PTR ol6-112-rac1.gms.com.
42 IN PTR ol6-112-rac2.gms.com.
43 IN PTR ol6-112-rac1-vip.gms.com.
44 IN PTR ol6-112-rac2-vip.gms.com.
45 IN PTR ol6-112-rac-scan.gms.com.
46 IN PTR ol6-112-rac-scan.gms.com.
47 IN PTR ol6-112-rac-scan.gms.com.

Step 7: Start DNS service
service named restart
chkconfig named on
Step 8: Configuration in Client
Client side: in station1.prasanna.com
just touch these files with the existing details
#vi /etc/resolv.conf
search gms.com
nameserver 192.168.10.60

#vi /etc/hosts
192.168.10.60 svrapp.gms.com
192.168.10.41 ol6-112-rac1.gms.com

Step 9: Test
# nslookup ol6-112-rac-scan.localdomain
Server: 192.168.10.60
Address: 192.168.10.60#53
Name: ol6-112-rac-scan.localdomain
Address: 192.168.0.121
Name: ol6-112-rac-scan.localdomain
Address: 192.168.0.122
Name: ol6-112-rac-scan.localdomain
Address: 192.168.0.123

# nslookup 192.168.10.45
Server: 192.168.10.60
Address: 192.168.10.60#53

45.10.168.192.in-addr.arpa name = ol6-112-rac-scan.localdomain.

# nslookup 192.168.10.46
Server: 192.168.10.60
Address: 192.168.10.60#53

46.10.168.192.in-addr.arpa name = ol6-112-rac-scan.localdomain.

# nslookup 192.168.10.47
Server: 192.168.10.60
Address: 192.168.10.60#53

47.10.168.192.in-addr.arpa name = ol6-112-rac-scan.localdomain.

#

Thứ Ba, 10 tháng 9, 2013

lock session and kill log session in oracle database (single node)

1) check information of lock object in oracle database, we need run command below:
select a.session_id,
c.SERIAL#,
a.oracle_username,
a.os_user_name,
b.owner "OBJECT OWNER",
b.object_name,
b.object_type,
a.locked_mode
from (select object_id,
SESSION_ID,
ORACLE_USERNAME,
OS_USER_NAME,
LOCKED_MODE
from v$locked_object) a,
(select object_id, owner, object_name, object_type from dba_objects) b,
v$session c
where a.object_id = b.object_id
and a.session_id=c.SID;
2) kill session show in result above with command:
ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

Thứ Tư, 21 tháng 8, 2013

Siebel 8.1 VM template 'A license key for this software has expired.'

Everything booted up fine except upon startup, I got the classic “server is busy” message.
The server you are trying to access is either busy or experiencing difficulties. Please close the Web browser, open a new browser window, and try logging in again.[19:01:21]
I looked through srvrmgr and saw that all my components were up. Next I dug through the eappweb logs to see:
ProcessPluginRequest ProcessPluginRequestError 1 000000034e660a1b:0 2011-09-06 19:00:32 -1402688624: [SWSE] Failed to obtain a session ID. A license key for this software has expired.
I google’d this and found this thread: https://forums.oracle.com/forums/thread.jspa?messageID=7423036
So I took his approach and inserted records into the S_APP_KEY table. Replace the keys below ‘00001’, ‘00002’, etc. with the demo keys acquired from http://www.oracle.com/us/support/licensecodes/siebel/index.html
insert into S_APP_KEY values ('ROW7', sysdate, '0-1', sysdate, '0-1', 0, 0, null, sysdate, '00001', 'dataimp'); insert into S_APP_KEY values ('ROW8', sysdate, '0-1', sysdate, '0-1', 0, 0, null, sysdate, '00002', 'dataimp'); insert into S_APP_KEY values ('ROW9', sysdate, '0-1', sysdate, '0-1', 0, 0, null, sysdate, '00003', 'dataimp'); insert into S_APP_KEY values ('ROW10', sysdate, '0-1', sysdate, '0-1', 0, 0, null, sysdate, '00004', 'dataimp'); ---http://wentari.blogspot.com--------

Thứ Ba, 2 tháng 7, 2013

Create Cutomize Report forder for EBS R12

Step1:Make the directory structure for your custom application files: cd $APPL_TOP
mkdir ERP_top
mkdir ERP_top/12.0.0
mkdir ERP_top/12.0.0/admin
mkdir ERP_top/12.0.0/admin/sql
mkdir ERP_top/12.0.0/admin/odf
mkdir ERP_top/12.0.0/admin/template
mkdir ERP_top/12.0.0/admin/driver
mkdir ERP_top/12.0.0/html
mkdir ERP_top/12.0.0/mds
mkdir ERP_top/12.0.0/mesg
mkdir ERP_top/12.0.0/patch
mkdir ERP_top/12.0.0/help
mkdir ERP_top/12.0.0/java
mkdir ERP_top/12.0.0/media
mkdir ERP_top/12.0.0/sql
mkdir ERP_top/12.0.0/bin
mkdir ERP_top/12.0.0/reports
mkdir ERP_top/12.0.0/reports/US
mkdir ERP_top/12.0.0/forms
mkdir ERP_top/12.0.0/forms/US
mkdir ERP_top/12.0.0/$APPLLIB
mkdir ERP_top/12.0.0/$APPLOUT
mkdir ERP_top/12.0.0/$APPLLOG
Step2:Add the custom directory to CONTEXT_FILE: vi $CONTEXT_FILE
add custom path top to the file follow:
/d01/oracle/PROD/apps/apps_st/appl/ERP_top/12.0.0 Step3:Register your Oracle Directory: Login to Applications with System Administrator responsibility
Navigate to Application-->Register
Application = ERP_custom
Short Name = ERPTOP
Basepath = ERP_TOP
Description = Custom Application
Step4:Add Application to a Data Group:
Navigate to Security-->Oracle-->DataGroup
Data Group = ERP_GROUP
Description = ERP Custom Data Group
Click on “Copy Applications from” and pick Standard data Group, then add the following entry.
Application = ERP_custom
Oracle ID = APPS
Description = Custom Application
Step5:run autoconfig for update environment parameter file/br> cd $ADMIN_SCRIPT_HOME
./adautocfg.sh

Step6: Restart application cd $ADMIN_SCRIPT_HOME
./adstpall.sh apps/apps
./adstral.sh apps/apps

Now, we can define program with Application is ERP_custom

Thứ Tư, 26 tháng 6, 2013

Record log in rman with SPOOL

1) Login RMAN $rman target /
2) Turn on output logfile RMAN> SPOOL LOG to '/home/oracle/crosscheck.txt'
3) Execute command will be keep log
Example:RMAN> crosscheck backupset;
4) Turn off output logfile RMAN> SPOOL LOG OFF;
--------------------------------------------------
RMAN target /
SPOOL LOG to '/home/oracle/audit_sep.txt';
crosscheck backupset;
crosscheck backup of controlfile;
crosscheck archivelog all;
SPOOL LOG OFF;

Thứ Ba, 25 tháng 6, 2013

Fix VLC bad sound in Linux Ubuntu 12.04

After install Ubuntu 12.04, the most of bad thing in this Distribute is sound quality of VLC. For fix this, i take follow solution bellow.

1) Open Terminal and Edit file default.pa: sudo gedit /etc/pulse/default.pa input password and press ENTER

2) lookup load-module module-udev-detect and modify follow: load-module module-udev-detect tsched=0 Click save, reopen VLC and listen with new quality.

Thứ Tư, 19 tháng 6, 2013

ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

When check Oracle database alert log, we found message: ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

Cause
The core of this error is kernel limit parameter too slow. Example # cat /proc/sys/fs/aio-max-nr
65536
# cat /proc/sys/fs/aio-nr
65536
Solution:
We can increase aio-max-nr for resolver this error Example: Change kernel parameter: # sysctl -w fs.aio-max-nr=3145728 Check again: # cat /proc/sys/fs/aio-max-nr
3145728
If problem continues, we need to try configuration system parameter higher.

Thứ Sáu, 14 tháng 6, 2013

Install Keypass on Ubuntu

keepass is software for generate pass and keep password. For install keepass we need open Terminal and take command follow: sudo apt-add-repository ppa:jtaylor/keepass sudo apt-get update sudo apt-get install keepass2

Thứ Tư, 12 tháng 6, 2013

Apply Patch EBS R12

1) Download Patch from Metalink and uzip patch file.

2) set Enviroment parameter by run env file.
. /oracle/erp/R12/apps/apps_st/appl/APPSERPR12_erp.env

3) Stop Application Services
$INST_TOP/admin/scripts/adstpall.sh apps/apps

4) Change system to maintain mode
sqlplus -s apps/apps @$APPL_TOP/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE

5) apply patch
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u7677429.log patchtop=/d01/7677429 interactive=yes workers=8

6) Take system out of maintain mode
sqlplus -s apps/apps @$APPL_TOP/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE

7) Start EBS application services
$INST_TOP/admin/scripts/adstrtal.sh apps/apps

How To Install Unikey on Ubuntu 12.04

1) Open Termial and Install Ibus-unikey sudo apt-get install ibus-unikey

2) Open System Setting> Language Support > Keyboard input method: Ibus


3) Reboot system  sudo reboot 4)  On top of right click icon Keyboard  >  Preference >  Input Method >  Customize Active Method input > Vietnamese: Unikey > add > close