Save the below to file '/path/to/vmware-config.patch'
#### Begin ####
--- /usr/bin/vmware-config.pl.orig 2008-11-28 12:06:35.641054086 +0100
+++ /usr/bin/vmware-config.pl 2008-11-28 12:30:38.593304082 +0100
@@ -4121,6 +4121,11 @@
return 'no';
}
+ if ($name eq 'vsock') {
+ print wrap("VMWare config patch VSOCK!\n");
+ system(shell_string($gHelper{'mv'}) . ' -vi ' . shell_string($build_dir . '/../Module.symvers') . ' ' . shell_string($build_dir . '/vsock-only/' ));
+ }
+
print wrap('Building the ' . $name . ' module.' . "\n\n", 0);
if (system(shell_string($gHelper{'make'}) . ' -C '
. shell_string($build_dir . '/' . $name . '-only')
@@ -4143,6 +4148,10 @@
if (try_module($name, $build_dir . '/' . $name . '.o', 0, 1)) {
print wrap('The ' . $name . ' module loads perfectly into the running kernel.'
. "\n\n", 0);
+ if ($name eq 'vmci') {
+ print wrap("VMWare config patch VMCI!\n");
+ system(shell_string($gHelper{'cp'}) . ' -vi ' . shell_string($build_dir.'/vmci-only/Module.symvers') . ' ' . shell_string($build_dir . '/../'));
+ }
remove_tmp_dir($build_dir);
return 'yes';
}
### End ###
run before you install
patch ./vmware-server-distrib/bin/vmware-config.pl /path/to/vmware-config.patch
Thanks
Wednesday, October 28, 2009
Wednesday, October 21, 2009
Trace Session in Oracle.
There are many way to trace session in oracle, 'trcsess' is the one way to do that.
trcsess [output=
trcsess [output=
Monday, October 19, 2009
How to enable IPF on solaris 10
*** Edit configure file at '/etc/ipf/ipf.conf'
#
# ipf.conf
#
# IP Filter rules to be loaded during startup
#
# See ipf(4) manpage for more information on
# IP Filter rules syntax.
# Block any packets which are too short to be real
block in log quick all with short
#
# drop and log any IP packets with options set in them.
block in log all with ipopts
#
# Allow all traffic on loopback.
pass in quick on lo0 all
pass out quick on lo0 all
#
# Public Network. Block everything not explicity allowed.
block in on ce0 all
pass out on ce0 all
#
# Allow pings out.
pass out quick on ce0 proto icmp all keep state
#
# Allow outbound state related packets.
pass out quick on ce0 proto tcp/udp from any to any keep state
#
# allow ssh from 172.16.0.0/16 only.
# pass in log quick on ce0 from 172.16.0.0/16 to 172.16.1.100/32 port = 22
# Actually, allow ssh only from ben, jerry, MSU
pass in log quick on ce0 proto tcp from any to any port = 22
pass in log quick on ce0 proto tcp from any to any port = 1521
*** End file
*** Enable ipfilter by command
[tatshuya#] svcadm enable ipfilter
*** Disable ipfilter
[tatshuya#] svcadm disable ipfilter
*** Reconfig ipfilter
[tatshuya#] svcadm refresh ipfilter
-- TaTsHuYa --
#
# ipf.conf
#
# IP Filter rules to be loaded during startup
#
# See ipf(4) manpage for more information on
# IP Filter rules syntax.
# Block any packets which are too short to be real
block in log quick all with short
#
# drop and log any IP packets with options set in them.
block in log all with ipopts
#
# Allow all traffic on loopback.
pass in quick on lo0 all
pass out quick on lo0 all
#
# Public Network. Block everything not explicity allowed.
block in on ce0 all
pass out on ce0 all
#
# Allow pings out.
pass out quick on ce0 proto icmp all keep state
#
# Allow outbound state related packets.
pass out quick on ce0 proto tcp/udp from any to any keep state
#
# allow ssh from 172.16.0.0/16 only.
# pass in log quick on ce0 from 172.16.0.0/16 to 172.16.1.100/32 port = 22
# Actually, allow ssh only from ben, jerry, MSU
pass in log quick on ce0 proto tcp from any to any port = 22
pass in log quick on ce0 proto tcp from any to any port = 1521
*** End file
*** Enable ipfilter by command
[tatshuya#] svcadm enable ipfilter
*** Disable ipfilter
[tatshuya#] svcadm disable ipfilter
*** Reconfig ipfilter
[tatshuya#] svcadm refresh ipfilter
-- TaTsHuYa --
How to know network interface name in Solaris.
by command 'prtconf -D'
[tatshuya#] prtconf -D |grep network
network, instance #0 (driver name: ce)
network, instance #1 (driver name: ce)
-- TaTsHuYa --
[tatshuya#] prtconf -D |grep network
network, instance #0 (driver name: ce)
network, instance #1 (driver name: ce)
-- TaTsHuYa --
Saturday, October 17, 2009
Automatic start apache in Solaris 10 ( Not use package in solaris )
#!/bin/sh
APACHE_HOME=/usr/local/apache
export APACHE_HOME
case "$1" in
start)
$APACHE_HOME/bin/apachectl start
;;
restart)
$APACHE_HOME/bin/apachectl restart
;;
stop)
$APACHE_HOME/bin/apachectl stop
;;
*)
echo "Usage: apache stop|start|restart"
;;
esac
#### Save file & chmod +x
chmod +x /etc/init.d/apache
#### Create symbolic link
ln -s /etc/init.d/apache /etc/rc0.d/K01apache
ln -s /etc/init.d/apache /etc/rc2.d/K01apache
ln -s /etc/init.d/apache /etc/rc2.d/S90apache
ln -s /etc/init.d/apache /etc/rc3.d/K01apache
ln -s /etc/init.d/apache /etc/rc3.d/S90apache
-- TaTsHuYa --
APACHE_HOME=/usr/local/apache
export APACHE_HOME
case "$1" in
start)
$APACHE_HOME/bin/apachectl start
;;
restart)
$APACHE_HOME/bin/apachectl restart
;;
stop)
$APACHE_HOME/bin/apachectl stop
;;
*)
echo "Usage: apache stop|start|restart"
;;
esac
#### Save file & chmod +x
chmod +x /etc/init.d/apache
#### Create symbolic link
ln -s /etc/init.d/apache /etc/rc0.d/K01apache
ln -s /etc/init.d/apache /etc/rc2.d/K01apache
ln -s /etc/init.d/apache /etc/rc2.d/S90apache
ln -s /etc/init.d/apache /etc/rc3.d/K01apache
ln -s /etc/init.d/apache /etc/rc3.d/S90apache
-- TaTsHuYa --
Automatic start tomcat in Solaris 10 ( Not use package in solaris )
#!/bin/sh
JAVA_HOME=/usr/local/java
CATALINA_HOME=/usr/local/tomcat
export JAVA_HOME CATALINA_HOME
case "$1" in
start)
$CATALINA_HOME/bin/startup.sh
;;
restart)
$CATALINA_HOME/bin/shutdown.sh
$CATALINA_HOME/bin/startup.sh
;;
stop)
$CATALINA_HOME/bin/shutdown.sh
;;
*)
echo "Usage: tomcat stop|start|restart"
;;
esac
##### save file & chmod +x
chmod +x /etc/init.d/tomcat
##### create symbolic link
ln -s /etc/init.d/tomcat /etc/rc0.d/K01tomcat
ln -s /etc/init.d/tomcat /etc/rc2.d/K01tomcat
ln -s /etc/init.d/tomcat /etc/rc2.d/S90tomcat
ln -s /etc/init.d/tomcat /etc/rc3.d/K01tomcat
ln -s /etc/init.d/tomcat /etc/rc3.d/S90tomcat
-- TaTsHuYa --
JAVA_HOME=/usr/local/java
CATALINA_HOME=/usr/local/tomcat
export JAVA_HOME CATALINA_HOME
case "$1" in
start)
$CATALINA_HOME/bin/startup.sh
;;
restart)
$CATALINA_HOME/bin/shutdown.sh
$CATALINA_HOME/bin/startup.sh
;;
stop)
$CATALINA_HOME/bin/shutdown.sh
;;
*)
echo "Usage: tomcat stop|start|restart"
;;
esac
##### save file & chmod +x
chmod +x /etc/init.d/tomcat
##### create symbolic link
ln -s /etc/init.d/tomcat /etc/rc0.d/K01tomcat
ln -s /etc/init.d/tomcat /etc/rc2.d/K01tomcat
ln -s /etc/init.d/tomcat /etc/rc2.d/S90tomcat
ln -s /etc/init.d/tomcat /etc/rc3.d/K01tomcat
ln -s /etc/init.d/tomcat /etc/rc3.d/S90tomcat
-- TaTsHuYa --
Friday, October 16, 2009
UUID, TYPE, LABEL of device.
[tatshuya]# vol_id /dev/sda5
ID_FS_USAGE=filesystem
ID_FS_TYPE=ext3
ID_FS_VERSION=1.0
ID_FS_UUID=5a13115f-246d-4eb8-a2c9-fa16c9ce9fab
ID_FS_UUID_ENC=5a13115f-246d-4eb8-a2c9-fa16c9ce9fab
ID_FS_LABEL=
ID_FS_LABEL_ENC=
-- TaTsHuYa --
ID_FS_USAGE=filesystem
ID_FS_TYPE=ext3
ID_FS_VERSION=1.0
ID_FS_UUID=5a13115f-246d-4eb8-a2c9-fa16c9ce9fab
ID_FS_UUID_ENC=5a13115f-246d-4eb8-a2c9-fa16c9ce9fab
ID_FS_LABEL=
ID_FS_LABEL_ENC=
-- TaTsHuYa --
Oracle EM Alert.
*** ERROR ***
Collection Timestamp Aug 7, 2009 10:46:33 AM
Error Type Collection Problem
Message snmhsutl.c:executable nmhs should have root suid enabled
*** Cause ***
This error occur because you did not run root.sh when you install oracle agent.
*** Solution ***
run root.sh in oracle agent home.
[root@tatshuya]# /oracle/product/agent10g/root.sh
-- TaTsHuYa --
Collection Timestamp Aug 7, 2009 10:46:33 AM
Error Type Collection Problem
Message snmhsutl.c:executable nmhs should have root suid enabled
*** Cause ***
This error occur because you did not run root.sh when you install oracle agent.
*** Solution ***
run root.sh in oracle agent home.
[root@tatshuya]# /oracle/product/agent10g/root.sh
-- TaTsHuYa --
Resize Datafile in Oracle.
*** Select DATAFILE
select c.name from v$tablespace a, v$datafile b, v$dbfile c where a.TS# = b.TS# and b.FILE# = c.FILE# and a.NAME= 'SYSTEM';
NAME
--------------------------------------------------------------------------------
+DATA1/tatshuya/datafile/system.258.616675057
*** use the result upper
alter database datafile '+DATA1/tatshuya/datafile/system.258.616675057' resize 1G;
-- TaTsHuYa --
select c.name from v$tablespace a, v$datafile b, v$dbfile c where a.TS# = b.TS# and b.FILE# = c.FILE# and a.NAME= 'SYSTEM';
NAME
--------------------------------------------------------------------------------
+DATA1/tatshuya/datafile/system.258.616675057
*** use the result upper
alter database datafile '+DATA1/tatshuya/datafile/system.258.616675057' resize 1G;
-- TaTsHuYa --
Mount ISO File in Solaris
[solaris]# lofiadm -a /<absolute path>/sol-10-u8-ga-sparc-dvd.iso
/dev/lofi/1
[solaris]# mount -F hsfs -o ro /dev/lofi/1 /mnt
[solaris]# ls -l /mnt
total 983
-r--r--r-- 1 root root 6582 Aug 22 02:34 Copyright
-r--r--r-- 1 root root 487593 Aug 22 02:32 JDS-THIRDPARTYLICENSEREADME
drwxr-xr-x 2 root bin 2048 Sep 17 06:06 License
drwxr-xr-x 7 root root 2048 Sep 17 06:07 Solaris_10
drwxr-xr-x 2 root root 2048 Sep 17 06:07 boot
-rwxr-xr-x 1 root root 257 Sep 17 05:54 installer
drwxr-xr-x 5 root root 2048 Sep 17 06:07 platform
-- TaTsHuYa --
/dev/lofi/1
[solaris]# mount -F hsfs -o ro /dev/lofi/1 /mnt
[solaris]# ls -l /mnt
total 983
-r--r--r-- 1 root root 6582 Aug 22 02:34 Copyright
-r--r--r-- 1 root root 487593 Aug 22 02:32 JDS-THIRDPARTYLICENSEREADME
drwxr-xr-x 2 root bin 2048 Sep 17 06:06 License
drwxr-xr-x 7 root root 2048 Sep 17 06:07 Solaris_10
drwxr-xr-x 2 root root 2048 Sep 17 06:07 boot
-rwxr-xr-x 1 root root 257 Sep 17 05:54 installer
drwxr-xr-x 5 root root 2048 Sep 17 06:07 platform
-- TaTsHuYa --
Mount ISO File in Linux
[root@tatshuya]# ls -l /mnt
total 0
[root@tatshuya]# mount -o loop rhel-server-5.4-i386-disc1.iso /mnt
[root@tatshuya]# ls -l /mnt
..
..
..
-r--r--r-- 7 root root 1706 2009-08-04 15:25 RPM-GPG-KEY-redhat-beta
-r--r--r-- 7 root root 1164 2009-08-04 15:25 RPM-GPG-KEY-redhat-release
dr-xr-xr-x 3 root root 94208 2009-08-19 13:35 Server
-r--r--r-- 1 root root 14594 2009-08-19 13:39 TRANS.TBL
dr-xr-xr-x 3 root root 2048 2009-08-19 13:30 VT
-- TaTsHuYa --
total 0
[root@tatshuya]# mount -o loop rhel-server-5.4-i386-disc1.iso /mnt
[root@tatshuya]# ls -l /mnt
..
..
..
-r--r--r-- 7 root root 1706 2009-08-04 15:25 RPM-GPG-KEY-redhat-beta
-r--r--r-- 7 root root 1164 2009-08-04 15:25 RPM-GPG-KEY-redhat-release
dr-xr-xr-x 3 root root 94208 2009-08-19 13:35 Server
-r--r--r-- 1 root root 14594 2009-08-19 13:39 TRANS.TBL
dr-xr-xr-x 3 root root 2048 2009-08-19 13:30 VT
-- TaTsHuYa --
Thursday, October 15, 2009
Bash: If and Case
for ((i=0;i<4;i+=1));
do
case $i in
"0" )
echo "${i} : zero"
;;
"1" )
echo "${i} : one"
;;
esac
if [ ${i} -eq "3" ]; then
echo "Here is number : Three "
fi
done
*** Result ***
0 : zero
1 : one
Here is number : Three
-- TaTsHuYa --
do
case $i in
"0" )
echo "${i} : zero"
;;
"1" )
echo "${i} : one"
;;
esac
if [ ${i} -eq "3" ]; then
echo "Here is number : Three "
fi
done
*** Result ***
0 : zero
1 : one
Here is number : Three
-- TaTsHuYa --
Bash: Loop & Random
*** For Loop ***
for ((i=0;i<10;i+=1)); do
let R=$RANDOM%20;
echo "i=${i} : R=${R}";
done
*** Result For Loop ***
i=0 : R=15
i=1 : R=17
i=2 : R=14
i=3 : R=11
i=4 : R=16
i=5 : R=14
i=6 : R=16
i=7 : R=8
i=8 : R=12
i=9 : R=5
*** While Loop ***
i=0
while [ $i -lt 10 ]; do
let R=$RANDOM%20;
echo "i=${i} : R=${R}";
(( i+=1 ));
done
*** Result While Loop ***
i=0 : R=6
i=1 : R=19
i=2 : R=13
i=3 : R=19
i=4 : R=7
i=5 : R=3
i=6 : R=16
i=7 : R=5
i=8 : R=19
i=9 : R=4
-- TaTsHuYa --
for ((i=0;i<10;i+=1)); do
let R=$RANDOM%20;
echo "i=${i} : R=${R}";
done
*** Result For Loop ***
i=0 : R=15
i=1 : R=17
i=2 : R=14
i=3 : R=11
i=4 : R=16
i=5 : R=14
i=6 : R=16
i=7 : R=8
i=8 : R=12
i=9 : R=5
*** While Loop ***
i=0
while [ $i -lt 10 ]; do
let R=$RANDOM%20;
echo "i=${i} : R=${R}";
(( i+=1 ));
done
*** Result While Loop ***
i=0 : R=6
i=1 : R=19
i=2 : R=13
i=3 : R=19
i=4 : R=7
i=5 : R=3
i=6 : R=16
i=7 : R=5
i=8 : R=19
i=9 : R=4
-- TaTsHuYa --
Wednesday, October 14, 2009
NTP Server
Here is my configure to setup ntp server
'/etc/ntp.conf'
driftfile /var/lib/ntp/ntp.drift
restrict default ignore
statistics loopstats peerstats clockstats
filegen loopstats file loopstats type day enable
filegen peerstats file peerstats type day enable
filegen clockstats file clockstats type day enable
# Server that we want to sync time from.
restrict 66.187.233.4 mask 255.255.255.255 nomodify notrap noquery
server 66.187.233.4 prefer
# Client group that access to our ntp server.
restrict 127.0.0.1
restrict 192.168.0.0 mask 255.255.0.0 nomodify
server 127.127.1.0 # local clock
fudge 127.127.1.0 stratum 10
-- TaTsHuYa --
'/etc/ntp.conf'
driftfile /var/lib/ntp/ntp.drift
restrict default ignore
statistics loopstats peerstats clockstats
filegen loopstats file loopstats type day enable
filegen peerstats file peerstats type day enable
filegen clockstats file clockstats type day enable
# Server that we want to sync time from.
restrict 66.187.233.4 mask 255.255.255.255 nomodify notrap noquery
server 66.187.233.4 prefer
# Client group that access to our ntp server.
restrict 127.0.0.1
restrict 192.168.0.0 mask 255.255.0.0 nomodify
server 127.127.1.0 # local clock
fudge 127.127.1.0 stratum 10
-- TaTsHuYa --
Agent admitted failure to sign using the key.
[tatshuya]# ssh remotehost
Agent admittd failure to sign using the key.
password:
Now, My solution to solve this problem is logout you desktop and login again.
Agent admittd failure to sign using the key.
password:
Now, My solution to solve this problem is logout you desktop and login again.
SSH without password.
[tatshuya]# ssh-keygen -t dsa -b 1024
Generating public/private rsa key pair.
Enter file in which to save the key (/home/tatshuya/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
[tatshuya]# ls -al .ssh
-rw------- 1 tatshuya tatshuya 887 Oct 14 04:20 id_rsa
-rw-r--r-- 1 tatshuya tatshuya 244 Oct 14 04:20 id_rsa.pub
*** Then copy public key 'id_rsa.pub' to remote host and rename to 'authorized_keys'
[tatshuya]# scp /home/tatshuya/.ssh/id_rsa.pubtatshuya@remotehost:.ssh/authorized_keys
*** Test connection by ssh
[tatshuya]# ssh remotehost
Last login: Wed Oct 14 16:10:47 2009 from 10.10.10.2
You have new mail.
[remotehost]#
-- TaTsHuYa --
Generating public/private rsa key pair.
Enter file in which to save the key (/home/tatshuya/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
[tatshuya]# ls -al .ssh
-rw------- 1 tatshuya tatshuya 887 Oct 14 04:20 id_rsa
-rw-r--r-- 1 tatshuya tatshuya 244 Oct 14 04:20 id_rsa.pub
*** Then copy public key 'id_rsa.pub' to remote host and rename to 'authorized_keys'
[tatshuya]# scp /home/tatshuya/.ssh/id_rsa.pub
*** Test connection by ssh
[tatshuya]# ssh remotehost
Last login: Wed Oct 14 16:10:47 2009 from 10.10.10.2
You have new mail.
[remotehost]#
-- TaTsHuYa --
Tuesday, October 13, 2009
How to know the interface speed and duplex in your linux.
[tatshuya]# ethtool eth0
Settings for eth0:
Supported ports: [ TP ]
Supported link modes: 10baseT/Half 10baseT/Full
100baseT/Half 100baseT/Full
1000baseT/Full
Supports auto-negotiation: Yes
Advertised link modes: 1000baseT/Full
Advertised auto-negotiation: Yes
Speed: 1000Mb/s
Duplex: Full
Port: Twisted Pair
PHYAD: 0
Transceiver: internal
Auto-negotiation: on
Supports Wake-on: umbg
Wake-on: g
Current message level: 0x00000007 (7)
Link detected: yes
If you want to force speed to 1000 and duplex to full you can set like this.
ethtool -s eth0 speed 1000 duplex full autoneg off
-- TaTsHuYa --
Settings for eth0:
Supported ports: [ TP ]
Supported link modes: 10baseT/Half 10baseT/Full
100baseT/Half 100baseT/Full
1000baseT/Full
Supports auto-negotiation: Yes
Advertised link modes: 1000baseT/Full
Advertised auto-negotiation: Yes
Speed: 1000Mb/s
Duplex: Full
Port: Twisted Pair
PHYAD: 0
Transceiver: internal
Auto-negotiation: on
Supports Wake-on: umbg
Wake-on: g
Current message level: 0x00000007 (7)
Link detected: yes
If you want to force speed to 1000 and duplex to full you can set like this.
ethtool -s eth0 speed 1000 duplex full autoneg off
-- TaTsHuYa --
Grep command.
if you want to grep one word on the file you can type grep .
Ex.
grep facebook cookies.txt
.facebook.com TRUE / FALSE 1256032076 locale en_GB
but when you want to grep or , this command will help you.
grep "facebook\|zynga" cookies.txt
.facebook.com TRUE / FALSE 1256032076 locale en_GB
mwfb.zynga.com FALSE /mwfb/ FALSE 1255435201
I can use the upper command only in Linux but in Solaris use this pattern
'/usr/xpg4/bin/grep -E 'facebook|zynga' cookies.txt'
-- TaTsHuYa --
Ex.
grep facebook cookies.txt
.facebook.com TRUE / FALSE 1256032076 locale en_GB
but when you want to grep
grep "facebook\|zynga" cookies.txt
.facebook.com TRUE / FALSE 1256032076 locale en_GB
mwfb.zynga.com FALSE /mwfb/ FALSE 1255435201
I can use the upper command only in Linux but in Solaris use this pattern
'/usr/xpg4/bin/grep -E 'facebook|zynga' cookies.txt'
-- TaTsHuYa --
Monday, October 12, 2009
List process id.
Today I learn to use the new command that use to list process id
pgrep sendmail
12615
12625
if you want to see the name of process, use -l
pgrep -l sendmail
12615 sendmail
12625 sendmail
-- TaTsHuYa --
pgrep sendmail
12615
12625
if you want to see the name of process, use -l
pgrep -l sendmail
12615 sendmail
12625 sendmail
-- TaTsHuYa --
Wednesday, October 07, 2009
How to check which scheduler job run longer than 1000 seconds.
Today we found scheduler job running very long time, and I want to create script to check which job has been running more than 1000 seconds.
desc ALL_SCHEDULER_RUNNING_JOBS;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
JOB_NAME NOT NULL VARCHAR2(30)
JOB_SUBNAME VARCHAR2(30)
SESSION_ID NUMBER
SLAVE_PROCESS_ID NUMBER
SLAVE_OS_PROCESS_ID VARCHAR2(12)
RUNNING_INSTANCE NUMBER
RESOURCE_CONSUMER_GROUP VARCHAR2(32)
ELAPSED_TIME INTERVAL DAY(3) TO SECOND(2)
CPU_USED INTERVAL DAY(3) TO SECOND(2)
SQL> select JOB_NAME, ELAPSED_TIME from ALL_SCHEDULER_RUNNING_JOBS where ELAPSED_TIME > INTERVAL '1000' SECOND ;
JOB_NAME ELAPSED_TIME
------------------- ---------------------------------------------------------------------------
JOB_XMLSEND_LDAP +001 13:43:31.84
SENDXML_COLLECTION +004 13:33:31.91
SENDXML_CHARGING +004 21:00:42.84
-- TaTsHuYa --
desc ALL_SCHEDULER_RUNNING_JOBS;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
JOB_NAME NOT NULL VARCHAR2(30)
JOB_SUBNAME VARCHAR2(30)
SESSION_ID NUMBER
SLAVE_PROCESS_ID NUMBER
SLAVE_OS_PROCESS_ID VARCHAR2(12)
RUNNING_INSTANCE NUMBER
RESOURCE_CONSUMER_GROUP VARCHAR2(32)
ELAPSED_TIME INTERVAL DAY(3) TO SECOND(2)
CPU_USED INTERVAL DAY(3) TO SECOND(2)
SQL> select JOB_NAME, ELAPSED_TIME from ALL_SCHEDULER_RUNNING_JOBS where ELAPSED_TIME > INTERVAL '1000' SECOND ;
JOB_NAME ELAPSED_TIME
------------------- ---------------------------------------------------------------------------
JOB_XMLSEND_LDAP +001 13:43:31.84
SENDXML_COLLECTION +004 13:33:31.91
SENDXML_CHARGING +004 21:00:42.84
-- TaTsHuYa --
Tuesday, October 06, 2009
ORA-00600: internal error code, arguments: kghstack_alloc, datablk : kspptsp], [, ], [, ], [, [].
This error occur because I try to start the database that I copied datafile,controlfile,redologfile from RHEL5 to Solaris 10 and try to start it on solaris.
-- TaTsHuYa --
-- TaTsHuYa --
Monday, October 05, 2009
Change data to lower captical in awk.
*** Original data in upper capital
[tatshuya]# cat user-lmi3.txt |awk '{print $1}'
SYS
SYSTEM
DBSNMP
TATSHUYA
*** When you want to change data in lower capital.
[tatshuya]# cat user-lmi3.txt |awk '{print tolower($1) }'
sys
system
dbsnmp
tatshuya
-- TaTsHuYa --
[tatshuya]# cat user-lmi3.txt |awk '{print $1}'
SYS
SYSTEM
DBSNMP
TATSHUYA
*** When you want to change data in lower capital.
[tatshuya]# cat user-lmi3.txt |awk '{print tolower($1) }'
sys
system
dbsnmp
tatshuya
-- TaTsHuYa --
Sunday, October 04, 2009
SSH Password prompt very slow when connect to server.
When I connect to the server I am waiting for password prompt around 15 seconds.
ssh -v 10.10.10.2
....
....
debug1: SSH2_MSG_NEWKEYS sent
debug1: expecting SSH2_MSG_NEWKEYS
debug1: SSH2_MSG_NEWKEYS received
debug1: SSH2_MSG_SERVICE_REQUEST sent
debug1: SSH2_MSG_SERVICE_ACCEPT received
debug1: Authentications that can continue: gssapi-keyex,gssapi-with-mic,publickey,password,keyboard-interactive
debug1: Next authentication method: gssapi-keyex
debug1: No valid Key exchange context
debug1: Next authentication method: gssapi-with-mic
debug1: Unspecified GSS failure. Minor code may provide more information
No credentials cache found
debug1: Unspecified GSS failure. Minor code may provide more information
No credentials cache found
debug1: Unspecified GSS failure. Minor code may provide more information
debug1: Next authentication method: publickey
debug1: Trying private key: /home/boonchai_noo/.ssh/identity
debug1: Trying private key: /home/boonchai_noo/.ssh/id_rsa
debug1: Trying private key: /home/boonchai_noo/.ssh/id_dsa
debug1: Next authentication method: keyboard-interactive
Password:
*** In the debug mode I found there are 3 times to try authentication method : GSSAPI so I man the ssh_config to look how to disable how to disable GSSAPI,
the option is GSSAPIAuthentication = no
I try to login againt with option
[tatshuya]# ssh -v -o GSSAPIAuthentication=no 10.1010.2
....
....
debug1: ssh_rsa_verify: signature correct
debug1: SSH2_MSG_NEWKEYS sent
debug1: expecting SSH2_MSG_NEWKEYS
debug1: SSH2_MSG_NEWKEYS received
debug1: SSH2_MSG_SERVICE_REQUEST sent
debug1: SSH2_MSG_SERVICE_ACCEPT received
debug1: Authentications that can continue: gssapi-keyex,gssapi-with-mic,publickey,password,keyboard-interactive
debug1: Next authentication method: publickey
debug1: Trying private key: /home/boonchai_noo/.ssh/identity
debug1: Trying private key: /home/boonchai_noo/.ssh/id_rsa
debug1: Trying private key: /home/boonchai_noo/.ssh/id_dsa
debug1: Next authentication method: keyboard-interactive
Password:
**** there is no use the authentication method in debug mode and the time for display password prompt faster than before.
Thank you walker for this information.
-- TaTsHuYa --
ssh -v 10.10.10.2
....
....
debug1: SSH2_MSG_NEWKEYS sent
debug1: expecting SSH2_MSG_NEWKEYS
debug1: SSH2_MSG_NEWKEYS received
debug1: SSH2_MSG_SERVICE_REQUEST sent
debug1: SSH2_MSG_SERVICE_ACCEPT received
debug1: Authentications that can continue: gssapi-keyex,gssapi-with-mic,publickey,password,keyboard-interactive
debug1: Next authentication method: gssapi-keyex
debug1: No valid Key exchange context
debug1: Next authentication method: gssapi-with-mic
debug1: Unspecified GSS failure. Minor code may provide more information
No credentials cache found
debug1: Unspecified GSS failure. Minor code may provide more information
No credentials cache found
debug1: Unspecified GSS failure. Minor code may provide more information
debug1: Next authentication method: publickey
debug1: Trying private key: /home/boonchai_noo/.ssh/identity
debug1: Trying private key: /home/boonchai_noo/.ssh/id_rsa
debug1: Trying private key: /home/boonchai_noo/.ssh/id_dsa
debug1: Next authentication method: keyboard-interactive
Password:
*** In the debug mode I found there are 3 times to try authentication method : GSSAPI so I man the ssh_config to look how to disable how to disable GSSAPI,
the option is GSSAPIAuthentication = no
I try to login againt with option
[tatshuya]# ssh -v -o GSSAPIAuthentication=no 10.1010.2
....
....
debug1: ssh_rsa_verify: signature correct
debug1: SSH2_MSG_NEWKEYS sent
debug1: expecting SSH2_MSG_NEWKEYS
debug1: SSH2_MSG_NEWKEYS received
debug1: SSH2_MSG_SERVICE_REQUEST sent
debug1: SSH2_MSG_SERVICE_ACCEPT received
debug1: Authentications that can continue: gssapi-keyex,gssapi-with-mic,publickey,password,keyboard-interactive
debug1: Next authentication method: publickey
debug1: Trying private key: /home/boonchai_noo/.ssh/identity
debug1: Trying private key: /home/boonchai_noo/.ssh/id_rsa
debug1: Trying private key: /home/boonchai_noo/.ssh/id_dsa
debug1: Next authentication method: keyboard-interactive
Password:
**** there is no use the authentication method in debug mode and the time for display password prompt faster than before.
Thank you walker for this information.
-- TaTsHuYa --
Saturday, October 03, 2009
Automatic start Oracle 10g on Solaris 10.
Create new file in '/etc/init.d' in this instruction I use new file name is oracle.
[tatshuya#] vi /etc/init.d/oracle
#!/bin/sh
user=oracle
SU=/bin/su
ORACLE_HOME=/oracle/product/10.2.0/db
export ORACLE_HOME
case "$1" in
start)
$SU $user $ORACLE_HOME/bin/dbstart
;;
restart)
$SU $user $ORACLE_HOME/bin/dbshut
$SU $user $ORACLE_HOME/bin/dbstart
;;
stop)
$SU $user $ORACLE_HOME/bin/dbshut
;;
*)
echo "Usage : oracle start restart stop"
;;
esac
# Save file and then create symbolic link
ln -s /etc/init.d/oracle /etc/rc0.d/K01oracle
ln -s /etc/init.d/oracle /etc/rc2.d/K01oracle
ln -s /etc/init.d/oracle /etc/rc2.d/S88oracle
ln -s /etc/init.d/oracle /etc/rc3.d/K01oracle
ln -s /etc/init.d/oracle /etc/rc3.d/S88oracle
*** Change parameter from N to Y in oratab , In solaris 10 this file place in
'/var/opt/oracle/oratab'
tatshuya:/oracle/product/10.2.0/db:Y
thank you A! help for this instruction.
--TaTsHuYa--
[tatshuya#] vi /etc/init.d/oracle
#!/bin/sh
user=oracle
SU=/bin/su
ORACLE_HOME=/oracle/product/10.2.0/db
export ORACLE_HOME
case "$1" in
start)
$SU $user $ORACLE_HOME/bin/dbstart
;;
restart)
$SU $user $ORACLE_HOME/bin/dbshut
$SU $user $ORACLE_HOME/bin/dbstart
;;
stop)
$SU $user $ORACLE_HOME/bin/dbshut
;;
*)
echo "Usage : oracle start restart stop"
;;
esac
# Save file and then create symbolic link
ln -s /etc/init.d/oracle /etc/rc0.d/K01oracle
ln -s /etc/init.d/oracle /etc/rc2.d/K01oracle
ln -s /etc/init.d/oracle /etc/rc2.d/S88oracle
ln -s /etc/init.d/oracle /etc/rc3.d/K01oracle
ln -s /etc/init.d/oracle /etc/rc3.d/S88oracle
*** Change parameter from N to Y in oratab , In solaris 10 this file place in
'/var/opt/oracle/oratab'
tatshuya:/oracle/product/10.2.0/db:Y
thank you A! help for this instruction.
--TaTsHuYa--
ORA-12154: TNS:could not resolve the connect identifier specified
Sometime you may start listener and want to connect by ORANET to the database immediately, but you receive the message "ORA-12154: TNS:could not resolve the connect identifier specified" after you investigate you found you listener still have no service register.
[tatshuya]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 03-OCT-2009 20:53:53
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /oracle/product/10.2.0/db/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /oracle/product/10.2.0/db/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0/db/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tatshuya.home.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tatshuya.home.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 03-OCT-2009 20:53:53
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tatshuya.home.com)(PORT=1521)))
The listener supports no services
The command completed successfully
If you want to force Oracle's Listerner to have service you can wait or force a database to register service in listener by.
connect to sys or system.
[tatshuya]# sqlplus "/ as sysdba"
SQL> alter system register;
System altered.
Then check you listener status again.
[tatshuya]# lsnrctl status
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 03-OCT-2009 21:06:41
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tatshuya.home.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 03-OCT-2009 20:53:53
Uptime 0 days 0 hr. 12 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tatshuya.home.com)(PORT=1521)))
Services Summary...
Service "tatshuya" has 1 instance(s).
Instance "tatshuya", status READY, has 1 handler(s) for this service...
Service "tatshuya_XPT" has 1 instance(s).
Instance "tatshuya", status READY, has 1 handler(s) for this service...
The command completed successfully
--TaTsHuYa--
[tatshuya]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 03-OCT-2009 20:53:53
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /oracle/product/10.2.0/db/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /oracle/product/10.2.0/db/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0/db/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tatshuya.home.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tatshuya.home.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 03-OCT-2009 20:53:53
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tatshuya.home.com)(PORT=1521)))
The listener supports no services
The command completed successfully
If you want to force Oracle's Listerner to have service you can wait or force a database to register service in listener by.
connect to sys or system.
[tatshuya]# sqlplus "/ as sysdba"
SQL> alter system register;
System altered.
Then check you listener status again.
[tatshuya]# lsnrctl status
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 03-OCT-2009 21:06:41
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tatshuya.home.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 03-OCT-2009 20:53:53
Uptime 0 days 0 hr. 12 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tatshuya.home.com)(PORT=1521)))
Services Summary...
Service "tatshuya" has 1 instance(s).
Instance "tatshuya", status READY, has 1 handler(s) for this service...
Service "tatshuya_XPT" has 1 instance(s).
Instance "tatshuya", status READY, has 1 handler(s) for this service...
The command completed successfully
--TaTsHuYa--
Friday, October 02, 2009
How to change lable partition on RHEL
When I want to change mount point in '/etc/fstab' in RHEL, if found it use Label to identified partition disk.
[root@tatshuya]# cat /etc/fstab
LABEL=/ / ext3 defaults 1 1
LABEL=/opt /opt ext3 defaults 1 2
LABEL=/usr /usr ext3 defaults 1 2
LABEL=/var /var ext3 defaults 1 2
LABEL=/boot /boot ext2 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-sda6 swap swap defaults 0 0
I want to change '/opt' to '/oracle'.
*** List existing label
[root@tatshuya]# e2label /dev/sda7
/opt
*** Change to new lable
[root@tatshuya]# e2label /dev/sda7 /oracle
*** List new label
[root@tatshuya]# e2label /dev/sda7
/oracle
-- TaTsHuYa --
[root@tatshuya]# cat /etc/fstab
LABEL=/ / ext3 defaults 1 1
LABEL=/opt /opt ext3 defaults 1 2
LABEL=/usr /usr ext3 defaults 1 2
LABEL=/var /var ext3 defaults 1 2
LABEL=/boot /boot ext2 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-sda6 swap swap defaults 0 0
I want to change '/opt' to '/oracle'.
*** List existing label
[root@tatshuya]# e2label /dev/sda7
/opt
*** Change to new lable
[root@tatshuya]# e2label /dev/sda7 /oracle
*** List new label
[root@tatshuya]# e2label /dev/sda7
/oracle
-- TaTsHuYa --
Problem when installation Oracle 10g on RHEL5 ( 64 bits )
When I try to install Oracle10g on RHEL5
[tatshuya#] ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-10-03_12-48-53PM. Please wait ...[oracle@migrate ~]$ Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/OraInstall2009-10-03_12-48-53PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.(Unknown Source)
at java.awt.Component.(Unknown Source)
I try to look what the library missing by command 'ldd'.
[tatshuya#] ldd /tmp/OraInstall2009-10-03_12-50-33PM/jre/1.4.2/lib/i386/libawt.so
linux-gate.so.1 => (0xffffe000)
libmlib_image.so => not found
libjvm.so => not found
libXp.so.6 => not found
libXt.so.6 => /usr/lib/libXt.so.6 (0xf7bcf000)
libXext.so.6 => /usr/lib/libXext.so.6 (0xf7bbe000)
libXtst.so.6 => /usr/lib/libXtst.so.6 (0xf7bb8000)
libX11.so.6 => /usr/lib/libX11.so.6 (0xf7ab5000)
libm.so.6 => /lib/libm.so.6 (0xf7a8e000)
libdl.so.2 => /lib/libdl.so.2 (0xf7a8a000)
libjava.so => not found
libc.so.6 => /lib/libc.so.6 (0xf7945000)
libSM.so.6 => /usr/lib/libSM.so.6 (0xf793c000)
libICE.so.6 => /usr/lib/libICE.so.6 (0xf7922000)
libXau.so.6 => /usr/lib/libXau.so.6 (0xf791f000)
libXdmcp.so.6 => /usr/lib/libXdmcp.so.6 (0xf7919000)
/lib/ld-linux.so.2 (0x0048d000)
When I check the package 'libXp' I found it not installed in my system.
[tatshuya#] rpm -q libXp
package libXp is not installed
*** Find the package & install
[tatshuya#] rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm
warning: libXp-1.0.0-8.1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
1:libXp ########################################### [100%]
./database/runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-10-03_12-59-08PM. Please wait ...
Finally it's work.
** Do not confuse about why I use i386 package because you should look carefully in the error "OraInstall2009-10-03_12-48-53PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6" you see i386 word. **
[tatshuya#] ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-10-03_12-48-53PM. Please wait ...[oracle@migrate ~]$ Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/OraInstall2009-10-03_12-48-53PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.
at java.awt.Component.
I try to look what the library missing by command 'ldd'.
[tatshuya#] ldd /tmp/OraInstall2009-10-03_12-50-33PM/jre/1.4.2/lib/i386/libawt.so
linux-gate.so.1 => (0xffffe000)
libmlib_image.so => not found
libjvm.so => not found
libXp.so.6 => not found
libXt.so.6 => /usr/lib/libXt.so.6 (0xf7bcf000)
libXext.so.6 => /usr/lib/libXext.so.6 (0xf7bbe000)
libXtst.so.6 => /usr/lib/libXtst.so.6 (0xf7bb8000)
libX11.so.6 => /usr/lib/libX11.so.6 (0xf7ab5000)
libm.so.6 => /lib/libm.so.6 (0xf7a8e000)
libdl.so.2 => /lib/libdl.so.2 (0xf7a8a000)
libjava.so => not found
libc.so.6 => /lib/libc.so.6 (0xf7945000)
libSM.so.6 => /usr/lib/libSM.so.6 (0xf793c000)
libICE.so.6 => /usr/lib/libICE.so.6 (0xf7922000)
libXau.so.6 => /usr/lib/libXau.so.6 (0xf791f000)
libXdmcp.so.6 => /usr/lib/libXdmcp.so.6 (0xf7919000)
/lib/ld-linux.so.2 (0x0048d000)
When I check the package 'libXp' I found it not installed in my system.
[tatshuya#] rpm -q libXp
package libXp is not installed
*** Find the package & install
[tatshuya#] rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm
warning: libXp-1.0.0-8.1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
1:libXp ########################################### [100%]
./database/runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-10-03_12-59-08PM. Please wait ...
Finally it's work.
** Do not confuse about why I use i386 package because you should look carefully in the error "OraInstall2009-10-03_12-48-53PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6" you see i386 word. **
Installation Oracle10gR2 on RHEL 5 x86_64
*** Add Group & User
[tatshuya]# groupadd oinstall
[tatshuya]# groupadd dba
[tatshuya]# groupadd oper
[tatshuya]# useradd -g oinstall -G dba,oper oracle
[tatshuya]#
*** Check package that Oracle need
[tatshuya]# rpm -q binutils compat-db compat-libstdc++-33 glibc glibc-devel glibc-headers gcc gcc-c++ libstdc++ cpp make libaio ksh elfutils-libelf sysstat libaio libaio-devel setarch libXp --qf '%{name}.%{arch}\n'|sort
*** Result when check package
binutils.x86_64
compat-libstdc++-33.i386
compat-libstdc++-33.x86_64
cpp.x86_64
elfutils-libelf.i386
elfutils-libelf.x86_64
gcc-c++.x86_64
gcc.x86_64
glibc-devel.i386
glibc-devel.x86_64
glibc-headers.x86_64
glibc.i686
glibc.x86_64
ksh.x86_64
libaio.i386
libaio.i386
libaio.x86_64
libaio.x86_64
libstdc++.i386
libstdc++.x86_64
make.x86_64
package compat-db is not installed
package libaio-devel is not installed
package libXp is not installed
package sysstat is not installed
setarch.x86_64
*** Find Package that not installed and install them!!!!
[tatshuya]# rpm -ivh libaio-devel-0.3.106-3.2.x86_64.rpm compat-db-4.2.52-5.1.x86_64.rpm sysstat-7.0.2-3.el5.x86_64.rpm libXp-1.0.0-8.1.el5.i386.rpm
warning: libaio-devel-0.3.106-3.2.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
1:sysstat ########################################### [ 33%]
2:libaio-devel ########################################### [ 67%]
3:compat-db ########################################### [100%]
*** Setting System parameters at /etc/sysctl.cong
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
*** After save file then execute command 'sysctl -p' to apply
[tatshuya]# sysctl -p
*** Result of 'sysctl -p' command
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
*** Edit the /etc/pam.d/login file and add following line:
session required pam_limits.so
*** Edit the /etc/security/limits.conf file and add following lines:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
*** Run installer
[tatshuya#] ./runInstaller
--TaTsHuYa--
[tatshuya]# groupadd oinstall
[tatshuya]# groupadd dba
[tatshuya]# groupadd oper
[tatshuya]# useradd -g oinstall -G dba,oper oracle
[tatshuya]#
*** Check package that Oracle need
[tatshuya]# rpm -q binutils compat-db compat-libstdc++-33 glibc glibc-devel glibc-headers gcc gcc-c++ libstdc++ cpp make libaio ksh elfutils-libelf sysstat libaio libaio-devel setarch libXp --qf '%{name}.%{arch}\n'|sort
*** Result when check package
binutils.x86_64
compat-libstdc++-33.i386
compat-libstdc++-33.x86_64
cpp.x86_64
elfutils-libelf.i386
elfutils-libelf.x86_64
gcc-c++.x86_64
gcc.x86_64
glibc-devel.i386
glibc-devel.x86_64
glibc-headers.x86_64
glibc.i686
glibc.x86_64
ksh.x86_64
libaio.i386
libaio.i386
libaio.x86_64
libaio.x86_64
libstdc++.i386
libstdc++.x86_64
make.x86_64
package compat-db is not installed
package libaio-devel is not installed
package libXp is not installed
package sysstat is not installed
setarch.x86_64
*** Find Package that not installed and install them!!!!
[tatshuya]# rpm -ivh libaio-devel-0.3.106-3.2.x86_64.rpm compat-db-4.2.52-5.1.x86_64.rpm sysstat-7.0.2-3.el5.x86_64.rpm libXp-1.0.0-8.1.el5.i386.rpm
warning: libaio-devel-0.3.106-3.2.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
1:sysstat ########################################### [ 33%]
2:libaio-devel ########################################### [ 67%]
3:compat-db ########################################### [100%]
*** Setting System parameters at /etc/sysctl.cong
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
*** After save file then execute command 'sysctl -p' to apply
[tatshuya]# sysctl -p
*** Result of 'sysctl -p' command
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
*** Edit the /etc/pam.d/login file and add following line:
session required pam_limits.so
*** Edit the /etc/security/limits.conf file and add following lines:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
*** Run installer
[tatshuya#] ./runInstaller
--TaTsHuYa--
Subscribe to:
Posts (Atom)