tag:blogger.com,1999:blog-88757862477747031032024-02-15T22:37:23.641-06:00My notes on Oracle Database Administration -- MoidMoid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.comBlogger741125tag:blogger.com,1999:blog-8875786247774703103.post-42545783365959720572023-12-15T11:13:00.005-06:002023-12-15T11:13:33.332-06:00MoidIITDocID-629: How To Get Table Growth History Information? --Moid Muhammad<p><a href="https://docs.google.com/document/d/16KY0oDgk-ua4uKSqmySVdDnd28_-q2uX8yDpJMEtXKQ/edit?usp=sharing" target="_blank">Click here for the document.</a></p><p>Moid</p><p><span style="background-color: white;"><span style="color: white;">table size segment size </span></span></p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-62174206926371717732023-09-27T16:08:00.002-05:002023-09-27T16:08:28.397-05:00MoidIITDocID-628: How to upgrade 12c database to 19c using Autoupgrade? --Arshia Jabeen<p><a href="https://docs.google.com/document/d/1RIa4mhCGbxVXGm5YC9SILSDunjDVrOkS3qAdAZyQHhY" target="_blank">Click here for the link.</a></p><p>by Arshia Jabeen.<br /><br />Keywords: Moid oracle 19c autoupgrade rac data guard ASM</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-63061114230123133172023-09-27T15:56:00.003-05:002023-09-27T15:56:42.067-05:00MoidIITDocID-627: How to upgrade 12c standalone database to 19c using DBUA? --Arshia Jabeen<p><a href="https://docs.google.com/document/d/1_03Xg2Ni8O2CiAeAjYEgNwD0IUhAOj7k-WASru3592w/edit" target="_blank">Click here for the document.</a></p><p>Arshia Jabeen</p><p><span style="color: white; font-size: xx-small;">Keywords: Moid oracle 19c upgrade Arshia <br />migration export import data pump tesla MyTravelsPro.com MoidIIT.com</span></p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-6412350171449547952023-09-16T10:19:00.002-05:002023-09-16T10:19:05.075-05:00MoidIITDocID-625: How to load Scott Schema in Oracle database? --Arshia Jabeen<p><a href="https://docs.google.com/document/d/1HK3LH4XMVWI6N7rMXCEXNYxDgw9D7rSs8DsN53JzvhE/edit?usp=sharing" target="_blank">Click here for the document,</a></p><p>Thanks,<br />Arshia Jabeen.</p><p><span style="background-color: black; color: white;">Keywords: create scott schema, run script</span></p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-81023648304684351642023-08-27T15:22:00.002-05:002023-08-27T15:56:26.998-05:00MoidIITDocID-624: How to start xclock (GUI tools) after switching user to oracle in Linux? --Moid Muhammad<p><a href="https://docs.google.com/document/d/1tsYo3Qsmz6d1E33CeYbSkIkDQxc-9Cudejx_-MIWous/edit?usp=sharing" target="_blank">Click here for the document.</a></p><p>Moid</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-19317832393625279502023-08-23T17:11:00.005-05:002023-09-27T16:14:04.485-05:00MoidIITDocID-623: Shell script that loop through tnsnames.ora to execute SQL script in multiple databases --Moid Muhammad<p><a href="https://docs.google.com/document/d/1rPcXBSo8TvmWGYTohJ22s9Jh7xy1cro3orH8Qw-fc7U/edit?usp=sharing" target="_blank">Click here for the document.</a> </p><p>Moid Muhammad</p><p><span style="color: white;">Keywords: .sql run SQL Script multiple databases servers parameter change across </span></p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-12114200866276534652023-08-23T14:10:00.007-05:002023-08-23T14:10:44.558-05:00MoidIITDocID-622: How to schedule sql script on Linux DB server? --Moid Muhammad<p><a href="https://docs.google.com/document/d/1Twlc1yocIx_y7Ldent1MZueqyHJixrNnsuwPsuYbJEg/edit?usp=sharing" target="_blank">Click here for the link.</a><br /><br />Moid Muhammad</p><p><br /></p><p><span style="color: white;">Keywords:<br />crontab execute schedule oracle sqlplus </span></p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-59892135940334920802023-08-14T13:27:00.004-05:002023-08-23T14:11:52.018-05:00MoidIITDocID-620: How to register database service to non-default LISTENER port? --Moid<p><a href="https://docs.google.com/document/d/15TurpJ8tzF-vYX1ZrzGG0qg50ah2LpNWO_0IP0KoSVM/edit?usp=sharing" target="_blank">Click here for the document</a></p><p>Moid</p><p><span style="color: white;"><span style="background-color: white;"><span>Keywords: </span></span><span style="background-color: white;"><span>Oracle Listener on 1733 </span></span><span style="background-color: white;">non-default port </span><span style="background-color: white;">Register multiple ports on different listeners.</span></span></p><p><br /></p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-6297422884825295562023-08-14T12:48:00.005-05:002023-08-23T14:13:09.307-05:00MoidIITDocID-619: How to register multiple ports to oracle LISTENER? --Moid<p><a href="https://docs.google.com/document/d/1ah0o840Ci0S9zyLXTAVCpkgFeeu0bZl278253u0Ss3I/edit?usp=sharing" target="_blank">Click here for the document.</a></p><p>Moid</p><p><span style="color: white;"><span style="background-color: white;"><span>Keywords: </span></span><span style="background-color: white;">Oracle Listener 1733 </span><span style="background-color: white;">non-default port </span><span style="background-color: white;">multiple ports on different listeners.</span></span></p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-29254234954416857412023-06-20T16:55:00.000-05:002023-06-20T16:55:08.825-05:00MoidIITDocID-618: How to move oracle tables to a different tablespace? --Moid<p><a href="https://docs.google.com/document/d/1kXmfHlA4NtAOlkxQa10rzhwNrZo4C7oSW2yYWlsdz_0/edit?usp=sharing" target="_blank"> Click here for the document.</a></p><p>Moid</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-85547703542510287782023-06-20T16:38:00.003-05:002023-06-20T16:38:45.233-05:00MoidIITDocID-617: Query to find the non-oracle user maintained tables in SYSTEM tablespace<p><a href="https://docs.google.com/document/d/1YuBDsvQ-5v746ckdfElVeqfl_5qECbFuy7W_DbnHddw/edit?usp=sharing" target="_blank"> Click here for the document.</a></p><p>Moid</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-40752086741584903042023-03-06T07:22:00.000-06:002023-03-06T07:22:01.222-06:00MoidIITDocID-616: How to check if TDE or TSE is enabled in Oracle database? --Moid<p><a href="https://docs.google.com/document/d/1618ABESiRFdEFBRvkECIUCuSsQzCWwbI5vI8EWRTHH8/edit?usp=sharing" target="_blank">Click here for the document.</a></p><p>Moid</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-26786116046835315352023-03-01T10:57:00.000-06:002023-03-01T10:57:05.707-06:00MoidIITDocID-615: Create trigger to capture failed database login attempts --Moid<p><a href="https://docs.google.com/document/d/1IBkW0mcv0ZaCQ-hhciMB16itiBipf0F4FeajX-Y1afA/edit?usp=sharing" target="_blank">Click here for the document.</a></p><p>Moid</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-63862972188971681712022-10-17T12:11:00.003-05:002022-10-17T12:11:33.752-05:00MoidIITDocID-614: Why is Oracle DataPump export process slow? --Moid<p><a href="https://docs.google.com/document/d/1PcSnXeDhdQpDTKEVpmJR8AKMbVXE5Ui-u7aOkUUQjs0" target="_blank"> Click here for the document.</a></p><p>Moid</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-70115181492629001172022-10-15T20:19:00.005-05:002022-10-15T20:20:49.512-05:00MoidIITDocID-613: How to check size of all non oracle_maintained tables and index in oracle database? --Moid<p><a href="https://docs.google.com/document/d/1terHKASSsPaBzmyVaeW2aU-mV5kf-Gv5BQMH-feJm6Q" target="_blank">Click here for the document</a></p><p>Moid</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-60006651380194397192022-08-17T12:53:00.004-05:002022-08-17T12:54:13.993-05:00MoidIITDocID-612: How to run SQL script in loop? (loop.sql) --Moid<p><a href="https://docs.google.com/document/d/1qplWcYcL_uB9bCdHHi2cFanlvSXcHj9ACMAtQqdYYPI/edit?usp=sharing" target="_blank">Click here for the document.</a></p><p>Moid </p><p><span style="color: white;">Keywords: </span></p><p><span style="color: white;">loop.sql</span></p><h1 class="fs-headline1 ow-break-word mb8 flex--item fl1" itemprop="name" style="background-color: white; border: 0px; box-sizing: inherit; flex: 1 1 auto; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI Adjusted", "Segoe UI", "Liberation Sans", sans-serif; font-size: var(--fs-headline1) !important; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; font-weight: inherit; line-height: 1.3; margin-bottom: var(--su8) !important; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-wrap: break-word; padding: 0px; vertical-align: baseline;"><span style="color: white;">Oracle Sqlplus calling sql script repeatedly in a loop</span></h1>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-88306663165863874012022-08-04T08:36:00.003-05:002022-08-04T08:36:18.535-05:00MoidIITDocID-611: How to build two node RAC cluster on Oracle Virtual Box? --Nasreen Fatima<p><a href="https://docs.google.com/document/d/1xoTm-Nelk3baP7X3HKqzdukk7TXMKOQKSo5ptsx1YpI/edit?usp=sharing" target="_blank">Click here for the link</a></p><p>Nasreen Fatima</p><p><span style="color: white;">Keywords: Build RAC Cluster, 19c</span></p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-87233068724129130512022-06-29T08:58:00.001-05:002022-06-29T08:58:29.381-05:00MoidIITDocID-610: How to apply 19c patches on GI and RDBMS home (April 2022)? --Arshia Jabeen<p><a href="https://docs.google.com/document/d/1Ritr7FrXHqS3pVUt1BWvljTUcKIIMKaCjLGTbIxxjWo" target="_blank"> Click here for the document.</a></p><p>Moid</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-51371148265427804122022-04-14T12:38:00.005-05:002022-04-14T12:38:46.958-05:00MoidIITDocID-606: Script to check tablespace usage - tbs0.sql<p>Click here for <a href="https://docs.google.com/document/d/1i3mCs3VAprOES0me1gcZAnMukQA8HYx7FwOs61qRe7I/edit?usp=sharing" target="_blank">tbs0.sql</a></p><p><br /></p><p>Moid Muhammad</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-15550493320364742272022-04-08T12:47:00.002-05:002022-04-08T12:47:18.381-05:00MoidIITDocID-605: Script to purge Archivelogs in Linux<p><a href="https://docs.google.com/document/d/16gDz7Z7NDKFHq6XhNsrcpo8Xlj-J9NysrmosFICAa84/edit?usp=sharing" target="_blank">Click here for the link</a></p><p><br /></p><p>Moid Muhammad</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-41132538629821400512022-04-07T12:43:00.005-05:002022-04-07T13:10:35.053-05:00MoidIITDocID-604: Script to monitor mount points on Linux --Moid<p> </p><p dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt;">See <a href="https://docs.google.com/document/d/1g1_gXfUkRDCpeWu-_ManuLrf8gOIBhsozmHoZQyGEtQ/edit?usp=sharing" style="font-family: "Courier New"; font-size: 11pt; white-space: pre;" target="_blank">monitor_mountpoints.sh</a></p><p dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt;"><br /></p><p dir="ltr" style="line-height: 1.2; margin-bottom: 0pt; margin-top: 0pt;">Moid Muhammad</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-6367611731973657452022-03-02T09:51:00.004-06:002022-03-31T10:28:53.711-05:00MoidIITDocID-601: Database Migration using Transportable tablespace (AIX to Linux) - Database Migration Steps (rough notes) --Moid<p><a href="https://docs.google.com/document/d/1f5vtVo5zKdiTfhL-qZYNH1L7fnuqECeqeSKWtzwe1co/edit" target="_blank">Click here for the document. </a></p><p><br /></p><p>Note that this is the first draft of the notes. I will be making it clean as time permits. You can see Oracle <a href="https://support.oracle.com/knowledge/Oracle%20Cloud/2471245_1.html" target="_blank">Doc ID 2471245.1</a> for more details. </p><p><br /></p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-70779102854202016992022-02-27T12:07:00.005-06:002022-03-01T18:08:19.989-06:00MoidIITDocID-600: How to install Oracle SQL Developer? --Moid<p><a href="https://docs.google.com/document/d/1GNtkhTxHYKoTl6x1hVpDlm0IAKRV6klKLxmeQ5fyl0E/edit" target="_blank">Click here for the document.</a></p><p>Moid</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-66745681114065764422022-02-20T11:29:00.001-06:002022-02-20T11:29:23.451-06:00MoidIITDocID-599: Query to get count of in-memory active session history --Moid<p><a href="https://docs.google.com/document/d/1GypMa0dyE_nfDbfwZnuT8xSZITbPtoVLpH7iaH2UgTw/edit?usp=sharing" target="_blank"> Click here for the document.</a></p><p>Moid</p>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0tag:blogger.com,1999:blog-8875786247774703103.post-4215612874378453512022-02-19T19:35:00.001-06:002022-02-19T19:35:02.353-06:00MoidIITDocID-596: How to send email from Linux server? --Moid<p><span style="font-family: Arial; font-size: 11pt; font-weight: 700; white-space: pre-wrap;">Example:</span></p><span id="docs-internal-guid-ac710d5f-7fff-bac4-dfb8-1c7b878e7d9f"><span style="background-color: white; color: #222222; font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">echo "My message" | mail -s subject </span><a href="mailto:contactmoid@gmail.com" style="text-decoration-line: none;"><span style="background-color: white; color: #1155cc; font-family: Arial; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; text-decoration-line: underline; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;">contactmoid@gmail.com</span></a></span><div><br /></div><div>Click<a href="https://docs.google.com/document/d/1o6M78hFhkj6t2becvSlB4wOCM7wLMPCxm21CLs0BEqc/edit?usp=sharing" target="_blank"> here for the document.</a></div><div><br /></div><div>Moid</div>Moid Muhammadhttp://www.blogger.com/profile/03627509414262663231noreply@blogger.com0