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
upgrade database from 11G to 19C 11G (11.2.0.4.0) By: vaibhav8080 on Wed, 16 February 2022	3	9540	Thu, 17 February 2022 10:40 By: Michel Cadot
ORA-00308 ,ORA-27041 -ARCHIVELOG Missing By: Khader Hussain on Mon, 24 January 2022	1	8127	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	9032	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	10998	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	13348	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	28759	Wed, 24 November 2021 03:47 By: John Watson
log_archive_dest truncate Oracle12.2 By: Mat44 on Fri, 01 October 2021	2	10409	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	8463	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	19665	Tue, 14 September 2021 10:40 By: gazzag
Broken Job Oracle 12 Unix By: tractor_boy on Wed, 11 August 2021	1	13185	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	22979	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	16794	Fri, 16 July 2021 07:58 By: Michel Cadot
User process details (merged) By: unna on Wed, 02 June 2021	4	23451	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	21899	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	18003	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	14887	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	12013	Sat, 08 May 2021 00:45 By: Michel Cadot
Grant Select rights Oracle 12c Win 2008 By: Linou14 on Wed, 05 May 2021	2	14108	Wed, 05 May 2021 15:20 By: EdStevens
ORA-01918: user 'HR' does not exist By: dancko on Mon, 26 April 2021	4	16984	Mon, 26 April 2021 05:15 By: Michel Cadot
Export and Import of huge schemas 19c By: JackBauer on Fri, 16 April 2021	1	13377	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	7287	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	14600	Mon, 29 March 2021 12:52 By: John Watson
Database resources By: JackBauer on Fri, 26 March 2021	4	11468	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	15173	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	8098	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	14333	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	12335	Wed, 10 March 2021 18:12 By: jtaylor75
Oracle Database Migration Oracle 11g,12c, Unix By: BalajiDBA on Sat, 06 March 2021	5	14306	Mon, 08 March 2021 00:32 By: BalajiDBA
ORACLE LICENSE ORACLE DATABASE 19c By: merouanballout on Tue, 23 February 2021	6	8749	Tue, 23 February 2021 09:33 By: merouanballout
how many oracle tools do we really need to install for SE2 edition 19.0.0 windows 2016 By: juniordbanewbie on Tue, 09 February 2021	0	5787	Tue, 09 February 2021 23:06 By: juniordbanewbie
Tablespace size By: JackBauer on Tue, 09 February 2021	9	8851	Tue, 09 February 2021 11:39 By: Michel Cadot
how to manually remove components in 12.1.0.2 CDB Oracle Linux 7.6 By: juniordbanewbie on Tue, 12 January 2021	2	9123	Mon, 08 February 2021 15:41 By: Olexandr Siroklyn
startup upgrade any oracle version By: Olexandr Siroklyn on Mon, 08 February 2021	1	5972	Mon, 08 February 2021 14:49 By: Andrey_R
ORA-04031: unable to allocate 4064 bytes of shared memory Oracle 11g XE, MS Windows 7 Enterprise, 8GB RAM By: Littlefoot on Fri, 25 December 2020	4	15239	Mon, 08 February 2021 13:23 By: Littlefoot
Trace non-invokers sessions of a different instance Oracle Database 19c By: Andrey_R on Sun, 07 February 2021	7	8901	Mon, 08 February 2021 08:32 By: Andrey_R
Trying to export a table that contains blobs 11.2.0.1 By: Amine on Sat, 06 February 2021	1	7018	Sat, 06 February 2021 12:27 By: Michel Cadot
How to IMPDP to PDB? DB 19.3, RHEL By: noob2021 on Wed, 13 January 2021	9	20713	Mon, 01 February 2021 18:28 By: EdStevens
sys.x$dbgalertext alert log info text access racle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: wtolentino on Mon, 25 January 2021	3	11096	Mon, 25 January 2021 13:30 By: John Watson
how to verify if Audit Trail is capturing the latest Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: wtolentino on Tue, 08 December 2020	24	28621	Thu, 21 January 2021 14:35 By: wtolentino
DB Time spent nowhere in AWR Oracle 12C R1 on Linux By: piripicchio on Thu, 24 December 2020	1	7492	Thu, 24 December 2020 07:46 By: John Watson