Written by Go to your program
T-code SE38 : Zxxxxxx
select display
T-code SE38 : RSVARENT (for delete protection)
T-code SE38 : delete and check again
Share on Facebook
Posts in category O.S.
Delete or modify protection program variant
JOB PRE-SALE
Written by FI/CO consultants who wanna change role to PRE-SALE for Permanant position in Global Company
Salary: 80K – 100K Baht
mail to: pong_cu@hotmail.com
Share on FacebookUrgent JOB on ORACLE DBA
Urgent Need:
- oracle administrator 2 months!!
Project Details:
2 months base in Thailand.
Rate Details:
negotiable
must available 15 June
Contact : nut7457@hotmail.com
Share on FacebookUrgent JOB on FI,SD,PP,MM,QM,PM
Urgent Need:
- FI and SD Teamlead who can speak mandarin chinese!!!
- PP, MM, QM PM must be must Thai consultant!!!
Available for both Contract and Permanent (only contractor has per diem inclusive)
Project Details:
1st year base in Singapore and rollout 6 countries in asia.
Rate Details:
10K-14K / day (THB)
must available 1 august
Preferable:
1.Should have expereince for impl+roll out project
2.Experienced to work with foreigner colleagues
3.At least 8 years expereince for team lead
Any interesting: send the update CV to “pong_cu@hotmail.com”
Share on FacebookSolaris : zip and compress files
zip file
# tar cvf – audit_201102* | gzip -c > audit_201102.tar.gz
unzip file
# gzip -cd audit_201011.tar.gz | tar xfv -
remove and ask before confirm
# rm -i audit_201102* (do not delete file .tar.gz)
Job !! Basis contract 14 week
14 weeks contract for basis operation
mail to : Indrawat@andessolution.com
SSH access without password
1. Modify /etc/ssh/ssh_config
add line
RSAAuthentication yes
IdentityFile /.ssh/id_rsa
1.1 restart ssd
/lib/svc/method/sshd restart
2. Generate key on both server (or only 1 server)
root@machine1 # ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (//.ssh/id_rsa): /.ssh/id_rsa
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /.ssh/id_rsa.
Your public key has been saved in /.ssh/id_rsa.pub.
The key fingerprint is:
2f:43:fa:9d:44:fd:bc:dd:86:90:19:5a:b3:30:49:5d root@qa2-sys-1
root@machine1 # pwd
/.ssh
root@machine1 # ls
authorized_keys id_rsa id_rsa.pub
3. copy id_rsa.pub to other server in name authorized_keys
root@machine1 # scp id_rsa.pub machine2:/.ssh/authorized_keys
The authenticity of host ‘machine2 (machine2)’ can’t be established.
RSA key fingerprint is eb:b3:57:5a:c3:be:54:bd:e6:9c:df:78:3e:40:4a:c0.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added ‘machine2′ (RSA) to the list of known hosts.
Password:
id_rsa.pub 100% |*************************************************************| 224 00:00
4.file on other server
authorized_keys id_rsa id_rsa.pub known_hosts
root@machine2 # cat known_hosts
192.168.151.132 ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAIEAvHQPcwdBpTMVbtQFJ4itL2qesdrTCnvlGe3lAryqKRPpS4NApOuWcD+IKY2T+kd33DwKCqfYu/gWtoWT7ogyroFT5qilKj0bo4iGgn64nfxGIKd3sLf3L6tNrf+arXUQwqmGP8bzumHDgubFIFn3opx3YXl2yn5Um9xtYYsM9M0=
root@ecp-db-00 #
5. copy
root@machine1 # scp -rp machine2:/oracle/PRD/mirrlogA/log_g11m2.dbf /oracle/PRD/mirrlogA/log_g11m2.dbf
log_g11m2.dbf 100% |*************************************************************| 300 MB 00:17
SAP Enqueue Analysis
SQL Comamnd :
COLUMN EVENT FORMAT a30;
SELECT
event,
total_waits,
time_waited,
avg_ms,
round(RATIO_TO_REPORT(TIME_WAITED)OVER()*100)PERCENT
from
(SELECT
SUBSTR(EVENT,1,30) EVENT,
TOTAL_WAITS,
TIME_WAITED,
ROUND(TIME_WAITED_MICRO/TOTAL_WAITS/1000,2) AVG_MS
FROM V$SYSTEM_EVENT
WHERE
WAIT_CLASS != ‘idle’ AND
EVENT NOT IN
(‘db file parallel write’,'log file parallel write’,
‘log file sequential read’,'control file parallel write’,
‘control file sequential read’,'Log archive I/O’)
UNION
SELECT ‘CPU’ EVENT,NULL,VALUE,NULL
FROM V$SYSSTAT
WHERE STATISTIC# = 12
ORDER BY 3 DESC)
WHERE ROWNUM <=10;
READ MORE »
SAP Note Viewer for iPhone available (Free)
search for “SAP Note Viewer for iPhone” on your itune. you can put oss-user/password fr search note on your iphone…. please try
Share on FacebookSAP Jco : Easy to setup step by step (example)
Neccessary files
1. libsapjco3.so
2. sapjco3.jar
3. /oracle/PRD/102_64/jdbc/lib/nls_charset12.jar
4. /oracle/PRD/102_64/jdbc/lib/ojdbc14.jar
Step to step :
1. Check JAVA VM (if Java Connector 3 up will run on JAVA 1.5 up)
SAP-SERVER:oraprd 46% java -version
java version “1.5.0_12″
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
Java HotSpot(TM) Server VM (build 1.5.0_12-b04, mixed mode)
2. Cretae SAPJco folder and put require files on folder
SAP-SERVER:oraprd 50% pwd
/oracle/PRD/SAPJco
SAP-SERVER:oraprd 49% ls -al
total 13608
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 .
drwxr-xr-x 23 oraprd dba 1536 Feb 12 16:06 ..
drwxr-xr-x 2 oraprd dba 512 Feb 12 17:48 jco_server
-rw-r–r– 1 oraprd dba 5784736 Feb 12 17:47 libsapjco3.so
-rw-r–r– 1 oraprd dba 1149431 Feb 12 17:47 sapjco3.jar
3. Create folder for application (jco_server) and put source files (.java) in here
SAP-SERVER:oraprd 58% pwd
/oracle/PRD/SAPJco/jco_server
SAP-SERVER:oraprd 59% ls -al
total 24
drwxr-xr-x 2 oraprd dba 512 Feb 12 17:48 .
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 ..
-rw-r–r– 1 oraprd dba 9650 Feb 12 17:48 JCO_SERVER.java
4. modify JCO_SERVER.java connect to other host
Example :
Properties connectProperties = new Properties();
connectProperties.setProperty(DestinationDataProvider.JCO_ASHOST,”SAP-SERVER”);
connectProperties.setProperty(DestinationDataProvider.JCO_SYSNR, “03″);
connectProperties.setProperty(DestinationDataProvider.JCO_CLIENT, “900″);
connectProperties.setProperty(DestinationDataProvider.JCO_USER, “inf01″);
connectProperties.setProperty(DestinationDataProvider.JCO_PASSWD, “sapcpic”);
connectProperties.setProperty(DestinationDataProvider.JCO_LANG, “th”);
connectProperties.setProperty(DestinationDataProvider.JCO_POOL_CAPACITY, “3″);
connectProperties.setProperty(DestinationDataProvider.JCO_PEAK_LIMIT, “10″);
createDataFile(DESTINATION_NAME2, “jcoDestination”, connectProperties);
Properties servertProperties = new Properties();
servertProperties.setProperty(ServerDataProvider.JCO_GWHOST,”SAP-SERVER”);
servertProperties.setProperty(ServerDataProvider.JCO_CONNECTION_COUNT, “2″);
servertProperties.setProperty(ServerDataProvider.JCO_GWSERV, “sapgw00″);
servertProperties.setProperty(ServerDataProvider.JCO_PROGID, “JCO_SERVER”);
servertProperties.setProperty(ServerDataProvider.JCO_REP_DEST, “ABAP_AS_WITH_POOL”);
createDataFile(SERVER_NAME1, “jcoServer”, servertProperties);
String url = “jdbc:oracle:thin:@EXTERNAL-SERVER:1521:PROD”;
String userName = “user”;
String password = “passwd”;
5. Check environment
SAP-SERVER:oraprd 72% env
HOME=/oracle/PRD
PATH=/oracle/PRD/102_64/bin:/oracle/PRD:/usr/sap/PRD/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb
LOGNAME=oraprd
HZ=
TERM=vt100
SHELL=/bin/csh
MAIL=/var/mail/oraprd
TZ=Asia/Bangkok
PWD=/oracle/PRD/SAPJco/jco_server
USER=oraprd
SAPSYSTEMNAME=PRD
DIR_LIBRARY=/usr/sap/PRD/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/PRD/SYS/exe/run:/oracle/PRD/102_64/lib
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=PRD
dbs_ora_schema=SAPSR3
ORACLE_SID=PRD
DB_SID=PRD
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/PRD/102_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/PRD
6. Add CLASSPATH and LD_LIBRARY_PATH
set environment CLASS_PATH (for c shell)
% setenv CLASSPATH .:/oracle/PRD/SAPJco/sapjco3.jar:/oracle/PRD/102_64/jdbc/lib/ojdbc14.jar:/oracle/PRD/102_64
/jdbc/lib/nls_charset12.jar:/oracle/PRD/SAPJco/jco_server
add JCO path to LD_LIBRARY_PATH
% setenv LD_LIBRARY_PATH /oracle/PRD/SAPJco:$LD_LIBRARY_PATH
Tips : unset environment
unsetenv CLASSPATH
!!! Set this environment to logon environment too
7. Compile sorce code
SAP-SERVER:oraprd 64% cd /oracle/PRD/SAPJco/jco_server
SAP-SERVER:oraprd 59% ls -al
total 24
drwxr-xr-x 2 oraprd dba 512 Feb 12 17:48 .
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 ..
-rw-r–r– 1 oraprd dba 9650 Feb 12 17:48 JCO_SERVER.java
SAP-SERVER:oraprd 66% javac -classpath .:/oracle/PRD/SAPJco/sapjco3.jar:/oracle/PRD/102_64/jdbc/lib/ojdbc14.jar:
/oracle/PRD/102_64/jdbc/lib/nls_charset12.jar:/oracle/PRD/SAPJco/jco_server JCO_SERVER.java
SAP-SERVER:oraprd 69% ls -al
total 42
drwxr-xr-x 2 oraprd dba 512 Feb 13 10:58 .
drwxr-xr-x 3 oraprd dba 512 Feb 12 17:47 ..
-rw-r–r– 1 oraprd dba 538 Feb 13 10:58 JCO_SERVER$MyStateChangedListener.class
-rw-r–r– 1 oraprd dba 769 Feb 13 10:58 JCO_SERVER$MyThrowableListener.class
-rw-r–r– 1 oraprd dba 2695 Feb 13 10:58 JCO_SERVER$StfcConnectionHandler.class
-rw-r–r– 1 oraprd dba 3772 Feb 13 10:58 JCO_SERVER.class
-rw-r–r– 1 oraprd dba 9650 Feb 12 18:01 JCO_SERVER.java
8. run application
$ java -d64 JCO_SERVER &
or
$ nohup java -d64 JCO_SERVER &