how to Fix ORA-03113 end-of-file on communication channel

ORA-03113: end-of-file on communication channel This article explains how we can fix ORA-03113 end-of-file on communication channel: Observation of Problem: SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 2.6591E+10 bytes Fixed Size 2233960 bytes Variable Size 1.3489E+10 bytes Database Buffers 1.3086E+10 bytes Redo Buffers 13332480 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 10092736 Session ID: 571 Serial number: 3 SOLUTION : Follow below steps: SQL> sqlplus / as ……

SAP Remote Client Copy Step by Step

SAP Remote Client Copy Step by Step Overview of differnet transaction used for client copy: SCC8 /SCC7- Client Import and Export SCC9 – Remote client copy ( source and target client in different systems) SCCL – Local import (source and target client in different systems same system) Here we’ll cover SCC9- SAP Remote Client Copy.Here i am taking scenario where i am doing SAP Remote Client Copy from PRD 300 to QAS 200 Client Presteps: Both client should be locked for ……

Setup of SSFS secure storage to support BRTOOLS

Setup of SSFS secure storage to support BRTOOLS Here i have explained all the steps ,please follow step by step in order to setup SSFS to support Brtools. First i’ll recommend to read:Before setup explained in below article should be done before going for SSFS setup for BRTOOLS. What is SSFS and How we can add SSFS authentication Preparing file system Create dir rsecssfs/data and rsecssfs/key Under /oracle/SID/security.Make sure to give appropriate permission. <server:sidadm>  mkdir rsecssfs <server:sidadm>  chmod 775 rsecssfs ……

HOW TO GET SAP HANA CLOUD FREE TRIAL

HOW TO GET SAP HANA CLOUD FREE TRIAL ACCESS   IF you have SAP ID, SCN ID or SMP user: Click on link– SAP HANA CLOUD HOME PAGE Click log on and sign in with your SAP ID or SCN credentials. On the welcome page, click continue to complete the account creation method and launch the cockpit. The cockpit opens and shows the account dashboard of your newly created developer account. if you do not have associate SAP ID, SCN ID or ……

SAP HANA Cloud Cockpit

SAP HANA Cloud Cockpit SAP Hana Cloud cockpit is used to manage SAP HANA Cloud Platform accounts and applications. Developer accounts Access: Below is the URL of cockpit URL dashboard. https://account.hanatrial.ondemand.com/cockpit Firstyou need to have free trial account of HCP-Hana Cloud Platform: Once you login to cockpit, you’ll see the dashboard like below: From here you can create applications on SAP Hana Cloud Platform and manage those.

How to Register Program in Sap Gateway

How to Register Program in Sap Gateway Below is the command to register program in SAP Gateway,You need to execute it from SAP OS level. <program name> -a<program ID> -g<SAP gateway hostname> -x<gatewayservice> Suppose we want  “Program1 “needs to be registered: <program name> -aProgram1 -gABC -xsapgw00 <program name> is the name of the program you are trying to run. Program1 is the name given in SM59 (ProgramId). ABC is the gateway host (from the dev_rfc1 trace above) sapgw00 is the ……

Work process in Priv Mode

Work process in Priv Mode   PRIV Mode: If a dialog work process has used up the roll area assigned to it and the extended memory, private memory is assigned to the work process. The work process goes into PRIV mode (private). Why Work Process goes in Priv Mode A work process goes into PRIV mode, if the particular open transaction process has taken up all the memory in the extended memory (upto its quota- define by parameter ZTTZ/roll_extension), roll ……

Execute sql statement from SAP

Execute sql statement from SAP  Prerequisite : SE30 tips tricks function should be enabled ,In higher release i observed it’s disable and User should have editing authorization. Goto T code : SE30 click ‘Tips & tricks’ (Runtime ABAP/4 Statements) click ‘Initializing Strings’ put cursor in right box and click on Measure run-time ,It will execute your sql query.

How to understand Oracle Error Codes

How to understand Oracle Error Codes Here i explain special trick for Basis Admin to understand Oracle Error Codes with complete explanation without doing Google. Login to OS level (tested in Unix) as SIDADM user. Execute Command- oerr ora <err#> Suppose i need to look in ora 1652 which i got in some error message,Execute as below: <Host Name> oerr ora 1652 01652, 00000, “unable to extend temp segment by %s in tablespace %s” // *Cause: Failed to allocate an extent ……

Java Post Steps in SAP after Oracle Upgrade

Java Post Steps in SAP after Oracle Upgrade If you are running with Dual Stack and You have recently upgrade Oracle to new version then Java will not come ,You’ll have to do some additional steps pointing to correct oracle client version and correct rdbms.driverLocation.Please follow below steps after oracle upgrade for Java:   Change the file config.properties as follows: 1) Change to the correct directory containing the file config.properties Goto /usr/sap/<SAPSID>/DVEBMGS<instance_number>/j2ee/configtool 2) Replace the old driver location with the new ……