--set REMOTE_LOGIN_PASSWORDFILE=NONE
--then re-create it and reset REMOTE_LOGIN_PASSWORDFILE to EXECLUSIVE again
Popular Posts
-
Apps team feedback that few heavy jobs run much slower after upgrade to 10g. After two hours investigation, I notice there is lots of wait e...
-
SYS@DGS> startup mount ORACLE instance started. Total System Global Area 680607744 bytes Fixed Size 2229600 bytes Varia...
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
Lots of such article in internet, also can refer to " F.3 Using the DUPLICATE Command to Create a Standby Database" in Oracle...
-
1. The dictionary view of dba_tab_col_statistics https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_2089.htm#REFRN20275 No...
-
This installation extended to my home hour, since both Postgresql and Zabbix are new to me. Followed few articles without much difficulty.... -
after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be de...
-
Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object...
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
1. Refresh group failed with FAST REFRESH mode . SQL> exec dbms_refresh.refresh('"ARBOR"."ARBOR_DAILY_REF"...