Thursday, 9 February 2017

ORA-01882

Reports Error ORA-01882: Timezone Region Not Found (Doc ID 390954.1)

SYMPTOMS

In some of the reports, the following error is displayed:

An error has occurred!
Error rendering element. Exception: ORA-01882: timezone region not found
ORA-06512: at "SYSMAN.MGMT_GLOBAL", line 7
ORA-06512: at "SYSMAN.MGMT_VIEW_UTIL", line 189

+ emoms.log files contain below errors :

2006-08-15 18:17:49,484 [DeliveryThread-SNMP3] ERROR jdk.NLSUtil getFormattedDateWithTZ.407 -
Invalid region name format: GMT+08:00
2006-08-15 18:17:49,500 [DeliveryThread-SNMP3] ERROR jdk.NLSUtil getFormattedDateWithTZ.407 -
Invalid region name format: GMT+08:00
2006-08-15 18:17:49,531 [DeliveryThread-SNMP3] ERROR jdk.NLSUtil getFormattedDateWithTZ.407 -
Invalid region name format: GMT+08:00


CAUSE

Time zone issue on the target box.

Created Report specifying the Target time zone which worked.


SOLUTION

Please follow the below Steps :

Select that Report for which errors are being encountered -> Click on Create Like
On the General Tab -> Under Time Period
Click on Set Time Period
Select the Agent (target) Time zone
Click Preview or OK
then access the newly created Report.

ORA-00959: tablespace 'TABSPACE1' does not exist

I specifically exported a large partitioned table. The tablespace it was in is TABSPACE1, which also contains many more large tables

When I import into another instance, which does not have the tablespace TABSPACE1, I get the error message

IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TABSPACE1' does not exist
Import terminated successfully with warnings.

This is fair enough, but is there a way of forcing the import into another tablespace ??

Solution:-

If you specify ignore=y in your import the table will get created in the schema's default tablespace.
 Just make sure that the default tablespace is the one that you want to use.
Otherwise create the table the way you want in the proper tablespace then import with ignore=y.

ORA-01917

Error 'ORA-01917: user or role 'PSQA' does not exist' when importing Controller Oracle database.
ErrorI am trying to import schema into Oracle database-12c, using a command similar to the following:
imp system/password@databasename file=exp_SOURCEUSERNAME.dmp log=DESTINATION_USERNAME-imp.log
fromuser=SOURCEUSERNAME touser=DESTINATION_USERNAME
Receives below error message.
1.       IMP-00017: following statement failed with ORACLE error 1917:
 "GRANT SELECT ON "ABC_APL_PROFILE_MST" TO "PSQA""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PSQA' does not exist.

Cause
The environment from where the original backup (export / .DMP) file was created is using the (optional) Oracle feature which creates additional grants on objects in the Controller schema.

Solution
Delete the schema, then re-create a blank schema. Finally, import the user (into the new schema) but this time use the optional switch:
grants=no.


Modify your import script, to something similar to:
imp system/password@databasename file=exp_SOURCEUSERNAME.dmp log=DESTINATION_USERNAME-imp.log fromuser=SOURCEUSERNAME touser=DESTINATION_USERNAME grants=no

Issue resolved.



Monday, 6 February 2017

ORA-04031: unable to allocate 4096 bytes of shared memory

When i am going to import schema facing below issue on 12c Database.

ERROR:-

EXP-00008: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","oracle/i18n/util/LocaleMapper","JOXLE^aff8222c",":SGAClass")
EXP-00000: Export terminated unsuccessfully.

Solution:-

SQL> ALTER SYSTEM SET SGA_MAX_SIZE=512M SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET SGA_TARGET=512M SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='512M' scope=spfile;

System altered.

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate;

SQL> startup;

Retest issue.