Dream Always Dream , if you don't work on it : Real-world Oracle DBA troubleshooting guides for RAC, Data Guard, RMAN, performance tuning, upgrades, backups, and cloud migration. Tested in production environments.
Friday, September 13, 2024
Thursday, September 12, 2024
Generate SSH key to setup Git Repo
Generate SSH key to setup Git Repo
C:\Users\>ssh-keygen -t rsa -b 4096 -C "anurag.pandey@demo.com"
Generating public/private rsa key pair.
Enter file in which to save the key (C:\Users\/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in C:\Users\/.ssh/id_rsa
Your public key has been saved in C:\Users\/.ssh/id_rsa.pub
The key fingerprint is:
SHA256:sqJ1iaDi3R0VmwiFwKDOriahqrBfrRYMpvNERmO0jO4 anurag.pandey@demo.com
The key's randomart image is:
+---[RSA 4096]----+
| o+.. .. |
|.o+o .. |
|ooo. . . |
|+ = . . + |
| O.o ..S+ |
|*...oo +. |
|=E =.=. |
|Boo+o+. . |
|Xooo.. . |
+----[SHA256]-----+
C:\Users\>
copy and add id_rsa.pub to git setting - Authentication keys
Monday, September 9, 2024
Source database providers for DMS Schema Conversion - DMS SCT
Source database providers for DMS Schema Conversion - DMS SCT
=> DMS Schema Conversion supports the following data providers as sources for your migration projects.
- Microsoft SQL Server version 2008 R2, 2012, 2014, 2016, 2017, and 2019
- Oracle version 10.2 and higher, 11g and up to 12.2, 18c, and 19c, and Oracle Data Warehouse
- PostgreSQL version 9.2 and higher
- MySQL version 5.5 and higher
Gather stats in Oracle - most commonly used DBMS_STATS.GATHER_TABLE_STATS parameters
Below is a comprehensive explanation of the most commonly used DBMS_STATS.GATHER_TABLE_STATS parameters and when you should use them. Synta...
-
C:\Users\Administrator.ANURAG-PC>tnsping ducat TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 27-DEC-2017 21:...
-
Error while starting ./runInstaller for oracle 19c installation on Linux 8 [oracle@ip-192-168-43-225 oracle]$ ./runInstaller /u01/or...
-
Install CSSCAN login with SYS user @?/rdbms/admin/csminst.sql ############### csscan \"sys as sysdba\" full=y ...