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

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

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

Undo segments status is PARTLY AVAILABLE

Alert log shows:

SMON: about to recover undo segment 309
SMON: mark undo segment 309 as available
SMON: about to recover undo segment 312
SMON: mark undo segment 312 as available
SMON: about to recover undo segment 40


To fix:

Check which segments have status PARTLY AVAIABLE and if you do not have any in-doubt transaction (dba_2pc_pending , v$transaction, etc) them:

alter rollback segment XXXXX online;

Best Regards,
Paulo Portugal

Resseting Oracle VM Manager Password for ADMIN or Any other user

1-Login to database as SYS user or OVS user

2-Take a backup from OVS_USER table
create table OVS_USER_BKP as select * from OVS_USER;

3-Run the command below:
UPDATE OVS_USER set password='testepasswd' where account_name='ADMIN';
commit;

4-Encrypt the password with this command below:
UPDATE OVS_USER set password=create_encrypt_passwd('testepasswd') where account_name='$USER';
commit;


Best Regards,
Paulo Portugal

Mount ISO on Linux

1-Create directory to be used
mkdir -p /mnt/disk

2-Mount using command below:
mount -o loop OracleVM-Manager-2.2.0.iso /mnt/disk


Best Regards,
Paulo Portugal

Creating OVS repository - Oracle VM

1-Create partition using fdisk

2-Make ocfs2
mkfs.ocfs2 /dev/sda4

3-Create repository
./opt/ovs-agent-2.3/utils/repos.py -n /dev/sda4 --options rw,sync

4-List ID for repository
./opt/ovs-agent-2.3/utils/repos.py -l

5-Mark it as a ROOT repos
./opt/ovs-agent-2.3/utils/repos.py -r 12d25384-1eda-4e95-9f91-1b6f304a5587


Best Regards,
Paulo Portugal