HANA
How many tenant DB can be created per instance in SAP Hana
How Many Tenant Databases Can You Create in SAP HANA? SAP HANA offers flexible da…
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/
HANA
- Suresh Chowdary
- HyderaBad, Nizampet, TELANGANA, India
Social Plugin