OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
flush single SQL plan on RAC Oracle database 19c, 19.14.0.0.0, RedHatEnterpriseServer 6.10 By: wtolentino on Sat, 02 July 2022	3	26153	Sun, 03 July 2022 01:10 By: John Watson
external table how to check if currently open Oracle database 19c, 19.14.0.0.0, RedHatEnterpriseServer 6.10 By: wtolentino on Fri, 01 July 2022	1	23007	Fri, 01 July 2022 15:13 By: Michel Cadot
Not able to login to database using sqlplus after os patch 12.2.0.1.0, Linux By: BalajiDBA on Thu, 09 June 2022	1	20720	Sun, 12 June 2022 04:29 By: Michel Cadot
Unable to connect Forms 6i and Oracle 12c 12.2.0.1.0 Oracle Database 12c 12.2.0.1.0 By: shamsad.khan@gmail.com on Fri, 27 May 2022	4	19367	Fri, 27 May 2022 10:07 By: shamsad.khan@gmail.com
Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0 Oracle Database 12c 12.2.0.1.0 By: shamsad.khan@gmail.com on Tue, 24 May 2022	7	18630	Wed, 25 May 2022 08:23 By: Michel Cadot
Dropping database link 19c By: varunvir on Thu, 14 April 2022	5	19447	Fri, 15 April 2022 14:56 By: varunvir
Patch conflict DB12.2.0.1, SPARC By: John Watson on Thu, 14 April 2022	0	14636	Thu, 14 April 2022 08:53 By: John Watson
SGA/PGA history Oracle 19c EE on Linux By: db_senior on Sat, 09 April 2022	3	16473	Sat, 09 April 2022 12:38 By: piripicchio
Defragmentation of partitioned indexes to reclaim space. Oracle 12C By: kurki on Mon, 04 April 2022	11	22060	Wed, 06 April 2022 09:09 By: EdStevens
tnsping sqlnet.ora not listing Oracle 12c, linux By: patdev on Thu, 31 March 2022	1	12516	Thu, 31 March 2022 14:37 By: Michel Cadot
Large SHARED_POOL_RESERVED_SIZE, inflated V$SQL Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production By: Andrey_R on Tue, 08 March 2022	8	22248	Thu, 10 March 2022 11:18 By: John Watson
ORA-01805 Timezone files error By: db_senior on Mon, 26 July 2021	5	33602	Thu, 10 March 2022 04:28 By: Andrey_R
Deviations in the databases Oracle,18.0.0.0.0, CentOS Linux release 7.6.1810 (Core) By: BalajiDBA on Mon, 06 December 2021	11	24435	Thu, 10 March 2022 04:20 By: Andrey_R
upgrade database from 11G to 19C 11G (11.2.0.4.0) By: vaibhav8080 on Wed, 16 February 2022	3	14501	Thu, 17 February 2022 10:40 By: Michel Cadot
ORA-00308 ,ORA-27041 -ARCHIVELOG Missing By: Khader Hussain on Mon, 24 January 2022	1	11511	Mon, 24 January 2022 11:21 By: Michel Cadot
message XDB initialized appeared multiple time in alert log (merged) RAC 19 C on linux 7.6 By: janakors on Mon, 13 December 2021	1	13509	Mon, 13 December 2021 23:25 By: janakors
creating a sql plan baseline throws ORA-13846: Cannot create SQL plan baseline on the given plan Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Wed, 01 December 2021	1	15845	Wed, 01 December 2021 12:39 By: Michel Cadot
ORA-30928: Connect by filtering phase runs out of temp tablespace Oracle,18.0.0.0.0, CentOS Linux release 7.6.1810 (Core) By: BalajiDBA on Thu, 25 November 2021	2	16413	Fri, 26 November 2021 00:25 By: BalajiDBA
Truncate SYS.AUD$ Using dbms_audit_mgmt Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: mushy_1983 on Sun, 17 October 2021	11	37987	Wed, 24 November 2021 03:47 By: John Watson
log_archive_dest truncate Oracle12.2 By: Mat44 on Fri, 01 October 2021	2	13299	Fri, 01 October 2021 04:47 By: Mat44
understanding user profile resource parameter CPU_PER_CALL Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Fri, 24 September 2021	1	11352	Fri, 24 September 2021 10:27 By: Michel Cadot
RMAN backup hangs Oracle 18.3, OEL 7.7 By: ApnaDBA on Sun, 15 August 2021	4	27096	Tue, 14 September 2021 10:40 By: gazzag
Broken Job Oracle 12 Unix By: tractor_boy on Wed, 11 August 2021	1	16422	Wed, 11 August 2021 05:52 By: John Watson
Unified Auditing Trail to find grants of privileges on an object Oracle Database Version 19.11.0.0.0 By: wtolentino on Tue, 27 July 2021	6	27405	Tue, 27 July 2021 14:54 By: wtolentino
Too many parse error with error-12850 Oracle, 12.1.0.2, Windows By: patdev on Thu, 15 July 2021	3	23422	Fri, 16 July 2021 07:58 By: Michel Cadot
User process details (merged) By: unna on Wed, 02 June 2021	4	27904	Tue, 08 June 2021 15:04 By: unna
can select on dba_segments view but throwing error when using on a package Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: wtolentino on Wed, 26 May 2021	11	26146	Tue, 01 June 2021 12:09 By: Michel Cadot
DISK_ASYNCH_IO=TRUE, FILESYSTEMIO_OPTIONS=SETALL but v$iostat.file=ASYNC_OFF Oracle 19.3 By: burkinaone on Fri, 21 May 2021	7	21359	Tue, 25 May 2021 09:13 By: burkinaone
db_32k_cache_size RHEL RHEL 7.9, Oracle 19.3 By: burkinaone on Tue, 18 May 2021	6	17950	Fri, 21 May 2021 15:27 By: EdStevens
VARCHAR2 Stored in DB in Terms of Bytes Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit By: robh0502 on Sat, 08 May 2021	1	15382	Sat, 08 May 2021 00:45 By: Michel Cadot
Grant Select rights Oracle 12c Win 2008 By: Linou14 on Wed, 05 May 2021	2	16601	Wed, 05 May 2021 15:20 By: EdStevens
ORA-01918: user 'HR' does not exist By: dancko on Mon, 26 April 2021	4	21590	Mon, 26 April 2021 05:15 By: Michel Cadot
Export and Import of huge schemas 19c By: JackBauer on Fri, 16 April 2021	1	16478	Fri, 16 April 2021 04:02 By: Michel Cadot
ORA-01653: unable to extend table Oracle 11.2.0.4.0 By: ak1900 on Wed, 07 April 2021	1	10243	Wed, 07 April 2021 09:10 By: John Watson
Not able to hot clone remote pdb with same name 19.0.0, Windows 2016 By: juniordbanewbie on Thu, 25 March 2021	5	17887	Mon, 29 March 2021 12:52 By: John Watson
Database resources By: JackBauer on Fri, 26 March 2021	4	14202	Sat, 27 March 2021 08:23 By: BlackSwan
audit use of dynamic sql DB 19.x By: John Watson on Thu, 18 March 2021	3	18506	Fri, 19 March 2021 14:49 By: John Watson
SYS Account locked Oracle 18c Windows 10 By: grh_oracle on Tue, 16 March 2021	1	11601	Tue, 16 March 2021 12:30 By: Michel Cadot
Transactions are failing due to insufficient space in the undo tablespace Oracle 12.2.0.1, Linux 6 By: BalajiDBA on Thu, 11 March 2021	10	17748	Mon, 15 March 2021 10:56 By: EdStevens
Restrict email recipients Oracle Database Standard, 12.1.0.2, RHEL 7 By: jtaylor75 on Wed, 10 March 2021	5	15032	Wed, 10 March 2021 18:12 By: jtaylor75