Missing Tables and Indexes While Creating Index in DB02

Question:
We are getting error while creating  primary index in db02 for the
table EDIDC.

Error in unknown objects in abap dictionary.
ST04 -> Diagnostics -> Missing Tables and Indexes->unknown objects in
abap dictionary.

Answer:
Missing tables and indexes meaning there is inconsistency between
database and data dictionary which causes number of missing indexes,
please check whether the preceding step like reorganisation or upgrade
was completed correctly.

541538 FAQ: Reorganization

Also, please check these indexes to see if they need to be created on
the database level. In some cases the index does not need to be created
on the Oracle database but it is delivered in the ABAP dictionary as
it exists on anther database e.g. Informix. Please go to
ST04 -> Diagnostics -> Missing Tables and Indexes
     -> Optional indexes -> indexes not created

Please also take a look at attached notes below for relevant information
   211492    Inconsistency between ABAP dictionary <-> database
   33814     Warnings of inconsistencies between database & R/3
   117219    DB02 reports missing DD/DB objects: procedure
   582427    Error due to inconsistent Oracle DDICMS: missing tables and
             indexes db02

To resolve the problem, you can drop the index from database
level and recreate via SE14 as it is already exist in ABAP dictionary
Please apply the drop and recreated at a system non-busy time.

ORA-01536:space quota exceeded for tablespace PSAPEWP

Question:
We get the following error during the dataload and the import of
transports in system EWP:
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                BY  L
Database error 1536 requires database administrator to intervene
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                BY  4
Database error 1536 at INS access to table RSBATCHCTR
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                BY  0 >
ORA-01536: space quota exceeded for tablespace 'PSAPEWP'
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                AB  0
Run-time error "DBIF_RSQL_SQL_ERROR" occurred
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                AB  1 >
Short dump "101230 000204 lux01317_EWP_00 ALEREMOTE " created
00:02:04 lux01317_EWP_00 BTC  016 100 ALEREMOTE                D0  1
Transaction Canceled 00 671 ( DBIF_RSQL_SQL_ERROR )

We can't find any change of database users in the alertlog. The error
occured in two systems.

We checked note 644104 - ORA-01536 / ORA-01950 but all users are
configured correctly with the UNLIMITED_TABLESPACE privilege.

Please assist.

Answer:
Looking at your description, you had granted unlimited tablespace
privilage to user according to note 644104 and still having error
ORA-01536.

This issue probably just DBA role to Oracle user was assigned to SAP
system and then again redrawn.

Ensure SAPDBA and SAPCONN role is assigned, could you please check on
note #834917 Oracle Database 10g: New database role SAPCONN

Here are some articles from Metalink which describe this error:
Revoking DBA or RESOURCE Privilege Revokes UNLIMITED TABLESPACE from the
 User [ID 1084014.6]
All About Security: User, Privilege, Role, SYSDBA, O/S Authentication,
Audit, Encryption, OLS, Database Vault, Audit Vault [ID 207959.1]
ORA-01536, when enough space is available [ID 270582.1]

To access to Oracle Metalink, refer to note #758563 Oracle Metalink
access for SAP customers

Access to Oracle Metalink

Question:
We are SAP customer and couldn't access to the Metalink account.
Please help. Thank you.

Answer:
As SAP customer, you can always access to Metalink by refering to note
#758563 Oracle Metalink access for SAP customers for login details.

Hanged Processes and ORA-00020, ORA-12518 Error

Question:
We had a problem with our UPS in the backup data center,
whereby 3 of 6 application servers have been without electricity. When we
restarted the Computer is a correctly started (except 3 dialog processes). the
other two report:
    ORA-12518: TNS: listener could not hand off client
When I try to log in SQLPLUS I get the following error:
    ORA-00020: maximum number of processes (string) exceeded
I think the ora-12518 is a result of the error ora-00020th I suspected
is stuck processes.
How can we identify hanged processes?


Answer:
This ORA-00020 problems are caused by insufficient size of number of
session/proces ses on Oracle level. A new connection aborts with error
ORA-00020: maximum number of processes (%s) exceeded.
Ultimately this is the reason why tp does not work.


Please revise the parameters sessions/processes according to the formula
in SAP note #830576 and restart then the database with higher values.
This issue should be then solved and new connections such as from tp
made possible.


Please refer the following notes for more details.
#398927 ORA errors because dimensions of parameters are too small
#34432  ORA-00020: maximum number of processes exceeded


As for error ORA-12518, here are some article found in Oracle Metalink:
371983.1 - 10gR2 Dedicated Connections Intermittently Fail with
           TNS-12518
340089.1 - New Connections to the Database lead to ORA-12518 or
TNS-12518
#758563 Oracle Metalink access for SAP customers

Availablity of Oracle Database 11.2.0.2 Patch

Question:
We want to migrate our 10.2.0.4 Oracle database to 11.2. However, patch available is 11.2.0.2 (112021).
We read note 1522330 and linked but unsure how it works.
We suppose that is missing something on the download area (11.2.0.2 software)
We can install 11.2.0.1 software as the DVD is available but can't upgrade to 11.2.0.2 due to unavailable of patch.
We would like to find out when the patch will be available 11.2.0.2 for our platform?

Answer:
Regarding upgrading Oracle Database from 10.2 to 11, please follow the
database upgrade guide to 11g which can be found as per below path:
http://service.sap.com/instguides -> Database Upgrades -> Oracle ->
Upgrade to Oracle Database 11g Release 2 (11.2): UNIX
or direct link,
https://websmp210.sap-ag.
de/~form/sapnet?_SCENARIO=01100035870000000202&_SHORTKEY=011000358700007
22155

Here are additional information regarding to upgrading to Oracle 11g:
#1398634 Oracle database 11g: Integration in SAP environment
#1431797 Oracle 11.2.0: Troubleshooting the Database Upgrade

As per Note 1434131,
Note:
A direct installation with Oracle 11.2 is not currently possible.
According to the current SAP plan, this will be made available at the
start of Q4/2010. Until then, you must perform the installation with
Oracle 10.2 first, and upgrade the database later.

Also please see as per note 1398634,
Note: Oracle has not yet made a decision regarding 11.2 support on the
following operating system platforms:
- Linux on Power
- Linux IA 64

So if your database is on 10gR2 you can upgrade it to 11g
in case it is compatible as per compatibility matrix.
In case you want to see the compatibility matrix, please refer to
service marketplace > product availability matrix.

Note 1431800 - Oracle 11.2.0: Central Technical Note
Note 1434131 - Release of Oracle 11.2 versions for older SAP versions

Unable to get the current group during Oracle Upgrade

Question:
I have a HPUX11.23 system with a running instance of Oracle 10.2.0.4 and to upgrade to 11.2.0.2.
During installation phase we get "Loading setup driver" error and the fault code, "An internal errror occurred within cluster verification framework - Unable to get current group".

How do we solve this?

Solution:I have read with interest the note 1431796. The indicated there Patch is only for HPUX11.31. Is there a patch for analog HPUX11.23?

Regarding installation and integration of Oracle 11g in SAP enviroment, please carefully read the followin notes:
1398634 - Oracle database 11g: Integration in SAP environment
1434131 - Release of Oracle 11.2 versions for older SAP versions
As you can see for HP-UX you should have HP-UX IA 64 (Version 11.31) to use Oracle 11g.

I have also found a workaround mention in Oracle forum, please pay a visit to
http://forums.oracle.com/forums/thread.jspa?threadID=1035680&tstart=45

No host can be created on SM55

Question:

Couldn't create any host via SM55. However, this only happen in SAP Solution Manager, in other SAP systems, it is working fine.

Error says "No entries in the table THOST available".

Solution:

Error in SM55, could caused by an empty table.

Please create some dummy entries in the database table THOST via transaction SE16, then SM55 should run as usual.

For additional information, here are some SAP OSS Notes to refer to:
#10743 - Host name longer than 8 characters
#25941 - System does not find host name