2.

1
follow as per run book

2.6
follow as per run book

2.7
(oraae6@am2hc219-PE6 AE6 SANDBOX-) /oracle/AE6/dbs > grep dbf initAE6.ora
*.control_files='/oracle/AE6/sapdata1/cntrl/cntrlAE6.dbf','/oracle/AE6/saparch/cntrl/cntrl
AE6.dbf','/oracle/AE6/origlogA/cntrl/cntrlAE6.dbf'

2.9
SMLG
Rz12
2.10
2.11
2.12
DB13
2.13
(ae6adm@am2hc219-PE6 AE6 SANDBOX-) /home/ae6adm > saplicense -show
LICENSE system: AE6 hardware key: M0726937769 expiration_date: 99991231
installation no: 0020115064 key: EVJWQKNMDJXPGJMHJHKLB1AC
userlimit: 0 productid: R3_ORA
system-nr: 000000000310137591
*** license useable ***
LICENSE system: PE6 hardware key: C1484689195 expiration_date: 99991231
installation no: 0020115064 key: 421GHAJAKTQX6VN3C6RHRANT
userlimit: 0 productid: R3_ORA
system-nr: 000000000310364480
*** license useable ***
LICENSE system: PE6 hardware key: E1268246061 expiration_date: 99991231
installation no: 0020115064 key: N782KZZJ8JGONA8K4R2Y9GHH
userlimit: 0 productid: R3_ORA
system-nr: 000000000310364480
*** license useable ***
LICENSE system: PE6 hardware key: F1726079308 expiration_date: 99991231
installation no: 0020115064 key: PNTT8NAQJQQQTVPVNVX86S1Z
userlimit: 0 productid: R3_ORA
system-nr: 000000000310364480
*** license useable ***
2.14
(oraae6@am2hc219-PE6 AE6 SANDBOX-) /oracle/AE6/sapreorg/ae6_apr20_refresh >
exp " '/ as sysdba' " file=ae6_170410_1.dmp
tables=SAPPE6.RSECTAB,SAPPE6.RSECACTB,SAPPE6.RFCATTRIB,SAPPE6.RFC
DES,SAPPE6.RFCDESSECU,SAPPE6.RFCDOC,SAPPE6.RFCTRUST,SAPPE6.RFCS
YSACL,SAPPE6.IACORDES,SAPPE6.TSPSV,SAPPE6.TSPSI,SAPPE6.TSP03,SAPPE
6.TSP03A,SAPPE6.TSP03C,SAPPE6.TSP03D,SAPPE6.TSP03L,SAPPE6.TSP03T,SAP
PE6.TBD11,SAPPE6.TWPURLSVR,SAPPE6.ROIDOCPRMS,SAPPE6.V_TBDLS,SAP
PE6.SXNODES,SAPPE6.SXROUTE,SAPPE6.SXSERV,SAPPE6.SXADMINTAB,SAP
PE6.SXDOMAINS,SAPPE6.SOPR,SAPPE6.SXADDRTYPE,SAPPE6.SXCONVERT,S
APPE6.SXCONVERT2,SAPPE6.SXCOS,SAPPE6.SXCOS_T,SAPPE6.SXDEVTYPE,S
APPE6.SXFORMATG,SAPPE6.SXJOBS,SAPPE6.SXRETRY,SAPPE6.SXRFC,SAPPE
6.SXTELMOIN,SAPPE6.SXTELMOOUT,SAPPE6.T160PR,SAPPE6.TWPSSO2ACL,S
APPE6.SSF_PSE_H,SAPPE6.SSF_PSE_D,SAPPE6.SSFARGS,SAPPE6.SXMSCONFV
L,SAPPE6.CREP_HTTP,SAPPE6.HTTPURLLOC,SAPPE6.RSADMINA,SAPPE6.RSD
DTREXADMIN,SAPPE6.RSPOR_T_PORTAL buffer=1024000 grants=N indexes=N
consistent=Y compress=N direct=y log=ae6_170410_1.log

Export: Release 10.2.0.4.0 - Production on Fri Apr 16 04:11:00 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
EXP-00105: parameter CONSISTENT is not supported for this user
Export done in WE8DEC character set and UTF8 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported

About to export specified tables via Direct Path ...

Current user changed to SAPPE6
. . exporting table RSECTAB 0 rows exported
. . exporting table RSECACTB 0 rows exported
. . exporting table RFCATTRIB 62 rows exported
. . exporting table RFCDES 81 rows exported
. . exporting table RFCDESSECU 1 rows exported
EXP-00011: SAPPE6.RFCDOC does not exist
. . exporting table RFCTRUST 1 rows exported
. . exporting table RFCSYSACL 1 rows exported
. . exporting table IACORDES 4 rows exported
. . exporting table TSPSV 5 rows exported
EXP-00011: SAPPE6.TSPSI does not exist
. . exporting table TSP03 8 rows exported
. . exporting table TSP03A 2 rows exported
. . exporting table TSP03C 8 rows exported
. . exporting table TSP03D 8 rows exported
. . exporting table TSP03L 8 rows exported
. . exporting table TSP03T 0 rows exported
. . exporting table TBD11 29 rows exported
. . exporting table TWPURLSVR 1 rows exported
. . exporting table ROIDOCPRMS 5 rows exported
EXP-00011: SAPPE6.V_TBDLS does not exist
. . exporting table SXNODES 2 rows exported
. . exporting table SXROUTE 14 rows exported
. . exporting table SXSERV 2 rows exported
. . exporting table SXADMINTAB 1 rows exported
. . exporting table SXDOMAINS 0 rows exported
. . exporting table SOPR 2 rows exported
. . exporting table SXADDRTYPE 30 rows exported
. . exporting table SXCONVERT 10 rows exported
. . exporting table SXCONVERT2 30 rows exported
. . exporting table SXCOS 0 rows exported
. . exporting table SXCOS_T 0 rows exported
. . exporting table SXDEVTYPE 8 rows exported
. . exporting table SXFORMATG 0 rows exported
. . exporting table SXJOBS 1 rows exported
. . exporting table SXRETRY 0 rows exported
. . exporting table SXRFC 0 rows exported
. . exporting table SXTELMOIN 0 rows exported
. . exporting table SXTELMOOUT 0 rows exported
EXP-00011: SAPPE6.T160PR does not exist
. . exporting table TWPSSO2ACL 2 rows exported
. . exporting table SSF_PSE_H 3 rows exported
. . exporting table SSF_PSE_D 20 rows exported
. . exporting table SSFARGS 0 rows exported
EXP-00011: SAPPE6.SXMSCONFVL does not exist
. . exporting table CREP_HTTP 1 rows exported
. . exporting table HTTPURLLOC 0 rows exported
EXP-00011: SAPPE6.RSADMINA does not exist
EXP-00011: SAPPE6.RSDDTREXADMIN does not exist
EXP-00011: SAPPE6.RSPOR_T_PORTAL does not exist
Export terminated successfully with warnings.

2.18

2.22 E070L
2.24
Preserver BBP_CAT_VALUES.
exp " '/ as sysdba' " file=ae6_101209_bbpcatval.dmp tables=sappe6.bbp_cat_values
buffer=1024000 grants=N indexes=N consistent=Y compress=N direct=y
log=ae6_101209_bbpcatval.log

2.25
exp " '/ as sysdba' " file=ae6_101209_sncsysacl.dmp tables=sappe6.sncsysacl
buffer=1024000 grants=N indexes=N consistent=Y compress=N direct=y log=
ae6_101209_sncsysacl.log
2.26

exp " '/ as sysdba' " file=ae6_101209_usraclext.dmp tables=sappe6.usraclext

buffer=1024000 grants=N indexes=N consistent=Y compress=N direct=y log=
ae6_101209_usraclext.log

2.27
2.28
exp " '/ as sysdba' " file=ae6_101209_smen_buffc.dmp tables=sappe6.smen_buffc
buffer=1024000 grants=N indexes=N consistent=Y compress=N direct=y log=
ae6_101209_smen_buffc.log

smen_buffi
exp " '/ as sysdba' " file=ae6_101209_smen_buffi.dmp tables=sappe6.smen_buffi
buffer=1024000 grants=N indexes=N consistent=Y compress=N direct=y log=
ae6_101209_smen_buffi.log

2.33

exp " '/ as sysdba' " file=exportbug.dmp owner=bugreq indexes=y grants=y direct=y
log=exportbug.log
am2hc219:oraae6 61> exp " '/ as sysdba' " file=exportbug.dmp owner=bugreq indexes=y
grants=y direct=y log=exportbug.log

Export: Release 10.2.0.4.0 - Production on Thu Dec 10 06:07:59 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8DEC character set and UTF8 NCHAR character set

About to export specified users ...

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user BUGREQ
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user BUGREQ
About to export BUGREQ's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export BUGREQ's tables via Direct Path ...
. . exporting table ACTION 3 rows exported
. . exporting table ACTION_LOG 0 rows exported
. . exporting table APPLICATION 0 rows exported
. . exporting table APPROVAL_COMMENT 0 rows exported
. . exporting table APPROVAL_CONFIG 0 rows exported
. . exporting table APPROVAL_CONFIG_NEXT 0 rows exported
. . exporting table ATTRIBUTEMAP 0 rows exported
. . exporting table ATTRIBUTEMAPRULE 0 rows exported
. . exporting table ATTRIBUTE_SECURITY 0 rows exported
. . exporting table BUGSEYE_APPROVAL 0 rows exported
. . exporting table BUGSEYE_BG_JOBS 0 rows exported
. . exporting table BUGSEYE_CONFIG 1446 rows exported
. . exporting table BUGSEYE_FLAGS 1 rows exported
. . exporting table BUGSEYE_PROPERTIES 2634 rows exported
. . exporting table BUGSEYE_TAB 64 rows exported
. . exporting table C100736 27 rows exported
. . exporting table C100756 245 rows exported
. . exporting table C100770 9 rows exported
. . exporting table C100800 73 rows exported
. . exporting table C100831 142 rows exported
. . exporting table C100864 17 rows exported
. . exporting table C100874 7 rows exported
. . exporting table C101646 456 rows exported
. . exporting table C101647 0 rows exported
. . exporting table C101648 132 rows exported
. . exporting table C101649 1 rows exported
. . exporting table C101856 9 rows exported
. . exporting table C101857 3 rows exported
. . exporting table CATALOG_INFO 0 rows exported
. . exporting table CATEGORY 1217 rows exported
. . exporting table CATEGORYMAP 0 rows exported
. . exporting table CATEGORY_DEFAULT 0 rows exported
. . exporting table CATEGORY_ITEM 17687 rows exported
. . exporting table CAT_DATA_SOURCE 0 rows exported
. . exporting table CLEANSER_RULES 0 rows exported
. . exporting table CONTENTATTRIBUTE 0 rows exported
. . exporting table CONTENTGROUP 0 rows exported
. . exporting table CONTENTMAP 0 rows exported
. . exporting table CONTEXT_POLICY 1 rows exported
. . exporting table CONTEXT_POLICY_DESCRIPTOR 0 rows exported
. . exporting table CONTRACT 0 rows exported
. . exporting table CONTRACT_CURRENCY 0 rows exported
. . exporting table CONTRACT_HISTORY 0 rows exported
. . exporting table CONTRACT_LOCAL_ATTRIBUTE_MAP 0 rows exported
. . exporting table CONTRACT_PRICE 0 rows exported
. . exporting table CONTRACT_PRICE_HISTORY 0 rows exported
. . exporting table DESCRIPTOR 208 rows exported
. . exporting table ECLASS 0 rows exported
. . exporting table EXT_QUERY 0 rows exported
. . exporting table FAVORITES_ITEM 0 rows exported
. . exporting table FAVORITE_LISTS 0 rows exported
. . exporting table GLOBAL_ITEM_RESULTS
. . exporting table GLOSSARY 0 rows exported
. . exporting table GRANTED_VIEW 0 rows exported
. . exporting table GROUPING_PRICE_MODEL 0 rows exported
. . exporting table GROUPS 9 rows exported
. . exporting table GROUPS_SEARCH 0 rows exported
. . exporting table INELIGIBLE_PASSWORDS 0 rows exported
. . exporting table ITEM 17687 rows exported
. . exporting table ITEMCATEGORYMAP 0 rows exported
. . exporting table ITEMHISTORY 0 rows exported
. . exporting table ITEM_CONSTRAINT 0 rows exported
. . exporting table ITEM_SITE 0 rows exported
. . exporting table ITEM_TL 17687 rows exported
. . exporting table ITEM_VIEW_TABLE 0 rows exported
. . exporting table JMS_CONFIG 0 rows exported
. . exporting table JOB_LOG 1156 rows exported
. . exporting table LANGUAGE 42 rows exported
. . exporting table LOAD_ITEM_MATCH 0 rows exported
. . exporting table LOG 43798 rows exported
. . exporting table LOGIN_LOG 6045 rows exported
. . exporting table MATRIX_ATTRIB 0 rows exported
. . exporting table MESSAGE 0 rows exported
. . exporting table METADATA 0 rows exported
. . exporting table MORPHOLOGY 0 rows exported
. . exporting table NAVIGATION 953 rows exported
. . exporting table OBJECT_STORE 0 rows exported
. . exporting table OWNER 1 rows exported
. . exporting table PASSWORD_HISTORY 412 rows exported
. . exporting table PRICE 7 rows exported
. . exporting table PRICEMODEL 0 rows exported
. . exporting table QUEUE 0 rows exported
. . exporting table QUEUE_MESSAGE 0 rows exported
. . exporting table RIGHTS_SET 165 rows exported
. . exporting table RIGHTS_SET_CONTRACT_INTRSCT 0 rows exported
. . exporting table RIGHTS_SET_SRCH_CNFIG_INTRSCT 2606 rows exported
. . exporting table RIGHTS_SET_VIEW_INTERSECT 0 rows exported
. . exporting table RULE 1 rows exported
. . exporting table RULE_TABLE_INFO 0 rows exported
. . exporting table RULE_TYPES 41 rows exported
. . exporting table RUSUPDATEFILE 0 rows exported
. . exporting table SCHEDULER 14 rows exported
. . exporting table SEARCH_CONFIG 110 rows exported
. . exporting table SEARCH_CONFIG_POLICY 1 rows exported
. . exporting table SEARCH_CONFIG_VIEW 110 rows exported
. . exporting table SEARCH_RESULTS
. . exporting table SERIALIZED_JOB 0 rows exported
. . exporting table SHIPPING_MODEL 0 rows exported
. . exporting table SHOPPING_CART 14 rows exported
. . exporting table SINGLEPRICEMODEL 0 rows exported
. . exporting table SITE 0 rows exported
. . exporting table SOURCE 0 rows exported
. . exporting table SOURCECONTENTGROUP 0 rows exported
. . exporting table STOP_LIST 0 rows exported
. . exporting table STOP_LIST_ADMIN 2 rows exported
. . exporting table STOP_LIST_POLICY 0 rows exported
. . exporting table STOP_LIST_WORD 34 rows exported
. . exporting table SUPPLIERSOURCE 0 rows exported
. . exporting table SUPPLIER_LIST 1 rows exported
. . exporting table SUPPLIER_TOC 1 rows exported
. . exporting table TABLE_INFO 3 rows exported
. . exporting table TAB_CONTROL 3 rows exported
. . exporting table TAX_MODEL 0 rows exported
. . exporting table TITLE_REGISTRY 1 rows exported
. . exporting table UNIT 0 rows exported
. . exporting table UNITGROUP_TL 38 rows exported
. . exporting table UNITS 310 rows exported
. . exporting table UNITS_CODES 627 rows exported
. . exporting table UNITS_TL 310 rows exported
. . exporting table UNSPSC 0 rows exported
. . exporting table USERS 139 rows exported
. . exporting table VERSION_INFO 10 rows exported
. . exporting table VIEW_COMPOSITE 0 rows exported
. . exporting table VIEW_CONSTRAINT 119 rows exported
. . exporting table VIEW_REGISTRY 111 rows exported
. . exporting table VIEW_SEARCHABLE_DESCRIPTOR 0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

2.34
COMMAND: am2hc219:oraae6 1> exp sapae6db/penguin7 file=exportj2ee_2.dmp
full=y indexes=y grants=y direct=y log=exportj2ee_2.log (done in /ORACLE/AE6)

Export: Release 10.2.0.4.0 - Production on Fri Dec 11 06:22:36 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
EXP-00023: must be a DBA to do Full Database or Tablespace export
(2)U(sers), or (3)T(ables): (2)U > mode (2) U(sers)

EXP-00012: mode (okM is not a valid export mode

(2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes > YES

Export table data (yes/no): yes > YES

Compress extents (yes/no): yes > YES

Export done in WE8DEC character set and UTF8 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SAPAE6DB
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SAPAE6DB
About to export SAPAE6DB's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SAPAE6DB's tables via Direct Path ...
. . exporting table BC_CMSRTS 0 rows exported
. . exporting table BC_COMPVERS 339 rows exported
. . exporting table BC_CPT_ACTION 0 rows exported
. . exporting table BC_CPT_ALLOC_ID 0 rows exported
. . exporting table BC_CPT_CORRELATOR 0 rows exported
. . exporting table BC_CPT_CORR_DEF 0 rows exported
. . exporting table BC_CPT_IMPORT_LOCK 0 rows exported
Table BC_CPT_METRIC will be exported in conventional path.
. . exporting table BC_CPT_METRIC 0 rows exported
. . exporting table BC_CPT_METRIC_DEF 0 rows exported
. . exporting table BC_CPT_MODULE 0 rows exported
. . exporting table BC_CPT_ORIGIN 0 rows exported
. . exporting table BC_CPT_PROVIDER 0 rows exported
. . exporting table BC_CPT_RECORD 0 rows exported
. . exporting table BC_CPT_RECORD_CORR 0 rows exported
. . exporting table BC_CPT_THREAD 0 rows exported
. . exporting table BC_CVERS 0 rows exported
. . exporting table BC_DDDBRTH 129 rows exported
. . exporting table BC_DDDBRTX 11759 rows exported
Table BC_DDDBTABLERT will be exported in conventional path.
. . exporting table BC_DDDBTABLERT 129 rows exported
. . exporting table BC_ETE_ACTIVITIES 0 rows exported
. . exporting table BC_ETE_SYSACTIVITY 0 rows exported
. . exporting table BC_ETE_SYSORIGIN 0 rows exported
. . exporting table BC_ETE_SYSTEMS 0 rows exported
. . exporting table BC_JARM_CHISTORY 0 rows exported
. . exporting table BC_JARM_COMPONENT 0 rows exported
. . exporting table BC_JARM_REQUEST 0 rows exported
. . exporting table BC_JARM_RHISTORY 0 rows exported
. . exporting table BC_JARM_UHISTORY 0 rows exported
. . exporting table BC_JARM_USER 0 rows exported
Table BC_JMSDMSGQ will be exported in conventional path.
. . exporting table BC_JMSDMSGQ 0 rows exported
Table BC_JMSQUEUE will be exported in conventional path.
. . exporting table BC_JMSQUEUE 0 rows exported
Table BC_JMSTOPIC will be exported in conventional path.
. . exporting table BC_JMSTOPIC 0 rows exported
. . exporting table BC_JMSTOPICSUB 0 rows exported
Table BC_JMSTXLOG will be exported in conventional path.
. . exporting table BC_JMSTXLOG 0 rows exported
. . exporting table BC_MON_AGREGATES 0 rows exported
. . exporting table BC_MON_ID_ALLOC 0 rows exported
. . exporting table BC_MON_MONITORS 0 rows exported
Table BC_RPROF_PROFILE will be exported in conventional path.
. . exporting table BC_RPROF_PROFILE 3 rows exported
. . exporting table BC_SCCOMPAT 0 rows exported
. . exporting table BC_SCCOVERAGE 0 rows exported
. . exporting table BC_SCREQUIRED 0 rows exported
. . exporting table BC_SCVERSION 0 rows exported
Table BC_SESSIONFAILOVER will be exported in conventional path.
. . exporting table BC_SESSIONFAILOVER 0 rows exported
. . exporting table BC_SLD_ASSINST 0 rows exported
. . exporting table BC_SLD_ASSOC 0 rows exported
Table BC_SLD_CHANGELOG will be exported in conventional path.
. . exporting table BC_SLD_CHANGELOG 0 rows exported
Table BC_SLD_CLASS will be exported in conventional path.
. . exporting table BC_SLD_CLASS 0 rows exported
Table BC_SLD_DELTAEXPORT will be exported in conventional path.
. . exporting table BC_SLD_DELTAEXPORT 0 rows exported
Table BC_SLD_INST will be exported in conventional path.
. . exporting table BC_SLD_INST 0 rows exported
. . exporting table BC_SLD_INSTANCES 0 rows exported
Table BC_SLD_LONGVALUES will be exported in conventional path.
. . exporting table BC_SLD_LONGVALUES 0 rows exported
. . exporting table BC_SLD_NAMESP 0 rows exported
. . exporting table BC_SLD_NAMESPACES 0 rows exported
. . exporting table BC_SLD_PROPARRAYS 0 rows exported
. . exporting table BC_SLD_PROPERTIES 0 rows exported
. . exporting table BC_SLD_PROPERTYREF 0 rows exported
Table BC_SLD_QUAL will be exported in conventional path.
. . exporting table BC_SLD_QUAL 0 rows exported
. . exporting table BC_SLD_QUALIFIERS 0 rows exported
. . exporting table BC_SLD_ROLE 0 rows exported
. . exporting table BC_SLM_JNET 0 rows exported
Table BC_SLM_JNET_DATA will be exported in conventional path.
. . exporting table BC_SLM_JNET_DATA 0 rows exported
. . exporting table BC_SLM_PLAN 0 rows exported
Table BC_SLM_PLAN_CIM will be exported in conventional path.
. . exporting table BC_SLM_PLAN_CIM 0 rows exported
Table BC_SLM_PLAN_DATA will be exported in conventional path.
. . exporting table BC_SLM_PLAN_DATA 0 rows exported
. . exporting table BC_SLM_USER 0 rows exported
Table BC_SYNCLOG will be exported in conventional path.
. . exporting table BC_SYNCLOG 124 rows exported
Table BC_UDDI_ACCOUNT will be exported in conventional path.
. . exporting table BC_UDDI_ACCOUNT 0 rows exported
. . exporting table BC_UDDI_BE_DISCURL 0 rows exported
Table BC_UDDI_BE_MAIN will be exported in conventional path.
. . exporting table BC_UDDI_BE_MAIN 0 rows exported
Table BC_UDDI_BS_MAIN will be exported in conventional path.
. . exporting table BC_UDDI_BS_MAIN 0 rows exported
. . exporting table BC_UDDI_BS_PROJ 0 rows exported
Table BC_UDDI_BT_MAIN will be exported in conventional path.
. . exporting table BC_UDDI_BT_MAIN 0 rows exported
Table BC_UDDI_BT_TMINST will be exported in conventional path.
. . exporting table BC_UDDI_BT_TMINST 0 rows exported
Table BC_UDDI_CHGREC will be exported in conventional path.
. . exporting table BC_UDDI_CHGREC 0 rows exported
Table BC_UDDI_CHGREC_ERR will be exported in conventional path.
. . exporting table BC_UDDI_CHGREC_ERR 0 rows exported
. . exporting table BC_UDDI_ELEM_CB 0 rows exported
. . exporting table BC_UDDI_ELEM_IB 0 rows exported
Table BC_UDDI_ELEM_KEY will be exported in conventional path.
. . exporting table BC_UDDI_ELEM_KEY 0 rows exported
. . exporting table BC_UDDI_ELEM_NAME 0 rows exported
. . exporting table BC_UDDI_PARAM 82 rows exported
Table BC_UDDI_PUBA will be exported in conventional path.
. . exporting table BC_UDDI_PUBA 0 rows exported
. . exporting table BC_UDDI_SESSION 0 rows exported
. . exporting table BC_UDDI_STAT 0 rows exported
. . exporting table BC_UDDI_TAXONOMY 0 rows exported
. . exporting table BC_UDDI_THREAD 0 rows exported
Table BC_UDDI_TM_MAIN will be exported in conventional path.
. . exporting table BC_UDDI_TM_MAIN 0 rows exported
Table BC_WA_GROUP will be exported in conventional path.
. . exporting table BC_WA_GROUP 0 rows exported
Table BC_WA_SYSTEM will be exported in conventional path.
. . exporting table BC_WA_SYSTEM 0 rows exported
. . exporting table BC_WA_SYS_TO_GROUP 0 rows exported
. . exporting table BC_WA_USER 0 rows exported
. . exporting table BC_XMLA_ASESSIONS 0 rows exported
. . exporting table BC_XMLA_ASETS 6 rows exported
. . exporting table BC_XMLA_COL 1 rows exported
. . exporting table BC_XMLA_COL_INDEX 0 rows exported
. . exporting table BC_XMLA_COL_STORE 0 rows exported
. . exporting table BC_XMLA_CONFIG 0 rows exported
. . exporting table BC_XMLA_INDEX_COLS 0 rows exported
. . exporting table BC_XMLA_INDEX_DICT 0 rows exported
. . exporting table BC_XMLA_LOCKING 0 rows exported
. . exporting table BC_XMLA_MAXIDS 5 rows exported
. . exporting table BC_XMLA_NAMESPACES 0 rows exported
. . exporting table BC_XMLA_POLLING 0 rows exported
. . exporting table BC_XMLA_PROPS 0 rows exported
. . exporting table BC_XMLA_RES 0 rows exported
. . exporting table BC_XMLA_RESTYPES 4 rows exported
Table GLAS_MEASUREMENT will be exported in conventional path.
. . exporting table GLAS_MEASUREMENT 0 rows exported
. . exporting table J2EE_CONFIG 7803 rows exported
Table J2EE_CONFIGENTRY will be exported in conventional path.
. . exporting table J2EE_CONFIGENTRY 16623 rows exported
. . exporting table J2EE_KEYSEQUENCE 1 rows exported
. . exporting table SP_PLUG_IN_SAVES 0 rows exported
Table SP_RESULTS will be exported in conventional path.
. . exporting table SP_RESULTS 0 rows exported
Table SP_STORAGE will be exported in conventional path.
. . exporting table SP_STORAGE 2 rows exported
. . exporting table TC_WDRR_FGUID 0 rows exported
. . exporting table TC_WDRR_LAYERS 2 rows exported
Table TC_WDRR_MRO_FILES will be exported in conventional path.
. . exporting table TC_WDRR_MRO_FILES 189 rows exported
Table TC_WDRR_MRO_LANG will be exported in conventional path.
. . exporting table TC_WDRR_MRO_LANG 0 rows exported
. . exporting table TC_WDRR_MRO_LUT 199 rows exported
. . exporting table TC_WDRR_TYPES 3 rows exported
. . exporting table TC_WDRR_VARIANTS 0 rows exported
. . exporting table UME_ACL_ACL 0 rows exported
. . exporting table UME_ACL_ACLENTRY 0 rows exported
. . exporting table UME_ACL_MANAGER 0 rows exported
. . exporting table UME_ACL_OWNER 0 rows exported
. . exporting table UME_ACL_PERM 0 rows exported
. . exporting table UME_ACL_PERM_MEM 0 rows exported
. . exporting table UME_ACL_SUP_PERM 0 rows exported
Table UME_BLOBS will be exported in conventional path.
. . exporting table UME_BLOBS 0 rows exported
. . exporting table UME_STRINGS 264 rows exported
. . exporting table UME_USERNUMBER 0 rows exported
Table UME_USERSYNC will be exported in conventional path.
. . exporting table UME_USERSYNC 0 rows exported
. . exporting table UME_USERSYNCLOCK 0 rows exported
. . exporting table UME_USERSYNCTEMP 0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.

2.29
2.35 AND 2.36
PERFORM WHEN DOWNTIME STARTS

Take RFC Screen shots which are not working

SM59

Internal Connections
Disable Cron tab

Crontab –e

Change the parameters

login/no_automatic_user_sapstar to ‘0 ‘
rdisp/wp_no_btc =0 (previous value 6)
rdisp/btctime=0

2.35 stop ipc

Stop IPC:

su - ipcadm
cd /usr/sap/<SID>/D*/ipc/bin
./ipcserver stop
./ipcdispatcher stop

Down the sap.

Stop listerner control and saposcol.

Check any SAP and oracle process are running and kill if any process are running
Ps –ef |grep sap and ps –ef |grep ora.
Kill -9 process id to kill the process.

Crontab -e

Delete the sapdata files with command rm –rf *

Now unmount using script or using command

umount -f /oracle/AE6/sapdata1

now perform Restore

Now login to source system and create the control fileusing the command
sql> alter database backup controlfile to trace;

goto /saptrace/usertrace
and open the trace file with “ VI” COMMAND
FIRST 2 LINES SHOULD ,
CHANGE “REUSE” TO SET AND “NORESETLOGS” TO RESETLOGS”
AND RENAME THE SOURCE SID TO TARGET SID USING COMMAND
%s/PE6/AE6/g
Than rname the trace file to control.sql

NOW copy the control file to target system using command scp

am2hc111:orape6 14> scp -r ub6redo oraae6@ciae606:/oracle/AE6/oraarch

ciae606 is hostname and ub6redo is directory . copying from ub6redo to

ciae606:/oracle/AE6/oraarch
oraae6@ciae606's password:
Permission denied, please try again.
oraae6@ciae606's password:
PE6arch1_2668_701069728.dbf.Z
100% 35MB 35.0MB/s 00:01
PE6arch1_2669_701069728.dbf.Z
99% 51MB 25.6MB/s 00:02
PE6arch1_2670_701069728.dbf.Z
100% 39MB 38.6MB/s 00:01
PE6arch1_2671_701069728.dbf.Z
99% 38MB 19.2MB/s 00:02
PE6arch1_2672_701069728.dbf.Z
100% 38MB 18.8MB/s 00:02
PE6arch1_2673_701069728.dbf.Z
99% 38MB 18.8MB/s 00:02
PE6arch1_2674_701069728.dbf.Z
100% 58MB 19.3MB/s 00:03
PE6arch1_2675_701069728.dbf.Z
99% 53MB 26.5MB/s 00:02
PE6arch1_2676_701069728.dbf.Z
100% 58MB 19.5MB/s 00:03
Once after recover mount the file system
(ae6adm@am2hc219-PE6 AE6 SANDBOX-) /usr/sap/adaptive/scripts >
./AE6_06_DB.sh up mount
(ae6adm@am2hc219-PE6 AE6 SANDBOX-) /usr/sap/adaptive/scripts > ./AE6_06_CI.sh
up mount

Change the permissions for sapdata files using root

chown –R oraae6:dba /oracle/AE6/sapdata*/*

change the owner for sapdata1

(root@am2hc219-PE6-SANDBOX) /oracle/AE6 > chown oraae6:dba sapdata1/

Rename the control files

Move the archive files from source to target and chabe the owner and permissions and
rename the files from source to target and gunzip the archive files.

Start listner

Create control file

@/path of control file/file.sql
Shutdown the database using command
Shutdown immediate;
Startup mount(since recover should be done in mount option)
Recover using commaabd
recover database until time '2010-04-17:00:09:00' using backup controlfile;
click AUTO

ALTER DATABASE OPEN RESETLOGS;

Run the script

grant select any table to SAPPE6;

create view sys.p_ktfbfe as select * from sys.x$ktfbfe;
grant select any dictionary to SAPPE6;
drop user ops$sidadm cascade; <--- source sid
drop user ops$orasid cascade; <--- source sid
create user ops$sidadm identified externally default tablespace pSAPPE6usr temporary
tablespace psaptemp;
create user ops$orasid identified externally default tablespace pSAPPE6usr temporary
tablespace psaptemp;
grant dba, resource, connect to ops$orasid with admin option;
grant dba, resource, connect to ops$sidadm with admin option;
create table ops$sidadm.sapuser (userid varchar2(256), passwd varchar2(256));
insert into ops$sidadm.sapuser values ('SAPPE6','Stop432#');
commit;

Shut down the db

Shutdown immediate;
Try to start the db with script

If wee get the above error change the schema password

using brtools.
Passwor change procedure
(oraae6@am2hc219-PE6 AE6 SANDBOX-) /oracle/AE6 > brtools
BR0651I BRTOOLS 7.00 (32)

BR0280I BRTOOLS time stamp: 2010-04-17 11.49.41

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 - help

-------------------------------------------------------------------------------
BR0662I Enter your choice:
8
BR0280I BRTOOLS time stamp: 2010-04-17 11.49.45
BR0663I Your choice: '8'

BR0280I BRTOOLS time stamp: 2010-04-17 11.49.45

BR0656I Choice menu 2 - please make a selection
-------------------------------------------------------------------------------
Additional BR*Tools functions

1 = Show profiles and logs

2 - Clean up DBA logs and tables
3 - Adapt NEXT extents
4 - Change password of database user
5 - Create/change synonyms for DBA tables
6 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------
BR0662I Enter your choice:
4
BR0280I BRTOOLS time stamp: 2010-04-17 11.49.48
BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2010-04-17 11.49.48

BR0657I Input menu 59 - please check/enter input values
-------------------------------------------------------------------------------
BRCONNECT options for changing password of database user

1 - BRCONNECT profile (profile) ............... [initAE6.sap]

2 - Database user/password (user) ............. [/]
3 ~ Database owner to change password (owner) . []
4 ~ Log file name (log) ....................... []
5 - Message language (language) ............... [E]
6 - BRCONNECT command line (command) .......... [-p initAE6.sap -l E -f chpass]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2010-04-17 11.49.51
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2010-04-17 11.49.51

BR0681I Enter string value for "user" [/]:
SAPPE6
BR0280I BRTOOLS time stamp: 2010-04-17 11.49.57
BR0683I New value for "user": 'SAPPE6'
BR0263I Enter password for database user 'SAPPE6' (max. 30 characters):

BR0280I BRTOOLS time stamp: 2010-04-17 11.50.05

BR0657I Input menu 59 - please check/enter input values
-------------------------------------------------------------------------------
BRCONNECT options for changing password of database user

1 - BRCONNECT profile (profile) ............... [initAE6.sap]

2 - Database user/password (user) ............. [SAPPE6/********]
3 ~ Database owner to change password (owner) . []
4 ~ Log file name (log) ....................... []
5 - Message language (language) ............... [E]
6 - BRCONNECT command line (command) .......... [-p initAE6.sap -l E -f chpass]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2010-04-17 11.50.10
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRCONNECT will be started with options '-p initAE6.sap -l E -f chpass'

BR0280I BRTOOLS time stamp: 2010-04-17 11.50.10
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2010-04-17 11.50.12
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

########################################################################
#######

BR0801I BRCONNECT 7.00 (32)

BR0280I BRCONNECT time stamp: 2010-04-17 11.50.13
BR1048I Enter new password for database user 'SAPPE6' (max. 30 characters):

BR0280I BRCONNECT time stamp: 2010-04-17 11.50.24

BR1048I Reenter new password for database user 'SAPPE6' (max. 30 characters):

BR0280I BRCONNECT time stamp: 2010-04-17 11.50.31

BR0829I Password changed successfully in database for user SAPPE6
BR0830I Password changed successfully in table OPS$AE6ADM.SAPUSER for user
SAPPE6
BR0280I BRCONNECT time stamp: 2010-04-17 11.50.31
BR1048I Enter new password for database user 'SAPPE6DB' (max. 30 characters):

BR0264E Entering user name/password failed

BR0832E Setting password for user SAPPE6DB failed

BR0280I BRCONNECT time stamp: 2010-04-17 11.50.55

BR0804I BRCONNECT terminated with errors

########################################################################
#######

BR0292I Execution of BRCONNECT finished with return code 5

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to
repeat the last action

BR0280I BRTOOLS time stamp: 2010-04-17 11.50.55

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2010-04-17 11.50.58
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2010-04-17 11.50.58

BR0656I Choice menu 2 - please make a selection
-------------------------------------------------------------------------------
Additional BR*Tools functions

1 = Show profiles and logs

2 - Clean up DBA logs and tables
3 - Adapt NEXT extents
4 + Change password of database user
5 - Create/change synonyms for DBA tables
6 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------
BR0662I Enter your choice:
s
BR0280I BRTOOLS time stamp: 2010-04-17 11.51.03
BR0663I Your choice: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2010-04-17 11.51.05
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2010-04-17 11.51.05

BR0654I BRTOOLS terminated with errors
(oraae6@am2hc219-PE6 AE6 SANDBOX-) /oracle/AE6 > sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Apr 17 11:51:09 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter user-name: SAPPE6

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit

Now start up the system

Post Processing Steps

4.7 Aplly License

4.12
FOLLOW AS RUN BOOK
AFTER ENABLE THE CRONTAB RUN THE SAPDBA_ROLE SCRIPT

4.13
FOLLOW AS RUN BOOK

4.15

FOLLOW AS RUN BOOK

4.16
FOLLOW AS RUN BOOK

4.17
FOLLOW AS RUN BOOK

4.18 FOLLOW AS RUN BOOK

4.19 TO 4.24
FOLLOW AS RUN BOOK

RUN BDLS AS PER STEP 6.2

Ggoto SLG1 AND CHECK THE BDLS LOGS

4.30 AND 4.31 AND 4.32
FOLLOW AS RUN BOOK

4.38 TO 4.40
FOLLOW AS RUN BOOK

4.44
FOLLOW AS RUN BOOK

4.48

Import all the atandard tables

First rename the tables
alter table SAPPE6.RSECTAB rename to RSECTAB_old;
alter table SAPPE6.RSECACTB rename to RSECACTB_old;
alter table SAPPE6.RFCATTRIB rename to RFCATTRIB_old;
alter table SAPPE6.RFCDES rename to RFCDES_old;
alter table SAPPE6.RFCDESSECU rename to RFCDESSECU_old;
alter table SAPPE6.RFCDOC rename to RFCDOC_old;
alter table SAPPE6.RFCTRUST rename to RFCTRUST_old;
alter table SAPPE6.RFCSYSACL rename to RFCSYSACL_old;
alter table SAPPE6.IACORDES rename to IACORDES_old;
alter table SAPPE6.TSPSV rename to TSPSV_old;
alter table SAPPE6.TSPSI rename to TSPSI_old;
alter table SAPPE6.TSP03 rename to TSP03_old;
alter table SAPPE6.TSP03A rename to TSP03A_old;
alter table SAPPE6.TSP03C rename to TSP03C_old;
alter table SAPPE6.TSP03D rename to TSP03D_old;
alter table SAPPE6.TSP03L rename to TSP03L_old;
alter table SAPPE6.TSP03T rename to TSP03T_old;
alter table SAPPE6.TBD11 rename to TBD11_old;
alter table SAPPE6.TWPURLSVR rename to TWPURLSVR_old;
alter table SAPPE6.ROIDOCPRMS rename to ROIDOCPRMS_old;
alter table SAPPE6.V_TBDLS rename to V_TBDLS_old;
alter table SAPPE6.SXNODES rename to SXNODES_old;
alter table SAPPE6.SXROUTE rename to SXROUTE_old;
alter table SAPPE6.SXSERV rename to SXSERV_old;
alter table SAPPE6.SXADMINTAB rename to SXADMINTAB_old;
alter table SAPPE6.SXDOMAINS rename to SXDOMAINS_old;
alter table SAPPE6.SOPR rename to SOPR_old;
alter table SAPPE6.SXADDRTYPE rename to SXADDRTYPE_old;
alter table SAPPE6.SXCONVERT rename to SXCONVERT_old;
alter table SAPPE6.SXCONVERT2 rename to SXCONVERT2_old;
alter table SAPPE6.SXCOS rename to SXCOS_old;
alter table SAPPE6.SXCOS_T rename to SXCOS_T_old;
alter table SAPPE6.SXDEVTYPE rename to SXDEVTYPE_old;
alter table SAPPE6.SXFORMATG rename to SXFORMATG_old;
alter table SAPPE6.SXJOBS rename to SXJOBS_old;
alter table SAPPE6.SXRETRY rename to SXRETRY_old;
alter table SAPPE6.SXRFC rename to SXRFC_old;
alter table SAPPE6.SXTELMOIN rename to SXTELMOIN_old;
alter table SAPPE6.SXTELMOOUT rename to SXTELMOOUT_old;
alter table SAPPE6.T160PR rename to T160PR_old;
alter table SAPPE6.TWPSSO2ACL rename to TWPSSO2ACL_old;
alter table SAPPE6.SSF_PSE_H rename to SSF_PSE_H_old;
alter table SAPPE6.SSF_PSE_D rename to SSF_PSE_D_old;
alter table SAPPE6.SSFARGS rename to SSFARGS_old;
alter table SAPPE6.SXMSCONFVL rename to SXMSCONFVL_old;
alter table SAPPE6.CREP_HTTP rename to CREP_HTTP_old;
alter table SAPPE6.HTTPURLLOC rename to HTTPURLLOC_old;
alter table SAPPE6.RSADMINA rename to RSADMINA_old;
alter table SAPPE6.RSDDTREXADMIN rename to RSDDTREXADMIN_old;
alter table SAPPE6.RSPOR_T_PORTAL rename to RSPOR_T_PORTAL_old;

than import the tables

imp " '/ as sysdba' " file=ae6_170410.dmp fromuser=sappe6 touser=sappe6
tables=RSECTAB,RSECACTB,RFCATTRIB,RFCDES,RFCDESSECU,RFCDOC,RFCT
RUST,RFCSYSACL,IACORDES,TSPSV,TSPSI,TSP03,TSP03A,TSP03C,TSP03D,TSP
03L,TSP03T,TBD11,TWPURLSVR,ROIDOCPRMS,V_TBDLS,SXNODES,SXROUTE
,SXSERV,SXADMINTAB,SXDOMAINS,SOPR,SXADDRTYPE,SXCONVERT,SXCO
NVERT2,SXCOS,SXCOS_T,SXDEVTYPE,SXFORMATG,SXJOBS,SXRETRY,SXRF
C,SXTELMOIN,SXTELMOOUT,T160PR,TWPSSO2ACL,SSF_PSE_H,SSF_PSE_D,S
SFARGS,SXMSCONFVL,CREP_HTTP,HTTPURLLOC,RSADMINA,RSDDTREXAD
MIN,RSPOR_T_PORTAL buffer=1024000 grants=N indexes=N
(oraae6@am2hc219-PE6 AE6 SANDBOX-) /oracle/AE6/sapreorg/ae6_apr20_refresh >
imp " '/ as sysdba' " file=ae6_170410.dmp fromuser=sappe6 touser=sappe6
tables=RSECTAB,RSECACTB,RFCATTRIB,RFCDES,RFCDESSECU,RFCDOC,RFCT
RUST,RFCSYSACL,IACORDES,TSPSV,TSPSI,TSP03,TSP03A,TSP03C,TSP03D,TSP
03L,TSP03T,TBD11,TWPURLSVR,ROIDOCPRMS,V_TBDLS,SXNODES,SXROUTE
,SXSERV,SXADMINTAB,SXDOMAINS,SOPR,SXADDRTYPE,SXCONVERT,SXCO
NVERT2,SXCOS,SXCOS_T,SXDEVTYPE,SXFORMATG,SXJOBS,SXRETRY,SXRF
C,SXTELMOIN,SXTELMOOUT,T160PR,TWPSSO2ACL,SSF_PSE_H,SSF_PSE_D,S
SFARGS,SXMSCONFVL,CREP_HTTP,HTTPURLLOC,RSADMINA,RSDDTREXAD
MIN,RSPOR_T_PORTAL buffer=1024000 grants=N indexes=N

Import: Release 10.2.0.4.0 - Production on Sun Apr 18 05:59:15 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via direct path

import done in WE8DEC character set and UTF8 NCHAR character set
. importing SAPPE6's objects into SAPPE6
. . importing table "RSECTAB" 0 rows imported
. . importing table "RSECACTB" 0 rows imported
. . importing table "RFCATTRIB" 62 rows imported
. . importing table "RFCDES" 81 rows imported
. . importing table "RFCDESSECU" 1 rows imported
. . importing table "RFCTRUST" 1 rows imported
. . importing table "RFCSYSACL" 1 rows imported
. . importing table "IACORDES" 4 rows imported
. . importing table "TSPSV" 5 rows imported
. . importing table "TSP03" 8 rows imported
. . importing table "TSP03A" 2 rows imported
. . importing table "TSP03C" 8 rows imported
. . importing table "TSP03D" 8 rows imported
. . importing table "TSP03L" 8 rows imported
. . importing table "TSP03T" 0 rows imported
. . importing table "TBD11" 29 rows imported
. . importing table "TWPURLSVR" 1 rows imported
. . importing table "ROIDOCPRMS" 5 rows imported
. . importing table "SXNODES" 2 rows imported
. . importing table "SXROUTE" 14 rows imported
. . importing table "SXSERV" 2 rows imported
. . importing table "SXADMINTAB" 1 rows imported
. . importing table "SXDOMAINS" 0 rows imported
. . importing table "SOPR" 2 rows imported
. . importing table "SXADDRTYPE" 30 rows imported
. . importing table "SXCONVERT" 10 rows imported
. . importing table "SXCONVERT2" 30 rows imported
. . importing table "SXCOS" 0 rows imported
. . importing table "SXCOS_T" 0 rows imported
. . importing table "SXDEVTYPE" 8 rows imported
. . importing table "SXFORMATG" 0 rows imported
. . importing table "SXJOBS" 1 rows imported
. . importing table "SXRETRY" 0 rows imported
. . importing table "SXRFC" 0 rows imported
. . importing table "SXTELMOIN" 0 rows imported
. . importing table "SXTELMOOUT" 0 rows imported
. . importing table "TWPSSO2ACL" 2 rows imported
. . importing table "SSF_PSE_H" 3 rows imported
. . importing table "SSF_PSE_D" 20 rows imported
. . importing table "SSFARGS" 0 rows imported
. . importing table "CREP_HTTP" 1 rows imported
. . importing table "HTTPURLLOC" 0 rows imported
IMP-00033: Warning: Table "RFCDOC" not found in export file
IMP-00033: Warning: Table "TSPSI" not found in export file
IMP-00033: Warning: Table "V_TBDLS" not found in export file
IMP-00033: Warning: Table "T160PR" not found in export file
IMP-00033: Warning: Table "SXMSCONFVL" not found in export file
IMP-00033: Warning: Table "RSADMINA" not found in export file
IMP-00033: Warning: Table "RSDDTREXADMIN" not found in export file
IMP-00033: Warning: Table "RSPOR_T_PORTAL" not found in export file
Import terminated successfully with warnings.

Goto strust and distribute the things

Import Java
4.49

am2hc219:oraae6 16> ps -ef | grep jl

oraae6 2580630 1400874 0 15:55:26 pts/1 0:00 grep jl

SQL> select USERNAME,DEFAULT_TABLESPACE from dba_users;

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
OPS$AE6ADM SYSTEM
OPS$ORAAE6 SYSTEM
BUGREQ PSAPBUGSEYE
SAPPE6 PSAPPE6USR
CTXSYS PSAPBUGSEYE
PATROL PSAPPAT1D
SAPPE6DB PSAPPE6DB
SYS SYSTEM
SYSTEM SYSTEM
DBSNMP SYSTEM
OUTLN SYSTEM

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
TSMSYS SYSTEM
DIP SYSTEM
ORACLE_OCM SYSTEM

SQL> drop user SAPPE6DB cascade;

User dropped.

SQL> drop tablespace PSAPPE6DB including contents and datafiles;

Tablespace dropped.

Create tablespace :

1 - Tablespace name (tablespace) ......... [PSAPAE6DB]

2 - Tablespace contents (contents) ....... [data]
3 - Segment space management (space) ..... [auto]
4 - Database owner of tablespace (owner) . [SAPPE6]
5 ~ Table data class / tabart (class) .... []
6 - Data type in tablespace (data) ....... [both]
7 # Joined index/table tablespace (join) . []
8 ~ Uniform size in MB (uniform) ......... []

1 - Tablespace name (tablespace) ......... [PSAPAE6DB]

2 - Tablespace contents (contents) ....... [data]
3 - Segment space management (space) ..... [auto]
4 - Database owner of tablespace (owner) . [NONE]
5 # Table data class / tabart (class) .... []
6 - Data type in tablespace (data) ....... [both]
7 # Joined index/table tablespace (join) . []
8 ~ Uniform size in MB (uniform) ......... []

1 - Tablespace file name (file) .......... [/oracle/AE6/sapdata1/ae6db_1/ae6db.data1]

2 ~ Raw disk / link target (rawlink) ..... []
3 - File size in MB (size) ............... [5000]
4 - File autoextend mode (autoextend) .... [no]
5 # Maximum file size in MB (maxsize) .... []
6 # File increment size in MB (incrsize) . []
7 - SQL command (command) ................ [create tablespace PSAPAE6DB extent management local
autoallocate segment space management auto datafile '/oracle/AE6/sapdata1/ae6db_1/ae6db.data1' size
5000M autoextend off]
BR0280I BRSPACE time stamp: 2009-10-21 16.27.37
BR1016I SQL statement 'create tablespace PSAPAE6DB extent management local autoallocate segment
space management auto datafile '/oracle/AE6/sapdata1/ae6db_1/ae6db.data1' size 5000M autoextend off'
executed successfully
BR1060I Tablespace PSAPAE6DB created successfully with file:
/oracle/AE6/sapdata1/ae6db_1/ae6db.data1 5000M

BR0280I BRSPACE time stamp: 2009-10-21 16.27.37

BR0340I Switching to next online redo log file for database instance AE6 ...
BR0321I Switch to next online redo log file for database instance AE6 successful

SQL> create user SAPAE6DB identified externally default tablespace PSAPAE6DB temporary tablespace
PSAPTEMP;

User created.

SQL> select USERNAME,DEFAULT_TABLESPACE from dba_users;

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
SAPAE6DB PSAPAE6DB
OPS$AE6ADM SYSTEM
OPS$ORAAE6 SYSTEM
BUGREQ PSAPBUGSEYE
SAPPE6 PSAPPE6USR
CTXSYS PSAPBUGSEYE
PATROL PSAPPAT1D
SYS SYSTEM
SYSTEM SYSTEM
DBSNMP SYSTEM
OUTLN SYSTEM

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
TSMSYS SYSTEM
DIP SYSTEM
ORACLE_OCM SYSTEM

14 rows selected.

SQL> alter user SAPAE6DB identified by penguin7;

User altered.

SQL> grant select_catalog_role,connect,resource to SAPAE6DB;

Grant succeeded.

am2hc219:oraae6 16> imp sapae6db/penguin7 file=exportj2ee_2.dmp full=y indexes=y grants=y

log=importj2ee_3.log
Import: Release 10.2.0.4.0 - Production on Wed Oct 21 16:33:48 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via direct path

import done in WE8DEC character set and UTF8 NCHAR character set
. importing SAPAE6DB's objects into SAPAE6DB
. . importing table "BC_CMSRTS" 0 rows imported
. . importing table "BC_COMPVERS" 339 rows imported
. . importing table "BC_CPT_ACTION" 0 rows imported
. . importing table "BC_CPT_ALLOC_ID" 0 rows imported
. . importing table "BC_CPT_CORRELATOR" 0 rows imported
. . importing table "BC_CPT_CORR_DEF" 0 rows imported
. . importing table "BC_CPT_IMPORT_LOCK" 0 rows imported
. . importing table "BC_CPT_METRIC" 0 rows imported
. . importing table "BC_CPT_METRIC_DEF" 0 rows imported
. . importing table "BC_CPT_MODULE" 0 rows imported
. . importing table "BC_CPT_ORIGIN" 0 rows imported
. . importing table "BC_CPT_PROVIDER" 0 rows imported
. . importing table "BC_CPT_RECORD" 0 rows imported
. . importing table "BC_CPT_RECORD_CORR" 0 rows imported
. . importing table "BC_CPT_THREAD" 0 rows imported
. . importing table "BC_CVERS" 0 rows imported
. . importing table "BC_DDDBRTH" 129 rows imported
. . importing table "BC_DDDBRTX" 11759 rows imported
. . importing table "BC_DDDBTABLERT" 129 rows imported
. . importing table "BC_ETE_ACTIVITIES" 0 rows imported
. . importing table "BC_ETE_SYSACTIVITY" 0 rows imported
. . importing table "BC_ETE_SYSORIGIN" 0 rows imported
. . importing table "BC_ETE_SYSTEMS" 0 rows imported
. . importing table "BC_JARM_CHISTORY" 0 rows imported
. . importing table "BC_JARM_COMPONENT" 0 rows imported
. . importing table "BC_JARM_REQUEST" 0 rows imported
. . importing table "BC_JARM_RHISTORY" 0 rows imported
. . importing table "BC_JARM_UHISTORY" 0 rows imported
. . importing table "BC_JARM_USER" 0 rows imported
. . importing table "BC_JMSDMSGQ" 0 rows imported
. . importing table "BC_JMSQUEUE" 0 rows imported
. . importing table "BC_JMSTOPIC" 0 rows imported
. . importing table "BC_JMSTOPICSUB" 0 rows imported
. . importing table "BC_JMSTXLOG" 0 rows imported
. . importing table "BC_MON_AGREGATES" 0 rows imported
. . importing table "BC_MON_ID_ALLOC" 0 rows imported
. . importing table "BC_MON_MONITORS" 0 rows imported
. . importing table "BC_RPROF_PROFILE" 3 rows imported
. . importing table "BC_SCCOMPAT" 0 rows imported
. . importing table "BC_SCCOVERAGE" 0 rows imported
. . importing table "BC_SCREQUIRED" 0 rows imported
. . importing table "BC_SCVERSION" 0 rows imported
. . importing table "BC_SESSIONFAILOVER" 0 rows imported
. . importing table "BC_SLD_ASSINST" 0 rows imported
. . importing table "BC_SLD_ASSOC" 0 rows imported
. . importing table "BC_SLD_CHANGELOG" 0 rows imported
. . importing table "BC_SLD_CLASS" 0 rows imported
. . importing table "BC_SLD_DELTAEXPORT" 0 rows imported
. . importing table "BC_SLD_INST" 0 rows imported
. . importing table "BC_SLD_INSTANCES" 0 rows imported
. . importing table "BC_SLD_LONGVALUES" 0 rows imported
. . importing table "BC_SLD_NAMESP" 0 rows imported
. . importing table "BC_SLD_NAMESPACES" 0 rows imported
. . importing table "BC_SLD_PROPARRAYS" 0 rows imported
. . importing table "BC_SLD_PROPERTIES" 0 rows imported
. . importing table "BC_SLD_PROPERTYREF" 0 rows imported
. . importing table "BC_SLD_QUAL" 0 rows imported
. . importing table "BC_SLD_QUALIFIERS" 0 rows imported
. . importing table "BC_SLD_ROLE" 0 rows imported
. . importing table "BC_SLM_JNET" 0 rows imported
. . importing table "BC_SLM_JNET_DATA" 0 rows imported
. . importing table "BC_SLM_PLAN" 0 rows imported
. . importing table "BC_SLM_PLAN_CIM" 0 rows imported
. . importing table "BC_SLM_PLAN_DATA" 0 rows imported
. . importing table "BC_SLM_USER" 0 rows imported
. . importing table "BC_SYNCLOG" 124 rows imported
. . importing table "BC_UDDI_ACCOUNT" 0 rows imported
. . importing table "BC_UDDI_BE_DISCURL" 0 rows imported
. . importing table "BC_UDDI_BE_MAIN" 0 rows imported
. . importing table "BC_UDDI_BS_MAIN" 0 rows imported
. . importing table "BC_UDDI_BS_PROJ" 0 rows imported
. . importing table "BC_UDDI_BT_MAIN" 0 rows imported
. . importing table "BC_UDDI_BT_TMINST" 0 rows imported
. . importing table "BC_UDDI_CHGREC" 0 rows imported
. . importing table "BC_UDDI_CHGREC_ERR" 0 rows imported
. . importing table "BC_UDDI_ELEM_CB" 0 rows imported
. . importing table "BC_UDDI_ELEM_IB" 0 rows imported
. . importing table "BC_UDDI_ELEM_KEY" 0 rows imported
. . importing table "BC_UDDI_ELEM_NAME" 0 rows imported
. . importing table "BC_UDDI_PARAM" 82 rows imported
. . importing table "BC_UDDI_PUBA" 0 rows imported
. . importing table "BC_UDDI_SESSION" 0 rows imported
. . importing table "BC_UDDI_STAT" 0 rows imported
. . importing table "BC_UDDI_TAXONOMY" 0 rows imported
. . importing table "BC_UDDI_THREAD" 0 rows imported
. . importing table "BC_UDDI_TM_MAIN" 0 rows imported
. . importing table "BC_WA_GROUP" 0 rows imported
. . importing table "BC_WA_SYSTEM" 0 rows imported
. . importing table "BC_WA_SYS_TO_GROUP" 0 rows imported
. . importing table "BC_WA_USER" 0 rows imported
. . importing table "BC_XMLA_ASESSIONS" 0 rows imported
. . importing table "BC_XMLA_ASETS" 6 rows imported
. . importing table "BC_XMLA_COL" 1 rows imported
. . importing table "BC_XMLA_COL_INDEX" 0 rows imported
. . importing table "BC_XMLA_COL_STORE" 0 rows imported
. . importing table "BC_XMLA_CONFIG" 0 rows imported
. . importing table "BC_XMLA_INDEX_COLS" 0 rows imported
. . importing table "BC_XMLA_INDEX_DICT" 0 rows imported
. . importing table "BC_XMLA_LOCKING" 0 rows imported
. . importing table "BC_XMLA_MAXIDS" 5 rows imported
. . importing table "BC_XMLA_NAMESPACES" 0 rows imported
. . importing table "BC_XMLA_POLLING" 0 rows imported
. . importing table "BC_XMLA_PROPS" 0 rows imported
. . importing table "BC_XMLA_RES" 0 rows imported
. . importing table "BC_XMLA_RESTYPES" 4 rows imported
. . importing table "GLAS_MEASUREMENT" 0 rows imported
. . importing table "J2EE_CONFIG" 7803 rows imported
. . importing table "J2EE_CONFIGENTRY" 16618 rows imported
. . importing table "J2EE_KEYSEQUENCE" 1 rows imported
. . importing table "SP_PLUG_IN_SAVES" 0 rows imported
. . importing table "SP_RESULTS" 0 rows imported
. . importing table "SP_STORAGE" 2 rows imported
. . importing table "TC_WDRR_FGUID" 0 rows imported
. . importing table "TC_WDRR_LAYERS" 2 rows imported
. . importing table "TC_WDRR_MRO_FILES" 189 rows imported
. . importing table "TC_WDRR_MRO_LANG" 0 rows imported
. . importing table "TC_WDRR_MRO_LUT" 199 rows imported
. . importing table "TC_WDRR_TYPES" 3 rows imported
. . importing table "TC_WDRR_VARIANTS" 0 rows imported
. . importing table "UME_ACL_ACL" 0 rows imported
. . importing table "UME_ACL_ACLENTRY" 0 rows imported
. . importing table "UME_ACL_MANAGER" 0 rows imported
. . importing table "UME_ACL_OWNER" 0 rows imported
. . importing table "UME_ACL_PERM" 0 rows imported
. . importing table "UME_ACL_PERM_MEM" 0 rows imported
. . importing table "UME_ACL_SUP_PERM" 0 rows imported
. . importing table "UME_BLOBS" 0 rows imported
. . importing table "UME_STRINGS" 264 rows imported
. . importing table "UME_USERNUMBER" 0 rows imported
. . importing table "UME_USERSYNC" 0 rows imported
. . importing table "UME_USERSYNCLOCK" 0 rows imported
. . importing table "UME_USERSYNCTEMP" 0 rows imported
Import terminated successfully without warnings.

Try to bring up Java

SAP System Name : AE6

SAP System : 06
MS Host : sapdae6
MS Port : 3607
Process Count : 3
PID of JControl : 2719940
State of JControl : Some processes running
State inside MS : Some processes running
Run Mode : Normal Mode
Admin URL :
------------------------------------------------------------

|Idx|Name |PID |State |Error|Restart|

|---|-------------------|--------|---------------------|-----|-------|
| 0|dispatcher | 2936896|Running | 0|yes |
| 1|server0 | 0|Stopped | 1|yes |
| 2|SDM | 2998340|Running | 0|yes |
------------------------------------------------------------
Note: If java not running just check the SAPJSF password . If it is locked give the correct
password of AE6(ie source password): t3l3f00n
4.50

Import bugs eye

1) down the java

SQL> select USERNAME,DEFAULT_TABLESPACE from dba_users;

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
SAPAE6DB PSAPAE6DB
OPS$AE6ADM SYSTEM
OPS$ORAAE6 SYSTEM
BUGREQ PSAPBUGSEYE
SAPPE6 PSAPPE6USR
CTXSYS PSAPBUGSEYE
PATROL PSAPPAT1D
SYS SYSTEM
SYSTEM SYSTEM
DBSNMP SYSTEM
OUTLN SYSTEM

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
TSMSYS SYSTEM
DIP SYSTEM
ORACLE_OCM SYSTEM

14 rows selected.

SQL> drop user BUGREQ cascade;

User dropped.

SQL> create user bugreq identified by fdQt4Hrt default tablespace PSAPBUGSEYE temporary tablespace
psaptemp;

User created.

SQL> grant create session to bugreq;

Grant succeeded.

SQL> grant create table to bugreq;

Grant succeeded.

SQL> grant create sequence to bugreq;

Grant succeeded.

SQL> grant unlimited tablespace to bugreq;

Grant succeeded.

SQL> grant create view to bugreq;

Grant succeeded.

SQL> grant create any cluster to bugreq;

Grant succeeded.

SQL> grant create any context to bugreq;

Grant succeeded.

SQL> grant create any index to bugreq;

Grant succeeded.

SQL> grant create any indextype to bugreq;

Grant succeeded.

SQL> grant create any procedure to bugreq;

Grant succeeded.

SQL> grant create synonym to bugreq;

Grant succeeded.

SQL> grant create trigger to bugreq;

Grant succeeded.

SQL> grant ctxapp to bugreq;

Grant succeeded.

am2hc219:oraae6 9> imp " '/ as sysdba' " file=exportbug.dmp fromuser=bugreq touser=bugreq indexes=y
grants=y commit=y log=importbug.log

Import: Release 10.2.0.4.0 - Production on Wed Oct 21 18:19:24 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via direct path

import done in WE8DEC character set and UTF8 NCHAR character set
. importing BUGREQ's objects into BUGREQ
. . importing table "ACTION" 3 rows imported
. . importing table "ACTION_LOG" 0 rows imported
. . importing table "APPLICATION" 0 rows imported
. . importing table "APPROVAL_COMMENT" 0 rows imported
. . importing table "APPROVAL_CONFIG" 0 rows imported
. . importing table "APPROVAL_CONFIG_NEXT" 0 rows imported
. . importing table "ATTRIBUTEMAP" 0 rows imported
. . importing table "ATTRIBUTEMAPRULE" 0 rows imported
. . importing table "ATTRIBUTE_SECURITY" 0 rows imported
. . importing table "BUGSEYE_APPROVAL" 0 rows imported
. . importing table "BUGSEYE_BG_JOBS" 0 rows imported
. . importing table "BUGSEYE_CONFIG" 1446 rows imported
. . importing table "BUGSEYE_FLAGS" 1 rows imported
. . importing table "BUGSEYE_PROPERTIES" 2634 rows imported
. . importing table "BUGSEYE_TAB" 64 rows imported
. . importing table "C100736" 27 rows imported
. . importing table "C100756" 245 rows imported
. . importing table "C100770" 9 rows imported
. . importing table "C100800" 73 rows imported
. . importing table "C100831" 142 rows imported
. . importing table "C100864" 17 rows imported
. . importing table "C100874" 7 rows imported
. . importing table "C101646" 456 rows imported
. . importing table "C101647" 0 rows imported
. . importing table "C101648" 132 rows imported
. . importing table "C101649" 1 rows imported
. . importing table "C101856" 9 rows imported
. . importing table "C101857" 3 rows imported
. . importing table "CATALOG_INFO" 0 rows imported
. . importing table "CATEGORY" 1215 rows imported
. . importing table "CATEGORYMAP" 0 rows imported
. . importing table "CATEGORY_DEFAULT" 0 rows imported
. . importing table "CATEGORY_ITEM" 17490 rows imported
. . importing table "CAT_DATA_SOURCE" 0 rows imported
. . importing table "CLEANSER_RULES" 0 rows imported
. . importing table "CONTENTATTRIBUTE" 0 rows imported
. . importing table "CONTENTGROUP" 0 rows imported
. . importing table "CONTENTMAP" 0 rows imported
. . importing table "CONTEXT_POLICY" 1 rows imported
. . importing table "CONTEXT_POLICY_DESCRIPTOR" 0 rows imported
. . importing table "CONTRACT" 0 rows imported
. . importing table "CONTRACT_CURRENCY" 0 rows imported
. . importing table "CONTRACT_HISTORY" 0 rows imported
. . importing table "CONTRACT_LOCAL_ATTRIBUTE_MAP" 0 rows imported
. . importing table "CONTRACT_PRICE" 0 rows imported
. . importing table "CONTRACT_PRICE_HISTORY" 0 rows imported
. . importing table "DESCRIPTOR" 208 rows imported
. . importing table "ECLASS" 0 rows imported
. . importing table "EXT_QUERY" 0 rows imported
. . importing table "FAVORITES_ITEM" 0 rows imported
. . importing table "FAVORITE_LISTS" 0 rows imported
. . importing table "GLOSSARY" 0 rows imported
. . importing table "GRANTED_VIEW" 0 rows imported
. . importing table "GROUPING_PRICE_MODEL" 0 rows imported
. . importing table "GROUPS" 9 rows imported
. . importing table "GROUPS_SEARCH" 0 rows imported
. . importing table "INELIGIBLE_PASSWORDS" 0 rows imported
. . importing table "ITEM" 17490 rows imported
. . importing table "ITEMCATEGORYMAP" 0 rows imported
. . importing table "ITEMHISTORY" 0 rows imported
. . importing table "ITEM_CONSTRAINT" 0 rows imported
. . importing table "ITEM_SITE" 0 rows imported
. . importing table "ITEM_TL" 17490 rows imported
. . importing table "ITEM_VIEW_TABLE" 0 rows imported
. . importing table "JMS_CONFIG" 0 rows imported
. . importing table "JOB_LOG" 1132 rows imported
. . importing table "LANGUAGE" 42 rows imported
. . importing table "LOAD_ITEM_MATCH" 0 rows imported
. . importing table "LOG" 43796 rows imported
. . importing table "LOGIN_LOG" 5955 rows imported
. . importing table "MATRIX_ATTRIB" 0 rows imported
. . importing table "MESSAGE" 0 rows imported
. . importing table "METADATA" 0 rows imported
. . importing table "MORPHOLOGY" 0 rows imported
. . importing table "NAVIGATION" 953 rows imported
. . importing table "OBJECT_STORE" 0 rows imported
. . importing table "OWNER" 1 rows imported
. . importing table "PASSWORD_HISTORY" 406 rows imported
. . importing table "PRICE" 7 rows imported
. . importing table "PRICEMODEL" 0 rows imported
. . importing table "QUEUE" 0 rows imported
. . importing table "QUEUE_MESSAGE" 0 rows imported
. . importing table "RIGHTS_SET" 157 rows imported
. . importing table "RIGHTS_SET_CONTRACT_INTRSCT" 0 rows imported
. . importing table "RIGHTS_SET_SRCH_CNFIG_INTRSCT" 1726 rows imported
. . importing table "RIGHTS_SET_VIEW_INTERSECT" 0 rows imported
. . importing table "RULE" 1 rows imported
. . importing table "RULE_TABLE_INFO" 0 rows imported
. . importing table "RULE_TYPES" 41 rows imported
. . importing table "RUSUPDATEFILE" 0 rows imported
. . importing table "SCHEDULER" 14 rows imported
. . importing table "SEARCH_CONFIG" 110 rows imported
. . importing table "SEARCH_CONFIG_POLICY" 1 rows imported
. . importing table "SEARCH_CONFIG_VIEW" 110 rows imported
. . importing table "SERIALIZED_JOB" 0 rows imported
. . importing table "SHIPPING_MODEL" 0 rows imported
. . importing table "SHOPPING_CART" 6 rows imported
. . importing table "SINGLEPRICEMODEL" 0 rows imported
. . importing table "SITE" 0 rows imported
. . importing table "SOURCE" 0 rows imported
. . importing table "SOURCECONTENTGROUP" 0 rows imported
. . importing table "STOP_LIST" 0 rows imported
. . importing table "STOP_LIST_ADMIN" 2 rows imported
. . importing table "STOP_LIST_POLICY" 0 rows imported
. . importing table "STOP_LIST_WORD" 34 rows imported
. . importing table "SUPPLIERSOURCE" 0 rows imported
. . importing table "SUPPLIER_LIST" 1 rows imported
. . importing table "SUPPLIER_TOC" 1 rows imported
. . importing table "TABLE_INFO" 3 rows imported
. . importing table "TAB_CONTROL" 3 rows imported
. . importing table "TAX_MODEL" 0 rows imported
. . importing table "TITLE_REGISTRY" 1 rows imported
. . importing table "UNIT" 0 rows imported
. . importing table "UNITGROUP_TL" 38 rows imported
. . importing table "UNITS" 310 rows imported
. . importing table "UNITS_CODES" 627 rows imported
. . importing table "UNITS_TL" 310 rows imported
. . importing table "UNSPSC" 0 rows imported
. . importing table "USERS" 135 rows imported
. . importing table "VERSION_INFO" 10 rows imported
. . importing table "VIEW_COMPOSITE" 0 rows imported
. . importing table "VIEW_CONSTRAINT" 119 rows imported
. . importing table "VIEW_REGISTRY" 111 rows imported
. . importing table "VIEW_SEARCHABLE_DESCRIPTOR" 0 rows imported
. importing BUGREQ's objects into BUGREQ
Import terminated successfully without warnings.

Check whether there is same password for user bugreq as below:

Su - <sid>adm
cdbug
cd WEB-INF (make sure the path is
/usr/sap/<SID>/DVEBMGS06/j2ee/cluster/server0/apps/sap.com/requisite/servlet_jsp/requisite/root/
WEB-INF/ )
more web.xml

Restart the SAP system and ipc

Check java is up

Bugseye also should be up

Import Customer Specific table
Rename the cutomer specific table
alter table sappe6.BBP_CAT_VALUES rename to BBP_CAT_VALUES_old;
alter table sappe6.SNCSYSACL rename to SNCSYSACL_old;
alter table sappe6.USRACLEXT rename to USRACLEXT_old;
alter table sappe6.SMEN_BUFFC rename to SMEN_BUFFC_old;
alter table sappe6.SMEN_BUFFI rename to SMEN_BUFFI_old;

import

imp " '/ as sysdba' " file=ae6_170410_bbpcatval.dmp fromuser=sappe6 touser=sappe6

log=ae6_170410_bbpcatval_imp.log
imp " '/ as sysdba' " file=ae6_170410_sncsysacl.dmp fromuser=sappe6 touser=sappe6
log=ae6_170410_sncsysacl_imp.log
imp " '/ as sysdba' " file=ae6_170410_usraclext.dmp fromuser=sappe6 touser=sappe6
log=ae6_170410_usraclext_imp.log
imp " '/ as sysdba' " file=ae6_170410_smen_buffc.dmp fromuser=sappe6 touser=sappe6
log=ae6_170410_smen_buffc_imp.log
imp " '/ as sysdba' " file=ae6_170410_smen_buffi.dmp fromuser=sappe6 touser=sappe6
log=ae6_170410_smen_buffi_imp.log

change the entries in the table E070L

update sappe6.e070l set trkorr='AE6K900003' where lastnum='TRKORR';

COMPLETE THE REQUIRED STEPS FOR EBPR0 *E SYSTEMS FOR SESSION 6.2 AS PER
RUNBOOK

1.1 6.7 Post-processing EBPro systems

FOLLOW THE RUN BOOK

Publish web services TAKE its support