Answer Posted / ketinenikrishna

An example when you are required to rebuild an index is if
in the brconnect stats log it is specified that an index is
in an unusable, missing, or bad index. There are three ways
that can help you succeed with this task. If we are talking
about a single oracle database that is not working with
other systems, than, of course, the only way is to rebuild
the index at sql level. But we are not talking only about
databases so far but about SAP systems that work with Oracle
databases as well right?
You can rebuild an unusable, missing, or bad index by
choosing any solution from the following 3:
1. Rebuild the index from SAP.
In order to perform this task in SAP, you need to run a
report of course. You need to go to SAP transaction SE38, or
if you prefer, SA38. In this transaction you will execute
the report RSANAORA. Once you had this report executed, on
the screen that follows you only need to put your index name
in the field and choose radio button Index rebuild. The last
step is to choose execute button again.
2. Rebuild the index at sql level.
In order to rebuild an index with this method you must log
on to operation system level with the ora<sid> user. Once
you are logged on connect with “sqlplus / as sysdba” string.
Now, for rebuilding the index you want you will use this
command alter index <name of the index> rebuild online.
3. Rebuild the index using Brtools.
That is of course as you already know a solution that you
can use being logged on as orasid at OS level. After you
choose brtools. Of course if you want you can type directly
the specific command of brspace for rebuilding the index,
but here I will show you how to do it and also understand
the steps. First you will choose from the brtools menu
option 3: Segment Management. In the next menu on option 3
you have Rebuild index. In the next menu under option 7 you
will be asked to provide the name of the index you want to
rebuild. After you did that, all you have to do is proceed
with option ‘c’ (continue) in order to have the index rebuild.
Log into infrastructure instance & login as sysdba;
How to chk oracle up or not in sql?
You can follow any one this method
1. Log into infrastructure instance & login as sysdba;
>sqlplus ‘/as sysdba’
SQL> select status from v$instance;
Status should be open.
2. Log into infrastructure instance & issue the following
command
ps -ef |grep ora
ps -ef |grep ora_
ps -ef |grep pmon
R3trans -d ; give RC – 0000 means active other than 0000 is
error
If DB instance is running, then the above command returns
the pmon process running
3. In Brtools
1. Instance Management,
6 – Show instance status,
3-Database instance,
Give the Database Name and press continue….give the status

Where will u find transport error logs?

2087

---

What are the daily activates?

1051

---

what can we do if shadow instance is down and getting up in prepare phase of upgrade

2571

---

What is the need of having Development system?

1773

---

What is the difference between – support package, kernel and sap note?

1619

---

Explain segment?

1135

---

What are the different options available for scheduling a background job? What start conditions type can be used?

1066

---

I am installing a sap j2ee engine at crm. When it reaches phase 22 it halts for more than 10 minutes and gives up starting the system. What should I do?

1107

---

What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?

1928

---

What is transport layer and domain controller? In which system you have create domain control?

1873

---

Hi ,All What is the multi-threading and max connections for rfc. Actually i am facing problem while send large amount of idocs to external system using middle ware tibco r3 adapter. And how to enable these in SAP ?

2368

---

What are the different login and password parameters that can be applied in sap system?

1162

---

Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri

1818

---

What is process for applying patches?

1135

---

Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com

2286

---