SAP BASIS T-Code

Here are the list of T-code that involve in Client Administration in SAP BASIS

1. BDLS  - To rename the existing logical system name(CLNT<SID><client no.>).
2. BD54 or SALE - To create new logical system (CLNT<SID><client no.>).
3. SCC1 -  To move Transport requests in between clients with in the system.
4. SCCL - TO perform local client copy.
5. SCC3 - To  view the logs of on- going client copy and status of previous client copies .
6. SCC4 - To create new client( just an entry in table T000).
7. SCC5 - To delete exist client in SAP system. Need to login same client to which need to delete.
8. SCC7 - To perform post client import. which makes run time adoption of client import data.
9. SCC8 - To export exist client data.
10. SCC9 - To perform remote client copy.
11. STMS_IMPORT  - To import Transport request, Which is obtained by client export.
12. SCU0 - To perform client compare between two clients

Here are the list of T-code that involve in User Administration in SAP BASIS

SU01 User Maintenance
SU01D User Display
SU02 Maintain Authorization Profiles
SU03 Maintain Authorizations
SU05 Maintain Internet users
SU10 User Mass Maintenance
SMLG Maintain Logon Group
SUPC Profiles for activity groups
SUIM Info system Authorizations
PFCG Profile Generator
PFUD User Master Data Reconciliation

ORA-03113: end-of-file on communication channel on SAP Server

As per article Heading explain How We can fix ORA-03113 end-of-file on communication channel Error:

Observation of Problem:

SOLUTION : Follow below steps:

sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 22 10:11:09 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.

SQL> connect as sysdbaEnter Username:Enter Password:

( used oracle administration username password )

SQL>Connected to an idle instance.

SQL>startup nomountORACLE instance started.

Total System Global Area   7147094016 bytes
Fixed Size                                  3062008 bytes
Variable Size                        3573548808 bytes
Database Buffers                  3556769792 bytes
Redo Buffers                            13713408 bytes

SQL> alter database mount;

Database altered.

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> alter database clear unarchived logfile group 2;

Database altered.

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> shutdown immediateORA-01109: database not openDatabase dismounted.ORACLE instance shut down.

SQL> startup 

(startup command for Oracle Database)

ORACLE instance started.

Total System Global Area   7147094016 bytes
Fixed Size                                  3062008 bytes
Variable Size                        3573548808 bytes
Database Buffers                  3556769792 bytes
Redo Buffers                            13713408 bytes

Database mounted.
Database opened.

SQL> exit.

All above steps are follows and resolved the Error log on SAP Database connection issue with application and database.