Amazon books

Friday, March 16, 2012

SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly

If getting this error using addbctl.sh script to start or stop database after a migration, or even if is just using SQLPLUS and got this error below:

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly


Just UNSET the ORA_TZFILE variable.

I added this line below in my .env file:

unset ORA_TZFILE

Best Regards,
Paulo Portugal

Monday, March 5, 2012

FRM-92120 Registry.dat is missing

Just install User-Agent switcher (https://chrome.google.com/webstore/detail/djflhoibgkdhkhhcedjiklpkjnoahfmg/related?hl=en-US&gl=US) and check "Mac Safari 4" and try again.

This works for me.

Best Regards,
Paulo Portugal

Thursday, March 1, 2012

REP-56055: Exceed max connections allowed: 20

Go to your Oracle Reports server and change file $ORACLE_HOME/reports/conf/ like below:

--OLD VALUE:




--NEW VALUE





Restart iAS.

opmnctl stopall
opmnctl startall

Best Regards,
Paulo Portugal