I wish for a prompt response
Good day,
I am Mr.Rami Makhlouf from Syria; I am interested in buying properties and other investments in your country through your assistance if you can help me. I would like to learn more about your country’s culture and other interesting lucrative businesses in your country.
I would like more information about these projects so that I can learn more about the investment project in your country and clarify your plan.
I was a businessman in Aleppo before the civil war. My business has been destroyed by the war. Our economy has collapsed since 2012. There is no meaningful economic activity going on in Syria and there will be none for the foreseeable future even if the war stops today as it will take more than four decades to rebuild our infrastructure and our economy.
I want my daughter to emigrate to your country but not as a refugee rather as an investor, as I still have a substantial part of my cash holdings intact. For me, I have been seriously sick for eight months now. I have Chronic Lymphoid Leukaemia and according to my doctors I have not much time to live. This is why I found it wise to contact a business person in your country to help me since this country won’t be safe for my 11 years old daughter.
I wish for a prompt response from you regarding my letter.
Reply to my email: ra4278741@gmail.com
Warm regards,
Mr.Rami Makhlouf
Request: Raw Material Sourcing in Pharmaceutical Industry
Greetings,
I hope this email finds you well, I am Dr. Nelson Rodriguez, and I currently work with (Euromed) a bio-pharmaceutical manufacturing company here in the United Kingdom.
I came across your email through LinkedIn suggestions, and have decided to write you directly.
I am looking for a reliable businessman/individual in your region to represent my company in sourcing some of our basic raw materials used for manufacturing of Pharmaceutical Products.
This may not be your area of specialization; but it will be another income generating business out of your Specialty. I will give you more details once received your feedback.
If you’re interested, please email me back with your phone number for direct communication.
Tel/Whatsapp: +447452276271
KakaoTalk ID: drnelson
E-mail: nr7452276271
Regards,
Dr. Nelson Rodriguez
(Dir., Research & Development)
Batch A.
Google Incorporation
Belgrave House
76 Buckingham Palace Road
London SW1W 9TQ, United Kingdom.
Dear Google User.
Attached to this email is your anniversary notification for being an active user of Google.
Sincerely.
Sundar Pichai – Chief Executive Officer (CEO) of Google Inc™
การตั้งค่าให้เครื่องเราสามารถ VPN ไปยังเ ครืองที่ทำงานได้
VPN แบบ PPTP (For MOC)
อุปกรณ์ Network
1. ตั้งค่า Fortigate Firewall ให้มี PPTP address เช่น 172.16.1.[xx- yy]
2. ตั้งค่า Firewall Policy Rule ที่ ISA ให้สามารถเห็นเครื่องเราได้
Protocol: FTP, RDP, HTTP, PING …
From: 172.16.1.[xx- yy]
To: เครื่องที่ต้องการให้สามารถมองเห็นได้
เครื่อง Client
1. Connect PPTP ไปที่ขานอก
2. ติ๊กที่ Use Default Gateway on Remote Network ใน TCP/IP Setting ของ VPN connect
หมายเหตุ
1. การติ๊ก Use Default Gateway นี้ จะทำให้สามารถ connect ไปยัง different vlan ได้ แต่จะทำให้ออกเน็ตไม่ได้
ถ้าต้องการ connect VPN แล้วออกเน็ตได้ต้องติ๊กตรงนี้ออก แต่ก็จะเข้า different vlan ไม่ได้
2. ถ้า connect ไม่ได้ ให้ตรวจสอบว่าค่า ip ของทุกที่ถูกต้องหรือไม่
ฟอนต์ไทย และ เทมเพลต สำหรับเอกสารราชกา รค่ะ
refer: http://www.opm.go.th/opminter/itcenter/officialletter.htm
การเซ็ตค่าภาษาไทยสำหรับ phpmyadmin บน wamp หรือ mamp
เพิ่มโค้ดด้านล่างเข้าไปในส่วนท้ายของการ connection ฐานข้อมูล
$cs1 = “SET character_set_results=utf8”;mysql_query($cs1) or die(‘Error query: ‘ . mysql_error());$cs2 = “SET character_set_client = utf8”;mysql_query($cs2) or die(‘Error query: ‘ . mysql_error());$cs3 = “SET character_set_connection = utf8”;mysql_query($cs3) or die(‘Error query: ‘ . mysql_error());$cs1 = “SET character_set_results=utf8”;mysql_query($cs1) or die(‘Error query: ‘ . mysql_error()); $cs2 = “SET character_set_client = utf8”;mysql_query($cs2) or die(‘Error query: ‘ . mysql_error());
$cs3 = “SET character_set_connection = utf8”;mysql_query($cs3) or die(‘Error query: ‘ . mysql_error());
ora-01031 insufficient privileges when create view or table
Oracle database:
In most cases, the user receiving this error lacks a privilege to create an object (such as a table, view, procedure … etc). Use the following command in sqlplus to add privilege:
GRANT create table TO appadm;
How to change IP address on Linux
Check the configurations…
vi /etc/sysconfig/network-scripts/ifcfg-eth0
vi /etc/sysconfig/network
vi /etc/hosts
And restart the interfaces…
/etc/init.d/network restart
How to set proxy via regedit
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]
“MigrateProxy”=dword:00000001
“ProxyEnable”=dword:00000001
“ProxyHttp1.1″=dword:00000000
“ProxyServer”=”http://ProxyServername:80”
“ProxyOverride”=”<local>”
If it is greyed out, try following the link http://www.ehow.com/how_6891516_use-server-greyed-out-checked.html
ปัญหาที่ไม่สามารถ start oracle database ได้
Problem:
ไม่สามารถ start database
SQL> startup
database mounted
ERROR at line 1:
ORA-16038: log 4 sequence# 11805 cannot be archived ORA-19502: write error on file “”, blockno (blocksize=)
ORA-00312: online log 4 thread 1: ‘/oradata/testdb2/redo01.log’
Solution
Method1
#ทำการ recover database:
SQL> recover database until cancel;
Media recovery complete.
SQL> ALTER DATABASE OPEN RESETLOGS;
#open database
SQL>alter database open
Method2
#clear archive log
SQL>archive log list;
SQL>select group#, thread#, status from v$log;
SQL>alter database clear unarchived logfile group 4;
#open database
SQL>alter database open
+++++++++++++++++++++++++++++++++++++++++++
Problem ORA-00257: archiver error. Connect internal only,until freed.
Cause
เนืองจากพิ้นที่ disk เต็ม
Solution
ลบ archive log เก่าๆ ออก
+++++++++++++++++++++++++++++++++++++++++++
สำหรับกรณีระบบ DPIS
Problem log เต็ม
Solution
Method1
#clear folder เก่าๆ ออก
#เข้าไปใน E:\oracle\product\10.2.0\flash_recovery_area\DPIS35\ARCHIVELOG
#E:\oracle\product\10.2.0\flash_recovery_area\DPIS35SR\ARCHIVELOG
Method2
#ขยาย size ของ log
start sqlplus
C:\set oracle_sid=ชื่อsid
C:\sqlplus sys@=ชื่อ instant as sysdba
sql > startup
sql >alter system set db_recovery_file_dest_size=4G;
Problem
redo log group 2 เกิดปัญหา ของ instant dpis35sr
Solution
Method1
start sqlplus
C:\set oracle_sid=ชื่อsid
C:\sqlplus sys@=ชื่อ instant as sysdbas
ql > startup
sql >archive log list ;
sql >select group#,thread#,status from v$log ;
sql >alter database clear logfile group 2 ;
sql >alter database open;
Problem:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 29 – see DBWR trace file
ORA-01110: data file 29:
‘/opt/oracle/product/oracle9i/dbs/C:oracleproduct10.2.0oradatapentahoptho_ts.dbf
‘
so to fix it, i did following:
Solution:
SQL>alter database datafile 29 OFFLINE DROP;
SQL>alter database open;
SQL>alter database datafile 29 ONLINE DROP;
Problem:
ปัญหาเรื่องการ recovery
Solution:
> startup mount
> alter database recover until cancel;
> alter database recover cancel; // might say recovery hasn’t started
> alter database open resetlogs;
references: http://oraclethai.blogspot.com/2008/09/ora-00312-online-log-1-thread-1-and.html
Tech news @ Moc 