Import Table From Dump File in Oracle using IMPDP- Brtools

How to Import Table in oracle using IMPDP-brtools Login as orasid user and open Brtools : entering command brtools. ora<sid> 34> brtools BR0651I BRTOOLS 7.20 (31) BR0280I BRTOOLS time stamp: 2015-05-12 03.35.46 BR0656I Choice menu 1 – please make a selection ——————————————————————————- BR*Tools main menu 1 = Instance management 2 – Space management 3 – Segment management 4 – Backup and database copy 5 – Restore and recovery 6 – Check and verification 7 – Database statistics 8 – Additional functions 9 – Exit program Standard keys: c – cont, b – back, s – stop, r – refr, h ……

Support Pack Upgrade in SAP – Complete Guide

Support Pack Upgrade in SAP-SPAM-Complete Guide This Support Pack Upgrade Guide answers below queries: How to upgrade support package in sap sap support package upgrade steps Different support pack upgrade phases What to do with SPDD and SPAU Support pack upgrade prerequisites How to uncar Support packs. How to update SPAM in sap   Pre-requisites for Support Package : Download support pack from SAP Service market Place Uncar Support Packs .SAR Files SAP Check enough space under /usr/sap/trans directory. Installing the support package using transaction SPAM Log into SAP GUI, client 000 as user upgrade Go to transaction SPAM Step 1 ……

How to Uncar Support Packs .SAR Files SAP

How to Uncar Support Packs .SAR Files SAP Support Packs files downloaded from the marketplace are in the .car format. To be able to install a support package, we have to uncar these files. The procedure for uncaring of files is as given below: Uncarring the .CAR Support Pack files : On the Unix Level Login as <SID>ADM cd /usr/sap/trans<SID> /sapmnt/<SID>/exe/SAPCAR -xvf <filename>.CAR This will extract the support packages into the /usr/sap/trans/EPS/in directory automatically.

How to de Implement the sap note

How to de Implement the sap note Here you’ll get answer for below queries: How to reset sap note implementation How to de Implement the sap note How to revert sap note Please follow below steps to get answer of all these queries. Goto transaction : SNOTE Step1: Select the note and click the button ‘RESET – SAP Note Implementation’ Here it is asking to change processor : say yes All these changes will be stored in given transport number.   Done: Note has been successfully De-Implemented.

How to Enable Disable Archivelog Mode in Oracle

How to Enable/Disable Archivelog Mode in Oracle This article covers below queries: How to enable archivelog mode in Oracle How to Disable archivelog mode in Oracle turn OFF archive log mode turn ON archive log mode How to Enable Archive Log Mode: sqlplus / as sysdba SQL> archive log list Database log mode             Archive Mode Automatic archival              Enabled Archive destination              USE_DB_RECOVERY_FILE_DEST Oldest online log sequence    19 Next log sequence to archive  20 Current log sequence 20 here you’ll see Automatic archival-Enabled,That means ……

How to Import Transport From os level

How to Import Transport From os level Importing transport from OS level is 2 command process,First add transport to the buffer and then import it.It is imported by TP program delivered in SAP Kernel. Transport must be released in source system,check it in source system from SE01. Add transport request to the buffer: Execute below commands from OS level after giving input in command. tp addtobuffer <TRANSPORT NO> <SID> pf=/usr/sap/trans/bin/<TRANSPORT PROFILE NAME> <Unconditional Mode Option> Import Transport request: Execute below commands from OS level after giving input in command. tp import <TRANSPORT NO> <SID> pf=/usr/sap/trans/bin/<TRANSPORT PROFILE NAME> <Unconditional Mode Option> ……

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 sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 24 12:13:09 2016 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected ……

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 modification,All users should be locked in both client. Step 1:Login to the target system QAS 200 from SAP* or any ……

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 <server:sidadm>  rsecssfs <server:sidadm>  mkdir data <server:sidadm>  mkdir key <server:sidadm> chmod 777 data key Result: Directory Structure should look like as ……

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 SMP user: Click on link– SAP HANA CLOUD HOME PAGE Click Register and enter the specified information and make sure by ……