SAPTechArena

Pre Export Process In Application level :-  Check the Java JRE version (Min 1.4.1). Check the QCM table entries of SAP. Check for cancelled and update task Delete table entries from TATGPC, TATGPCA Check the incremental table conversion Cancel all released jobs Check for the operation modes Delete unnecessary spool data De-schedule all SAP jobs Delete all the batch jobs Release...

SAPTECHARENA FORUM!!! ...

PROCEDURE FOR DB REFRESH: 1)      Take full offline backup of database using BRTOOLS/DB13. Brbackup –u –p init<sid>.sap –d disk –t offline –m all 2)      Generate the control file SQL> alter database backup controlfile to trace; Get the trace file from user trace directory and modify the file as following  ...

Steps when the database state is down:1. Login to sqlplus  -sqlplus /nolog  -connect / as sysdba2. The db must be mounted EXCLUSIVE and not open for operation  -startup mount;3. Check the log mode status of the database  -select log_mode from v$database;4. Setting it to noarchivelog mode  -alter database noarchivelog;5. Setting db open for user operation ...

How to check character set in OracleOne of the requirements for samePage is that the character set should be UTF-8.You can either check with your DBA or run the following SQL to determine whether your database character set is UTF-8.  SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ; It should return the value AL32UTF8. Another option is to run the following...

shutdown databaseSQL> shutdown immediate;startup database in mount modeSQL> startup mount;Change DB log modeSQL> alter database archivelog;Open DB for normal useSQL> alter database open;check archivelog statusSQL> archive log listDefault Archive log destination.1. 10g introduce new feature called FRA (flashback recovery area) so all archivelog files created in FRA.2....

# sqlplus '/as sysdba' SQL> startup nomount SQL> alter database mount standby database; Cheking ps -ef|grep ora       -- that oracle processes has been started On source db run :SQL>alter system switch logfile;      Cheking Alert log file for successfully starting Oeracle.Starting standby database  with...

To add a tempfile into the mounted  opened Oracle db:SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE'/oracle/SID/sapdata1/temp_1/temp.data1' size 32000M reuse; SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE'/oracle/SID/sapdata2/temp_2/temp.data2' size 32000M reuse; SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE'/oracle/SID/sapdata3/temp_3/temp.data3' size 32000M reuse; SQL>...

In Oracle the entity "user" and entity "schema" are same  if  provided user has created at least one object in it. Login in sqlplus as sys To list all schemas: SQL> SELECT username FROM all_users ORDER BY username; SQL> Select username from dba_users; Will give you list of all users but all users may not have created objects in it. So we...

Select  how to check all tables from schema with table sizes. SELECT /*+ PARALLEL(dba_segments,16) */ owner,        segment_name,        segment_type,        tablespace_name,        round(SUM (bytes) / POWER (2, 20), 1) size_gb       ...

procedure for applying redolog files in Oracle db.  sqlplus '/as sysdba'RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;Choose files for applying after last file enter CANCEL ALTER DATABASE OPEN RESETLOGS; Checking that resetlogs were applyed correctlySELECT * FROM "any_small_table"; SHUTDOWN IMMEDIATE; STARTU...

Sometimes it is useful to check report runtime via sqlplus when you have a date timestamp . It can be set by set time on command.thru sqlplus command prompt .SQL> set time on 11:30:01 SQL> 11:33:30 SQL> also, you may omit SQL prompt perfix entry 11:33:30 SQL> set sqlprompt > 11:33:37 > 11:33:38 >...

Connect as SYS DBA or SYSOPER privilege Stop: SQL> shutdown Options -NORMAL -IMMEDIATE -TRANSACTIONAL -ABORT START: SQL> startup Options – NOMOUNT -MOUNT -OPEN BOUNCE: SQL>startup force It is a combination of shutdown abort + startup open (But beware of this command if there are other connections to database – they will be forcefully closed) ...

Sometimes we might need to change column name in table, to do so alter table <table name> rename column <column name to be changed> to <desired column name> For example if you want to change column name from D_ID to DEPT_ID of DEPARTMENT table alter table DEPARTMENT rename column D_ID to DEPT_ID; ...

NOMOUNT: This stage is only used when first creating a database or when it is necessary to recreate a database's control files. Startup includes the following tasks.  Read the spfileSID.ora or spfile.ora or initSID.ora. Allocate the SGA(System Global Area). Startup the background processes. MOUNT: This stage is used for specific maintenance operations. The database is mounted,...

                             Logon to your database with orasid as user id and run this sqldelete from sapSID.usr02 where bname='SAP*' and mandt='XXX';commit; Where mandt is the client. Now you can login to the client using sap* and password pas...

When you want to lock/unlock an oracle user, my suggestion is to user the sql command “alter user” like: SQL> ALTER USER username ACCOUNT LOCK;SQL> ALTER USER username ACCOUNT UNLOCK; In case you need to change the password of an oracle user the recomandation from SAP is to change the password with brconnect. The right command is: brconnect [-u system/<system_password>]...

By using SQLPlus or TCODE: DBACOCKPIT to determine the total memory assigned for  System Global Area (SGA) and Program Global Area (PGA)Steps for SGA:Option 1: By using SQLPlus, Execute SQL Command: show sga (sample show ~4GB for SGA) Option 2: TCODE: DBACOCKPITTcode:...

There might be time you want to shutdown / startup only the Oracle DB. The default "STOPSAP" script by SAP will shutdown SAP and follow with the Oracle.  "STARTSAP" scripts will startup the Oracle first then follow by starting-up the SAP. 1) Login to the relevant user and...

                        Looking for some Oracle database performance reporting? The "Workload  Repository Report" is one of the report that contains important information for the database  performance analysis.The...