Posts

Determine whether your SAP is MDMP, Non-Unicode or Unicode

Image
As per  http://scn.sap.com/thread/246990 Hi Sam, Run report RSCPINST and select /Current NLS config button/. It will show you current NLS settings, and on very top of it display: 1. Non-unicode system - meand single CP or blended CP inst; 2. MDMP installation - it's an MDMP box 3. Unicode inst - guess what  Checked it on MDMP, Unicode & BCP systems here rel 4.7 ent ABAP. Thanks. //alak

Oracle: View all available Schema

Ripped from: http://www.dba-oracle.com/t_display_all_schemas.htm select distinct    owner from    dba_segments where    owner not in ( 'SYSTEM',  ' XDB', 'SYS',  ' TSMSYS',  ' MDSYS',  ' EXFSYS',  ' WMSYS',  ' ORDSYS',  ' OUTLN',  ' DBSNMP');

SAPRouter

Link to SAP Service Market Place SAPRouter guides how tos downloads.. etc.. https://websmp109.sap-ag.de/saprouter-sncadd

OPatch failed with error code = 41

Trying to pacth Oracle 11g 11.2.0.3 on Windows. P:\oracle\ECD\11203\oui\jlib\srvm.jar Log file location: x:\oracle\xxx\11203\cfgtoollogs\opatch\14223718_Sep_27_2012_1 7_46_05\apply2012-09-27_17-46-05PM_1.log Recommended actions: OPatch needs to modify files which are being used by some p rocesses. OPatch failed with error code = 41 Found this help: https://forums.oracle.com/forums/thread.jspa?threadID=2388101 Its a know bug and the fix is renaming belo files temporarily. %ORACLE_HOME%\OPatch\jlib\oracle.opatch.classpath.jar Just rename it to anything, and run opatch apply again. It will then succeed. /alak

Solaris 10 SUnOS 5.10 not detect Intel 82562EZ NIC on x86 System

So we installed Solaris 10 on a crappy Dell Optiplex 170L It does not detect the integrated Ethernet NIC network card Googled the spec and believe its the Intel 82562EZ Ethernet Googled again and found this site which really helped. below mirror for me self: Solaris 10 – x86 – Getting intel 82562EZ (Asus P5GD1) working (Solaris Driver) I added iprb "8086,1050" iprb "8086,1064" to  /etc/driver_aliases and then touch /etc/dhcp.iprb0 touch /etc/hostname.iprb0 followed by shutdown -i6 -g0 -y And I was able to get the Intel 10/100 VE Network Interface (82652 EZ) functioning as it should under solaris. The driver is included with Solaris 10 for x86 but you need to do the above to get the driver working with this board. BUT! mine was to change the 8086 part to pci8086 to become somewhat: iprb "pci8086,1050" iprb "pci8086,1064" and everything works OK after wards. ./alak

SAP: Manual Transports between System/Clients

Image
it so happen that RFC connection became a problematic issue i on of my clients' landscape. But there was few urgent transport requests. RFC problem means cannot retrieve/import/export files in STMS. Temporary workaround? Manually copy over file and add transport request in target system. Example scenario: - from DEV to PRD - TR number is 900277 1. In DEV, locate your /usr/sap/trans directory. 2. there should be many folders, but we are concern with 'data' and 'cofiles' 3. format for data file and cofiles file is this: Data file: R .  for example: R900277.DEV Cofiles file: K .  for example: K900277.DEV 4. Copy from DEV's data/R900277.DEV and cofiles/K900277.DEV into PRD's data/ and cofiles/ folder respectively. 5. Open SAPGui, and go to tcode STMS 6. CLick on the Transport icon (the lorry) 7. Click on the PRD system 8. In Menu Bar, Extras > Other Requests > Add as below screenshot: 9. Enter your request number as following f...

WSB: Full backup vs. System State backup

WSB or Windows Server Backup utility gives you a quite basic and direct backup utility. You can have it scheduled and dump it on a saperate net share or however settings you may have in your environemtn. Theres Full Backup and System State Backup? What are them? Google. Whats the difference? Well, from this ref link i basically confirms my understanding which is Full Backup includes a System State Backup. Thats all. Just fo my own note. Note: - WSB FAQ http://social.technet.microsoft.com/wiki/contents/articles/8585.windows-server-backup-frequently-asked-questions-faq-en-us.aspx - System State Backup restoration http://serverfault.com/questions/17624/what-is-a-system-state-backup-for TQ. .alak