OPS$ Schema user creation

Home


400241 - Problems with ops$ or sapr3 connect to Oracle
-------------------------------------------------------

First check, it should be like
SQL> select owner from dba_tables where table_name='SAPUSER';

OWNER
------------------------------
OPS$<SID>ADM

if not showing need to create like below
SQL> SQL> CREATE TABLE "OPS$<SID>ADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
Table created.
SQL> INSERT INTO "OPS$<SID>ADM".SAPUSER VALUES ('SAPECC', 'XXXXXXXX');
1 row created.

SQL> grant dba, connect, resource to SAPECC;
Grant succeeded.

SQL> SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'SAPECC';
GRANTED_ROLE
------------------------------
SAPCONN
CONNECT
DBA
RESOURCE