Please enter search query.
Search <book_title>...
APTARE IT Analytics Release Notes
Last Published:
2023-01-19
Product(s):
APTARE IT Analytics (10.6)
- Introduction
- Patch release for version 10.6.00
- Patch releases: APTARE IT Analytics
- Patch releases: APTARE IT Analytics
- What's new: Version 10.6.00 highlights
- Supported Systems
- Installations and Upgrades
- Enhancements and Resolved Issues
- Known issues, optimizations, and End-of-Life (EOL)
Dropping SCDBUSR in a shared service environment
In a shared services environment, connection using SYSDBA may fail. In such a case, upgrade continues without dropping the user and a message is displayed at the end of the upgrade instructing user to drop SCDBUSR manually.
Follow the steps given below to verify and manually delete SCDBUSR.
Verifying the existence of SCDBUSR
- su - aptare
- sqlplus / as sysdba
- Execute alter session set container=scdb;
- Execute Select * from all_users where username='SCDBUSR';
Deleting SCDBUSR manually
- Execute su - aptare
- Execute @../database/ora_scripts/drop_scdbusr_upgrade.sql