OEM Error when assigning an email id to SYS user:
Internal error. ORA-04063: package body "SYSMAN.EMD_NOTIFICATION" has errors
ORA-06508: PL/SQL: could not find program unit being called:
ORA-06512: at "SYSMAN.MGMT_PREFERENCES", line 1536 ORA-06512: at line 1
Oracle policy recommends taking away the execute privilege on UTL_SMTP from PUBLIC. This takes away the privileges from SYSMAN as well. SYSMAN needs execute on UTL_SMTP and UTL_TCP to send notifications.
1. Log into the repository database as sys:
grant execute on sys.utl_smtp to sysman;
grant execute on sys.utl_tcp to sysman;
alter package sysman.emd_notification compile;
Oracle error: “data got committed in another/same session, cannot update row.”
When this error continued to pop up, the only solution that worked for me was this from OTN Discussion Forums:
Just a heads up, if you really need to get that column updated:
1. Copy and edit the value to a safe place such as notepad or another
sql developer worksheet, don't try to save in the table.
2. In a sql developer worksheet, make an update query to set the
BLOB/CLOB field to NULL
3. Run the update query and commit
4. refresh your table view, the BLOB/CLOB should be NULL now
5. Copy the value back in and commit
This worked very well for me but it must be done in the same sql developer
instance that is throwing the error. I tried to have a coworker null the
field and it did not affect my session at all even after refreshing the
table. Also my coworker's sql developer showed the field to be NULL even
before I asked them to try to edit it.
ORA-01127 database name ‘string‘ exceeds size limit of string characters
The specified database name is too long.
Shorten the database name to eight characters or less.
Error DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
This error indicates that you do not have any preferences installed. When installing the Oracle® server software, the InterMedia should get installed automatically with the default preferences. These are dependent on the operating system language. You can install the French preference if the language of your Oracle server is French, or the English one if the language of your Oracle server is English.
Install the appropriate language-specific default preferences. There are scripts in …/ctx/admin/defaults which create language-specific default preferences. They are named in the form of drdefXX.sql, where XX is the language code (from the Server Reference Manual).
To install the US defaults, for instance:
sqlplus ctxsys/<password> @defaults/drdefus.sql
To install the French defaults, for instance:
sqlplus ctxsys/<password> @defaults/drdeffrc.sql
Grant ‘all privileges’ to ctxsys within Oracle.
After these steps, the InterMedia Context server should start.
Oracle Error :: ORA-01552: cannot use system rollback segment for non-system tablespace ‘CRM’
Possible Reason and Action:
Undo tablespace is missing – Recreate the undo tablespace
Undo tablespace size is full – Create new undo tablespace and make it default
Undo tablespace datafile offline – Make it online
SQL> SELECT TABLESPACE_NAME, STATUS FROM DBA_TABLESPACES;
SQL> SELECT FILE#, STATUS FROM V$DATAFILE;
If any datafile is OFFLINE, bring it ONLINE. Eg:
SQL> ALTER DATABASE DATAFILE ‘D:CRMDATAUNDOTBS.DBF’ ONLINE;
SQL> SHOW PARAMETER UNDO
NAME TYPE VALUE
——————————– ———– ——————
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS
If undo_management parameter isn’t auto, set it to auto in parameter file and restart database.
Text: not enough shared pool memory, should be at least %s bytes
Init.ora parameter shared_pool_size is too small
Increase the parameter value