Oracle start without DBA Group

My user account was indirectly a member of the ora_dba group, via my administrator rights, but it seems I need to be directly a member of the group to login / as sysdba.

That said, the short, bullet point method is as follows:

Cd %ORACLE_HOME%\database
set ORACLE_SID=dbadb01.
Rename the current password file pwddbadb01.ora to pwddbadb01.ora.keep.
Copy another password file, for which I did know the SYS password, to pwddbadb01.ora.
Sqlplus sys/known_password as sysdba.
startup.
exit.
Delete pwddbadb01.ora.
Rename pwddbadb01.ora.keep to pwddbadb01.ora.

Oracle Checking Import Status

IMPDP Hangs, or Appears to Hang – But Has it?


select owner_name, job_name, operation, job_mode
from dba_datapump_jobs
where state='EXECUTING' ;

select owner_name, job_name, session_type
from dba_datapump_sessions;

select v.status, v.sid,v.serial#,io.block_changes,event
from v$sess_io io, v$session v
where io.sid = v.sid
and v.saddr in (
select saddr
from dba_datapump_sessions
) order by sid;

select s.sid, s.module, s.state,
substr(s.event, 1, 21) as event,
s.seconds_in_wait as secs,
substr(sql.sql_text, 1, 30) as sql_text
from v$session s
join v$sql sql on sql.sql_id = s.sql_id
where s.module like 'Data Pump%'
order by s.module, s.sid;

Oracle Network ACL

Get in contact with another Server – Access Control List (ACL)

https://joelkallman.blogspot.com/2010/10/application-express-network-acls-and.html

Enable Oracle database to send emails via SMTP server

Network ACLs and Database Upgrade to Oracle 12c

How to send mail from Oracle APEX

https://dbaclass.com/article/ora-24247-network-access-denied-by-access-control-list-acl/

Oracle 11g Acces Control List and ORA-24247

How to Send Emails from APEX to an External Source Using Gmail’s SMTP

http://dgielis.blogspot.com/2019/10/free-oracle-cloud-11-sending-emails.html