SAP BASIS
Kernel Upgrade for SAP Systems
This blog explains the procedure to upgrade the kernel for SAP systems Kernel : Kern…
Showing posts with the label oracleShow all
oracle
PFile and SPFile in oracle
PFile and SPFile in oracle Pfile SPfile init<sid>.ora spfile<sid>.ora Text file Binary file Edited in text editor Edited by using ALT…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Oracle Files
Oracle Files Data files: Contains all database data Name: *.dbf Location: /$ORACLE_HOME/sapdata(n) Redo logs: Contains change records (change vecto…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Oracle DB Start and Stop
Oracle DB Start and Stop SQL> startup; //mounts and opens DB (ex. Open MS word and also file) SQL>startup mount; //starts DB…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Switch on and off Archive logs in oracle
Switch on and off Archive logs in oracle SQL>shutdown immediate; SQL>startup mount; SQL>alter database noarchivelog; // to switch off S…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Oracle Table spaces
Oracle Table spaces SYSTEM (tablespace for the Oracle dictionary) SYSAUX (additional tablespace as of Oracle database 10g) PSAPTEMP (default tablesp…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
OPS$ and SSFS
SSFS Configuration OPS$: (Till version Oracle 11g and SAP Kernel 7.20) SAP connects to DB using OPS$ user OPS$ users can connect to database without…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Oracle database Directory Structure
Oracle Directory Structure
https://sureshchowdarysapbasiss.blogspot.com/
oracle
ORA-28000: the account is locked in SAP
ORA-28000: the account is locked in SAP Error : Output of R3trans -d shows ORA-28000: the account is locked Resaon : Schema User expired or pass…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Control file and its functions in Oracle
Control file is a small binary file which is necessary for the database to start and operate successfully. Functions of control file ? Each control …
https://sureshchowdarysapbasiss.blogspot.com/
SAP BASIS
Schema conversion for SAP database copy [custom direct]
-----------begin change of schema---- use EH5 go if object_id('sp_change_sapuser') is not null drop procedure sp_change_sapuser go create…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Oracle Architecture
Oracle Server : There are several files, processes and memory structures in an Oracle server. Some are used to improve performance of the datab…
https://sureshchowdarysapbasiss.blogspot.com/
SAP BASIS
Difference between homogeneous system copy and heterogoneous system copy?
This article answers the following queries: What is System refresh? What is the difference between homogeneous system copy and heteroge…
https://sureshchowdarysapbasiss.blogspot.com/
SAP BASIS
- Suresh Chowdary
- HyderaBad, Nizampet, TELANGANA, India
Social Plugin