Wednesday, March 11, 2009

Business Loan from EZUnsecured.com and BusinessCreditMagic

Do you ever thinking about business loan ? If so, then you have to consider EZUnsecured.com. You might asked why must EZUnsecured.com and BusinessCreditMagic.com and not other financing institution ? Well, there are some reason why these two institution are the best among others and here are the reason.
EZUnsecured.com is offering you the best loan program and trust me that they know what their doing since they are professional. EZUnsecured.com doesn't need any document if you want loan up to $400,000 or you might want to get more, you just have to fulfil some easy document. EZUnsecured might not the cheapest one but they are the best.
EZUnsecured also provide you with personal loan. You can get personal loan without have to provide any document and complicated procedure. Their staffs will help you to get you personal loan easily. Call them now !
If you have bad credit history and need Business Credit, then you should consider BusinessCreditMagic.com. You can get unsecured financing up to $250,000 easily. This is the best part of it. You don't even need to give your social security number. BusinessCreditMagic give you the best credit option even you have bad credit history. They don't consider whether you have good credit history nor bad one.

Wednesday, November 12, 2008

How to apply SAP patch on SAP server

Some people ask me how to apply SAP patch level on Production SAP system. Actually it is possible. But it is high risk task. It is better you apply them when no user is logging in to your system.

OK, here is the step by step.

1. Make sure that you have download all SAP patch you need to be applied.
2. Apply SAP Basis Component (SAP_BASIS - usually named SAPKBxxxxx) and Cross-Application Component (SAP_ABA - usually named SAPKAxxxxx) first. And also from my experience and some best practice, apply them on the same patch level. For example when you're applying SAPKB62059 then apply SAPKA62059 too.
3. Consult to your functional consultant and functional team before applying Logistics and Accounting component (SAP_APPL - usually named SAPKXxxxxx). I repeat this warning again. Consult first before applying because this patches will affect to your customizing setting. If you're not sure about this, then don't apply them.
4. Use DDIC user to apply and login to client 000. Start from your Development server.
5. Last thing, pray...

I hope this few tips will help you.

x

Tuesday, November 11, 2008

How to define backup strategy on SAP R3 based system

Backup your backup strategy ? Its sound cool...huh. But actually, this is hard thing to do. As SAP Basis which usually also work as DBA, you cannot decide this by yourself. You'll need to manage this through deal with other people from different department and also from your company management. May be you'll think like this.

Why do I have to get permission from other department ? Why not just from IT Manager and Company Management ?

This is complex job and all people on your company rely on your IT system. When this system is down, all of them will get the effect. All you need is to define precise backup strategy. Few things need to consider before deciding backup strategy such as :

1. How many hours that your company will compromise about downtime ? 1 hour ? 5 hours ? a days ? Check this !
2. How many hours do you need to restore your data ? Check your tape backup speed to restore. Do this regularly for example once in 3 months.
3. How many budget do you have to perform this backup strategy ? Backup tape and backup drive also has its limitation on read and write activities.

This just few things need to consider. You can found differently on your company. Depend on your company policy.

Wednesday, November 5, 2008

Advertisers can buy link here

I have recently joined Ask2link.com to enable advertisers to buy text links advertisement on my website. Ask2link’s text links are unique since they could bring targetted traffic and boost your organic search engine rankings. Ask2link.com provides secure, easy, and fast checkout flow so you could get your text link ads live within five minutes.

Bloggers or Webmasters: If you would like to monetize your blog or website beyond Adsense, you could visit Ask2link to learn more.

Buy text link ads now on this website with Ask2link. Start advertising now in this website as part of your online marketing campaign. You could now purchase text link ads on this website by following here:

http://www.ask2link.com/buy_ad/8dfec6386d952cc09c4f1225932767

Note to advertisers, SEO agencies/SEO specialists, internet marketers, or e-commerce websites: You could visit Ask2link to buy static text links on hundreds of websites easily as part of your inbound link building and SEO campaign.
They accept credit cards and PayPal payments and your text links will be live within five minutes after your order.
Ask2link’s text links are unique because they are rendered as plain static HTML links that could bring you more
traffic and boost your organic search engine ranking for your keywords.

Friday, October 24, 2008

How to check BRTOOLS version

Some SAP Basis newbies ask me about how to know which version they are using right now. Although I am not SAP Basis expert, I'll try to get information to you.
You can follow this step :

Enter your SAP system on OS. You can use root (for UNIX/Linux) and Administrator (on Windows system). I am going to guide you on UNIX/Linux only system.

Switch you user to ora[sid] user :

#su - oraids
>

Type this command :

>brtools -V

You'll see something like this :

host:oraids 1> brtools -V
BR0651I BRTOOLS 6.40 (40)

Patch Date Info

36 2006-01-11 Small functional enhancements in BR*Tools (note 914174)
38 2006-03-29 BR*Tools support for MDM databases (note 936665)
40 2006-08-30 Wrong message numbers in BR*Tools 6.40 (note 976755)

release note 680046
kernel release 640
patch date 2006-08-30
patch level 40
make platform hpia64
make mode OCI_920
make date Sep 5 2006

host:oraids 2>

As you can see that I am using BRTOOLS version 6.40 and have patch level 40. I am using HP-UX on Itanium platform 64 bit. Now, check your own BRTOOLS version.
x

Tuesday, October 21, 2008

System Copy with Oracle 10g from 64-bit to 32-bit on Windows E-mail Print PDF

Following procedure helps you to do a system copy from a 64-bit to 32-bit hardware with Windows/Oracle Platform.

Introduction To System Landscape

When we design the landspace for a SAP Project, generally we prefer to have same platform for Development, Test and Production system.

This includes,

  • Hardware (32-bit or 64-Bit and also IA64, X64, or Unix 64 Bit platforms)
  • Operating System
  • Database
  • R3 Kernel

This helps, system administrators to identify system related problems causes functional problems.

For example, if a 64-Bit Kernel for Netweaver 700 on Windows/Oracle causes a problem, you cannot simulate it on your Test system if it is a 32 Bit platform.

Also you have to make sure that the kernel patch levels are all same on all systems.

System Copy Experience with 64-bit to 32-bit

Environment

Recently, one of our Customer asked us to copy Production System to their Test System.

Here is the systems environments:

Production System (Source System)

Component
Version
Hardware
64-bit Intel Xeon (x64)
Operating System
64-bit Windows 2003 R2 SP1
Database
Oracle 10.2.0.2 64-bit
SAP Kernel
700 64-bit PL 133

Test System (Target System)

Component
Version
Hardware
32-bit Intel Xeon (x86)
Operating System
32-bit Windows 2003 R2 SP1
Database
Oracle 10.2.0.2 32-bit
SAP Kernel
700 32-bit PL 72

Procedure

Here is the brief procedure. For details, please download System Copy Guides from http://service.sap.com/instguides

  1. Stop Production System to copy files or use a recent online/offline backup to copy database files from production to test syste
  2. Run "alter database backup controlfile to trace" on source database to get control file creation script.
  3. Generate new cntrl.sql and run on target system with modified paths
  4. Recover if backup is online via "recover datbase using backup controlfile until cancel;"
  5. After recovery shutdown database on target with "shutdown immediate". Do not use "shutdown abort"
  6. cd ORACLE_HOME/rdbms/admin on target system with adm
  7. sqplus "/as sysdba"
  8. SQLPLUS> startup upgrade
  9. SQLPLUS> @utilrp.sql
  10. SQLPLUS> shutdown immediate
  11. SQLPLUS> startup
  12. SQLPLUS> @utlrp.sq
  13. If databaase scheme name is different from SAPSR3 on both systems, then you've to change dbs_ora_schema environment value to the one on Source System.
  14. If schema name is other than SAPSR3, than you have to re-configure OPS$ me. For this please check the reference section which gives OPS$ mechanism notes.
  15. Check connection with "R3trans -d"
  16. Start SAP System and apply, post-copy procedures.

That's it.

Hope it helps you to understand that it is not necessary to use R3load Procedure even platforms are different in bit level.

References

Note 050088 - Creating OPS$ users on Windows NT/Oracle

Note 361641 - Creating OPS$ users on UNIX


Taken from http://www.basisconsultan.com.

Monday, October 20, 2008

Effective Optimizer Statistics Update

Following command is very effective, as its not estimating, doing a real calculation on tables including all indices to find the right path for R3 Systems.

brconnect -u / -c -f stats -t all -m +I -s P10 -f allsel,collect,method,precision -p 8


Taken from www.basisconsultan.com.