Hey Basis folks, few most frequently faced issue from the Basis side which are kind of trivial and we encounter most of the time hopefully will help you too.
Activate SAP * user :
delete from <schema>.usr02 where bname='sap*' and mandt='000'
As of Release 7.0 (NetWeaver 7.0/2004s):
The default value of the login/no_automatic_user_sapstar profile parameter has been changed (previously 0, now 1). To activate the emergency user, you must set the login/no_automatic_user_sapstar profile parameter to the value 0.(Checkout SAP Notes for more on this)
SIDadm unable to sqlplus (TNS lost connect)
Try "relink all" $ORACLE_HOME/lib/relink all
Changing SAP Schema user password
brconnect -c -u / -f chpass -o <sap_schema_user> -p <password>
Speed up BDLS
1.Exclude tables that doesn't not contain LOGSYS info example COEP,GLPCA and etc
2. Create bitmap index for the large tables for the few columns and delete it later after BDLS is done, you'll see a significant improvement
