Exadata:
+ Building Exadata simulation in VM for learning - Part1(install) exadata simulator
+ Standalone Oracle Grid Infrastructure in EXADATA - Part2(install)
+ Oracle 11gr2 installation in Exadata standalone grid - Part3(install)
+ VM Simulation Exadata Storage Server Version 12.1.2.
+ Uninstall Exadata Storage Server cell in VMware test
+MS_ALERT HUGEPAGE CLEAR Error from io_setup, async ctx
+Flow of Exadata storage and disk details from Physcial,lun,Cell disk and Grid/Flash disk - Part1(storage)
+How to associate Flash and grid disk/log with cell disk - Part2(storage)
+To know relation between Physical disk,Lun,Partition,Cell disk and Gird/Flash Disk - Part3(storage)
+Associating ASM disk group name with Cell disk alias name - Part4(storage)
+ Apply bundle patch in exadata - Eg Patch 17380185 (Patching)
+ Exadata Pricing
+ Create ASM Disk in Exadata using ASMCA
+ RS-7445 service MS with pid 11475 lost 2 heartbeats, try restarting it
+ CELL-02523 when creating : cellcli -e create cell
+ Exadata : celld service status start stop
+ Exadata bash profile
+ Check hostname setting. Cannot install cell
+ CELL-02018: Internal error detected: Not enough open file descriptors.
+ CELL-02598: Ipaddress/Netmask attribute is not properly configured for interconnection
+ perl(HTML::Entities) is needed by perl-libwww-perl-5.805-1.1.1.noarch.rpm
+ Failed dependencies: libsensors.so.3()(64bit) for net-snmp-5.3.2.2-20.el5.x86_64.rpm
+cellsrv ossmmap_map: mmap failed for SparseV2PhysMap len: as there is insufficient memory
+msStatus stopped : socket open error: Port no: 8888. Received errorno 111. Connection refused
Database:
+Cross platform migration from windows to linux of oracle database
+Restricting TOAD,PLSQL,EXCEL,SQL access from ORACLE App Schema who has DBA Priv
+Create Duplicate role as like DBA role
+SQLPLUS hangs from client server
+ Refresh of PROD database using RMAN duplicate
+Drop database for RAC and NON RAC
+Installing latest version of OPatch
+ORA-12543 due to iptables server firewall.
+Rman backup falis with RMAN-00601 fatal error in recovery manager
+INS-30060 while installing oracle database software
+PRKC-1140 while installing oracle database software
+How to reset the same password for oracle user
+RMAN Backup fails with DBGSQL: TARGET - RMAN-03014 ORA-01008 sqlcode = 1008
+Patch error with genclntsh: Failed to link libclntsh.so.11.1
+OPatch error with wrong stage patch location UtilSession failed: Invalid patch location
+OPatch error with ibclntsh.so.11.1 executables are active
+OPatch warring with ins_precomp.mk overriding commands for target `pcscfg.cfg'
+OPatch warring with ins_srvm.mk:68: warning: overriding commands for target `libsrvm11.so'
+ To calulation ORACLE data guard / standby Bandwidth.
+ Archive log not shiping to standby or datagaurd error ORA 03135 ORA 12152 ORA-16198 ORA-12152 ORA-12592
+Oracle database 12C Documentation reference
+To finding ITL wait hot block objects to increace initrans
+Mlog refresh status and Mlog segment space details
+RAC database installation INFO: PRVF-9652 : Cluster Time Synchronization Services check failed
+FAL[server]: DGID from FAL client not in Data Guard configuration
+v$archive_dest shows BAD PARAM in status column
+PLSQL developer - Initialization error SQL*Net not properly installed OracleHomeKey: OracleHomeDir
+To know the status of sub partition indexes- all_ind_subpartitions status UNUSABLE or N/A in dba_indexes
+Splitting table and drop partition of subpartition table:rebuild UNUSABLE subpartition index
+oracle 11g - explain plan gives 'PLAN_TABLE' is old version
+ORA-04030: out of process memory when trying to allocate 4032 bytes
+Error RMAN-03002 RMAN-05501 RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed - when using restoring RMAN auxiliary Duplicate db
+ORA-25153: Temporary Tablespace is Empty
+Oracle flashback logs not being deleted
+Recovery Writer (RVWR) is stuck until more space - DR database is not sync error with
+Changing Temp tablespace Location to new RAC ASM disk group
+Changing archive log location LOG_ARCHIVE_DEST_1 and db_recovery_file_dest to the new ASM disk Group
+ORA-01261: Parameter db_create_file_dest destination string cannot be translated
+ORA-13518 Invalid database id ORA-06512 at SYS.DBMS_WORKLOAD_REPOSITORY - dbms_workload_repository.create_snapshot
+Drop and Reinstall AWR
+WRI$_OPTSTAT_HISTHEAD_HISTORY and WRI$_OPTSTAT_HISTGRM_HISTORY are not purged.
+RMAN-03009 ORA-19504 ORA-27040 ORA-27040: file create error, unable to create file
+Clearing Dead-marked for killing session in Oracle
+dbms_stats.gather_table_stats ORA-20000: Unable to analyze TABLE
+PRVF-7532 Package pdksh is missing on node - 11204 installation in RHEL6
+ Oracle - Clean the objects inside the schema for refresh using Import(Impdp).
+Standby logs not applying with warning: Waiting for all non-current ORLs to be archived... Media Recovery Waiting for thread 1 sequence
+How to sync oracle data guard DR with missing archive log in PROD and DR
+Error: ORA-00317: file type 0 in header is not log file ORA-00334
+Oracle 11.2.0.4 installation-Package pdksh-5.2.14 - This is a prerequisite condition to test whether the package "pdksh-5.2.14" is available on the system.
+Setting HugePages for Oracle linux
+PLS-00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared
+RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
+ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified ORA-17629: Cannot connect to the remote database server
+RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
+Migrating oracle Database using RMAN Active Database Duplication from Old dataguard standby server to New dataguard standby server without touching PROD.
+Primary database alertlog giving below error(TNS-12564) for DGMGRL data guard services DBSID_DGB.
+ORA-17503: ksfdopn:2 Failed to open file ORA-15173: entry 'dr1DBSID.dat' does not exist in directory 'brokerfile'
+ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim
+Oracle Connection error : Provider cannot be found.It may not be properly installed
+backup controlfile for standby error with RMAN-03009 ORA-01671: control file is a backup, cannot make a standby control file
+ORA-12801: error signaled in parallel query server ORA-01114 ORA-01114 ORA-29701
+Oracle Data Guard config ORA-16057: server not in Data Guard configuration
+SHUTDOWN: Active processes prevent shutdown operation
+Duplicate database fail with RMAN-04014 ORA-01127: database name '/SIDDEVLOP' exceeds size limit of 8 characters
+PRVF-0002:Could not retrieve local hostname
+Moving datafile form NON ASM to ASM
+ORA-00600 on ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
+Adding multiple oracle datagaurd standby database
+drop logfile group ORA-01624: log 1 needed for crash recovery of instance ORA-00312
+ORA-04030: out of process memory when trying to allocate 4032 bytes (qmxdGetChildNo,qmemNextBuf:alloc)
+TNS-12545 TNS-12560 TNS-00515 Linux Error: 99: Cannot assign requested address
+RHEL 7 : PRVF-7532 : Package "compat-libstdc++-33(x86_64)" is missing on node
+PRVF-0002: could not retrieve local node name
+ORA-00214: control file version inconsistent with file
+recover standby database ORA-01110 ORA-01194 ORA-01547 warning: RECOVER succeeded but OPEN RESETLOGS would get error below
+ORA-00334 ORA-00353 ORA-00283 ORA-00354: corrupt redo log block header
+oracle runInstaller bash: xclock: command not found...
+IMPDP table import ORA-31693 ORA-29913 ORA-29400 ORA-26059
+ORA-38706 ORA-38788 ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
+alter database backup controlfile ORA-01110 ORA-01187 cannot read from file because it failed verification tests
+DBUA : InitParamAttributes.loadInitParams java.util.NoSuchElementException java.util.StringTokenizer
+TNS-12542: TNS:address already in use TNS-12560 TNS-00512 Linux Error: 98: Address already in use
Monitoring Scripting:
+Tablespace Monitoring and altering through mail when reaches 90%
+Oracle Data guard log gap status monitoring shell script and alerting through mail
+Oracle Alert log monitoring shell script and alerting through mail
+Oracle ASM Disk Group free space/used space monitoring shell script and alerting through mail
+Oracle RMAN Backup job monitoring shell script and alerting through mail
+Oracle User expiry monitoring shell script and alerting through mail
+Oracle Database Lock details status monitoring shell script and alerting through mail
+ORA 12514 Data guard is not in sync with primary
Performance:
+Unix top CPU and Memory
+Sequence to analysis database level performance
+Object which are all accessed and locked
+Tuning BO report of FCUBS which is taking more than 30mins
+Oracle database is hanging or slow in night due to Auto job
+How to disable DEFAULT_MAINTENANCE_PLAN from DBA_SCHEDULER_WINDOWS
+How to make status column to False in DBA_SCHEDULER_WINDOWS
+Oracle to find over sized(fragmented) index whos size is greater than tablesize
+Wait Event:db file sequential reads
+Wait Event: db file scattered reads
+Wait Event: log file parallel write
+Wait Event: log file sync
+Wait Event: buffer busy waits
+Wait Event: free buffer waits
+Wait Event: enqueue waits
+Wait Event: Cache buffer chain latch
+Wait Event: Cache buffer LRU chain latch
+
+Wait Event: Direct Path Writes
+Wait Event: Latch Free Waits
+Wait Event: Library cache latch
+Wait Event: Shared pool latch
+Wait Event: Row cache objects latch
+ORACLE RAC Performance reference
+ optimizer_skip_scan_enabled performance issue and wrong stats in explain plan
+Oracle database I/O performance issue
GRID/RAC/ASM:
+Oracle Apps dba R12 installation(12.1.1) and database 11.1.0.7
+Oracle apps fresh installation 12.1.1 and upgrade to 12.1.3
+Rapid Install found an already existing /tmp/RapidInstall
+Apps WorkFlow Too many pending requests already exist in the system
+R12 login fails with FND_NO_DATABASE_CONNECTION
+ Oracle Apps ADPATCH interview question and common information's
+ Oracle Apps CONCURRENT MANAGERS basics and information's
+Oracle Apps concurrent managers interview question and common information's
+Oracle Apps 11i and R12 Apps Password
+Manual cloning of appsTier and db tier with out Rapid cloning adcfgclone.pl
+Updating Test Mail ID override address for Workflow Notification Mailer in backend in R12
+ Work Flow mailer inbound response erro - Expected string "folders defined" not found in output
+Oracle apps Work Flow mailer inbound response - Unable to connect to the mail account. Check the host, user name and password
+Applying Patch 14069503 using ADpatch in R12
+R12 Application font, colour, feel and looks different after applying patch
+oracle apps password reset: Too many pending request already exist in the system. Please check your email or contact the system administrator for further assistance.
+RW-50010 Error script has returned an error: 127 RW-50004 Error code received when running external process
+Oracle Apps Information Centers most of useful matalink note
+admerge patch usage
+AutoPatch error: The following ORACLE error: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
+How to invoke admsi.pl before applying patch.
+Checking adpatch worker status using adctrl
+adpatch - An error occurred while generating Oracle Forms library files. Continue as if it were successful
+adpatch FND_INSTALL_PROCESSES table - ORA-00955: name is already used by an existing object
+Oracle apps How to find the adpatch is applied or not
+In the mid of main adpatch you got error for applying pre patch,So How to apply the pre_patch
+oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25002: Definition of type View Definition not found
+ Unable to connect to the mail account. Check the host, user name and password - oracle.apps.fnd.cp.gsc.SvcComponentException WorkFlow mail server stopped
+adhoc approver in HRMS Errors- oracle.apps.ame.dynamicapprovals.server.ApprovalsAMImpl.addApprover
+adpreclone.pl - java.io.FileNotFoundException: /appsutil/clone/jlib/oui/jlib/Libraries.old
+RC-50014: Fatal: Execution of AutoConfig was failed - java.sql.SQLException: Could not get connection to the database
+RC-50004 AC-00005 No write permissions for creating the Context file /appsutil/temp.xml - perl adcfgclone.pl dbTier
+Concurrent: OPP Response Timeout to a higher value-Request Completed with Warning
+SYSADMIN Error Login failed. Please verify your login information or contact the system administrator.
+Oracle apps R12 : Login Page is blank
Unix:
+Unix top CPU and Memory
+SUN Solaris performance - basic check commands
+ elfutils-libelf-devel-static-x86_64 = 0.137-3.el5 is needed by elfutils-libelf-devel-
+ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
+Kernel: Device-mapper: table: 253:8: multipath error getting device
+/var/log/messages error with multipathd: asm!.asm_ctl_spec: add path (uevent)
+Iscsiadm how to remove and read add sigle iscsi lun in RHEL
+Linux - /etc/mail/sendmail.cf is changed and mails are not received
+sendmail 354 enter mail end with . on a line by itself
+How to create password less sudo linux user access on RHEL linux
+RHEL xclock command not found
+ Linux sendmail configuration using microsft exchange setup step by step
+ VMware CDROM mount in RHEL
+Starting httpd Address already in use make_sock
+Unix rpm -qa command hangs
+12c client application load - /bin/ld: cannot find -lcurses collect2: error: ld returned 1 exit status
+Putty login takes time after entering username
+Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr
+vnc viewer connect:A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call no address was supplied 10057
+Datasource java.sql.SQLException ORA-28040 No matching Authentication protocol DRSA0010E
+umount lsof: WARNING: can't stat() cifs file system /mnt
+mount cifs -bash: !,uid=,gid=: event not found
+Open a port in RHEL Linux
MYSQL:
+ MYSQL PROD to DR replicaiton(master - slave) setup for high avaliablity
+ MYSQL : [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.
+MYSQL:mysqldump: Error: Binlogging on server not active
+MYSQL: [Warning] Using a password on the command line interface can be insecure.
+MYSQL ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
+MYSQL : ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
+MYSQL: Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs
MISC:
AWS:
+AWS IAM (Identity And Access Management)
+Install AWS Cli on Windows
+AWS Getting Access key ID and Secret access key for a User.
+Configure AWS Cli with Access key ID and Secret access key
+AWS CLI Create user
+AWS CLI - Add user to a group
+AWS CLI - Attach Policy to User
+AWS CLI - Delete or revoke Policy to User
+AWS - Reset IAM user password
+AWS - Create New EC2 Instance
+AWS Connect to EC2 Instance using Putty
+AWS EC2 - Putty Network Error : Connection timeout
+AWS Create Role
+Attach a Role to EC2 instance
+AWS - AMI User - Assign permission to access EC2 services
+AWS EC2 AMI - Copy the Image to different region
+AWS EC2 AMI golden image creation
+AWS grant IAM user with Marketplace access
+AWS Marketplace testing IAM user access
+AWS Marketplace share the AMI Image
+AWS Create S3 Bucket
+AWS Create role with policy for EC2 instance to access S3
+AWS Grant access to S3 bucket for EC2 AWS Trusted services
+AWS test S3 Access from EC2 Instance using AWS Cli
+AWS Want to access S3 bucket from EC2 instance without IAM user policy
+AWS revoke system role from EC2 instance
+AWS Error: Unable to Locate credentials.You can configure credentials by running "aws configure"
+AWS - Maintaining versioning file or object inside S3
+AWS S3 upload same file to verify S3 Versioning
+AWS S3 Encryption
+AWS S3 Grant public access to object or file
+AWS - S3 Grant Console access to IAM user
+AWS - S3 Grant specific folder or bucket access to IAM user
+ AWS S3 Static website
+AWS S3 Encryption
+AWS S3 Server side Encryption (SSE-S)
+AWS Key Management Service (KMS)
+AWS S3 Bucket lifecycle policy
+AWS S3 replication in same region or different region
+AWS ELB Create Load Balancer
+AWS Load balancer associate with EC2 instance application
+AWS ELB target group status unhealthy and request timed out
+AWS application server Error Code: INET_E_RESOURCE_NOT_FOUND
+AWS ELB adding more target EC2 instance or application
+AWS EBS add new storage disk to EC2 instance
+AWS EBS Create New Elastic Block Store in the same region as like EC2 instance
+AWS EBS Attach new volume EBS to the EC2 Instance
+AWS EBS mount new volume to the EBS EC2 Instance at Linux level
+AWS EFS Create EFS file system
+AWS EFS mounting the NFS file system to EC2 instance
+AWS EFS mount.nfs4: Connection timed out
+AWS EFS mount.nfs4: mount point efs does not exist
+AWS CloudWatch Metrics
+AWS CloudWatch log - Configure for EC2 instance
+AWS CloudWatch - Create role for cloudwatch to attach to EC2
+AWS CloudWatch - Attach CloudWatch role to EC2 instance
+AWS CloudWatch Log - Install Agent on EC2 instance _
+AWS CloudWatch Log - Verify log goup after agent install in EC2 instance
+AWS CloudWatch - awslogs.log:Error:NoCredentialsError: Unable to locate credential
+AWS CloudWatch - awslogs.log:Error Caught exception: An error occurred PutLogEvents operation
+AWS Cloudwatch log group creation
+AWS CloudTrial
+AWS CloudWatch Alarms
+AWS CloudWatch Events
+AWS CloudWatch Events testing
+AWS VPC
+AWS VPC - Create new VPC using templete lauch VPC wizard
+AWS VPC - Simple VPC creation
+AWS VPC - Create subnet on VPC
+AWS VPC - In Subnet Enable Auto-assign Public IP
+AWS VPC - Create EC2 instance inside Custom VPC
+AWS VPC - Create Internet gateway and assign to VPC instance
+AWS VPC - Create Route Table for VPC
+AWS VPC - Associations Route table with Subnet
+AWS VPC - Grant access to public from route table
+AWS VPC - EC2 instance Internet access via Internet Gateway
+AWS NAT Instances Configuration
+AWS NAT Instance - Create EC2 Instance from AWS AMI image
+AWS NAT - Disable source destination check
+AWS NAT - Create Private EC2 Instance for testing NAT
+AWS VPC NAT - Attach Private Route table with NAT instance
+AWS VPC NAT - Allow ping Protocol in NAT Instance
+AWS VPC Peering - Create Peering b/w VPC's
+AWS VPC Peering - Create VPC
+AWS VPC Peering - Accept the Peering Connection
+ AWS VPC Peering - Attach Route table bw VPCs
+AWS VPC NAT Gateway configuration
+AWS VPC NAT Gateway - Create NAT Gateway
+AWS VPC NAT Gateway - Attach Private Route table with NAT gateway
+AWS VPC Endpoint - Create VPC Endpoint
+AWS VPC Flow log
+AWS Athena - To Analyze s3 logs
+AWS Security Services
+AWS Trusted Advisor Dashboard
+AWS GuardDuty
+AWS Inspector - Get Stared
+AWS Inspector agent install using ssh
+AWS Amazon Inspector - Assessment Templates and Run
+AWS Amazon Inspector - Report findings with download option
GoogleCloud:
+Google - Account creation for Google Cloud
+Google Cloud - Add user to the Project
+Google Cloud - Create New Role
+Google Cloud - Console shell for cmd
+Google Cloud - SDK download and install
+Google Cloud - SDK login or config on windows
+Google Cloud - Create Compute Engine VM
+Google Cloud - Connect to VM putty ssh key
+Google Cloud - VM Install Apache
+Google Cloud - VM add new disk and fstab update
+Google Cloud - VM Instance Template
+Google Cloud - VM Instance group creation
+Google Cloud - Create VM snapshot
+Google Cloud - Creating Snapshot schedule
+Google Cloud - Attach Snapshot Schedule to VM disk
+Google Cloud - Create VM from Snapshot backup
+Google Cloud - Create Load Balancer
+Google Cloud - Create Bucket for storing objects
+Google Cloud - Bucket permission
+Google Cloud - Access Bucket from VM
+Google Cloud - VPC Creation
+Google Cloud - Create VM with private VPC
+Google Cloud - VPC Peeting b/w 2 projects
+Google Cloud -Create firewall rule
+Google Cloud - Attach ssh port Private VPC and VM instance
+Google Cloud - Create Cloud SQL (MYSQL)
+Google Cloud - Verify Cloud SQL (MYSQL) install
+Google Cloud - Verify PostgreSQL Install
+Google Cloud - Cloud Spanner instances creation
+Google Cloud - Cloud Spanner database creation
+Google Cloud - Dataproc Clusters
+Google Cloud - pubsub Create Topic
+Google Cloud - pubsub Create Subscriptions for Topic
+Google Cloud - Create Kubernetes Cluster
+Google Cloud - Kubernetes app deployment - nginx
+Google Cloud - 'kuberctl' is not recognized as an internal or external command
+Google Cloud - gcloud for Kubernetes cluster creation
+Google Cloud - kubectl for Kubernetes app deployment
+ Building Exadata simulation in VM for learning - Part1(install) exadata simulator
+ Standalone Oracle Grid Infrastructure in EXADATA - Part2(install)
+ VM Simulation Exadata Storage Server Version 12.1.2.
+ Uninstall Exadata Storage Server cell in VMware test
+MS_ALERT HUGEPAGE CLEAR Error from io_setup, async ctx
+Flow of Exadata storage and disk details from Physcial,lun,Cell disk and Grid/Flash disk - Part1(storage)
+How to associate Flash and grid disk/log with cell disk - Part2(storage)
+To know relation between Physical disk,Lun,Partition,Cell disk and Gird/Flash Disk - Part3(storage)
+Associating ASM disk group name with Cell disk alias name - Part4(storage)
+ Apply bundle patch in exadata - Eg Patch 17380185 (Patching)
+ Exadata Pricing
+ Create ASM Disk in Exadata using ASMCA
+ RS-7445 service MS with pid 11475 lost 2 heartbeats, try restarting it
+ Exadata : celld service status start stop
+ Exadata bash profile
+ Check hostname setting. Cannot install cell
+ CELL-02018: Internal error detected: Not enough open file descriptors.
+ CELL-02598: Ipaddress/Netmask attribute is not properly configured for interconnection
+ perl(HTML::Entities) is needed by perl-libwww-perl-5.805-1.1.1.noarch.rpm
+ Failed dependencies: libsensors.so.3()(64bit) for net-snmp-5.3.2.2-20.el5.x86_64.rpm
+cellsrv ossmmap_map: mmap failed for SparseV2PhysMap len: as there is insufficient memory
+msStatus stopped : socket open error: Port no: 8888. Received errorno 111. Connection refused
Database:
+Cross platform migration from windows to linux of oracle database
+Restricting TOAD,PLSQL,EXCEL,SQL access from ORACLE App Schema who has DBA Priv
+Create Duplicate role as like DBA role
+SQLPLUS hangs from client server
+ Refresh of PROD database using RMAN duplicate
+Drop database for RAC and NON RAC
+Installing latest version of OPatch
+ORA-12543 due to iptables server firewall.
+Rman backup falis with RMAN-00601 fatal error in recovery manager
+INS-30060 while installing oracle database software
+PRKC-1140 while installing oracle database software
+How to reset the same password for oracle user
+RMAN Backup fails with DBGSQL: TARGET - RMAN-03014 ORA-01008 sqlcode = 1008
+Patch error with genclntsh: Failed to link libclntsh.so.11.1
+OPatch error with wrong stage patch location UtilSession failed: Invalid patch location
+OPatch error with ibclntsh.so.11.1 executables are active
+OPatch warring with ins_precomp.mk overriding commands for target `pcscfg.cfg'
+OPatch warring with ins_srvm.mk:68: warning: overriding commands for target `libsrvm11.so'
+ To calulation ORACLE data guard / standby Bandwidth.
+ Archive log not shiping to standby or datagaurd error ORA 03135 ORA 12152 ORA-16198 ORA-12152 ORA-12592
+Oracle database 12C Documentation reference
+To finding ITL wait hot block objects to increace initrans
+Mlog refresh status and Mlog segment space details
+RAC database installation INFO: PRVF-9652 : Cluster Time Synchronization Services check failed
+FAL[server]: DGID from FAL client not in Data Guard configuration
+v$archive_dest shows BAD PARAM in status column
+PLSQL developer - Initialization error SQL*Net not properly installed OracleHomeKey: OracleHomeDir
+To know the status of sub partition indexes- all_ind_subpartitions status UNUSABLE or N/A in dba_indexes
+ORA-04030: out of process memory when trying to allocate 4032 bytes
+Error RMAN-03002 RMAN-05501 RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed - when using restoring RMAN auxiliary Duplicate db
+ORA-25153: Temporary Tablespace is Empty
+Oracle flashback logs not being deleted
+Recovery Writer (RVWR) is stuck until more space - DR database is not sync error with
+Changing Temp tablespace Location to new RAC ASM disk group
+Changing archive log location LOG_ARCHIVE_DEST_1 and db_recovery_file_dest to the new ASM disk Group
+ORA-01261: Parameter db_create_file_dest destination string cannot be translated
+ORA-13518 Invalid database id ORA-06512 at SYS.DBMS_WORKLOAD_REPOSITORY - dbms_workload_repository.create_snapshot
+Drop and Reinstall AWR
+WRI$_OPTSTAT_HISTHEAD_HISTORY and WRI$_OPTSTAT_HISTGRM_HISTORY are not purged.
+RMAN-03009 ORA-19504 ORA-27040 ORA-27040: file create error, unable to create file
+Clearing Dead-marked for killing session in Oracle
+dbms_stats.gather_table_stats ORA-20000: Unable to analyze TABLE
+PRVF-7532 Package pdksh is missing on node - 11204 installation in RHEL6
+ Oracle - Clean the objects inside the schema for refresh using Import(Impdp).
+Standby logs not applying with warning: Waiting for all non-current ORLs to be archived... Media Recovery Waiting for thread 1 sequence
+How to sync oracle data guard DR with missing archive log in PROD and DR
+Error: ORA-00317: file type 0 in header is not log file ORA-00334
+Oracle 11.2.0.4 installation-Package pdksh-5.2.14 - This is a prerequisite condition to test whether the package "pdksh-5.2.14" is available on the system.
+Setting HugePages for Oracle linux
+PLS-00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared
+RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
+ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified ORA-17629: Cannot connect to the remote database server
+RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
+Migrating oracle Database using RMAN Active Database Duplication from Old dataguard standby server to New dataguard standby server without touching PROD.
+Primary database alertlog giving below error(TNS-12564) for DGMGRL data guard services DBSID_DGB.
+ORA-17503: ksfdopn:2 Failed to open file ORA-15173: entry 'dr1DBSID.dat' does not exist in directory 'brokerfile'
+ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim
+Oracle Connection error : Provider cannot be found.It may not be properly installed
+backup controlfile for standby error with RMAN-03009 ORA-01671: control file is a backup, cannot make a standby control file
+ORA-12801: error signaled in parallel query server ORA-01114 ORA-01114 ORA-29701
+Oracle Data Guard config ORA-16057: server not in Data Guard configuration
+SHUTDOWN: Active processes prevent shutdown operation
+Duplicate database fail with RMAN-04014 ORA-01127: database name '/SIDDEVLOP' exceeds size limit of 8 characters
+PRVF-0002:Could not retrieve local hostname
+Moving datafile form NON ASM to ASM
+ORA-00600 on ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
+Adding multiple oracle datagaurd standby database
+drop logfile group ORA-01624: log 1 needed for crash recovery of instance ORA-00312
+ORA-04030: out of process memory when trying to allocate 4032 bytes (qmxdGetChildNo,qmemNextBuf:alloc)
+TNS-12545 TNS-12560 TNS-00515 Linux Error: 99: Cannot assign requested address
+RHEL 7 : PRVF-7532 : Package "compat-libstdc++-33(x86_64)" is missing on node
+PRVF-0002: could not retrieve local node name
+ORA-00214: control file version inconsistent with file
+ORA-00334 ORA-00353 ORA-00283 ORA-00354: corrupt redo log block header
+oracle runInstaller bash: xclock: command not found...
+IMPDP table import ORA-31693 ORA-29913 ORA-29400 ORA-26059
+ORA-38706 ORA-38788 ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
+alter database backup controlfile ORA-01110 ORA-01187 cannot read from file because it failed verification tests
+DBUA : InitParamAttributes.loadInitParams java.util.NoSuchElementException java.util.StringTokenizer
+TNS-12542: TNS:address already in use TNS-12560 TNS-00512 Linux Error: 98: Address already in use
Monitoring Scripting:
+Tablespace Monitoring and altering through mail when reaches 90%
+Oracle Data guard log gap status monitoring shell script and alerting through mail
+Oracle Alert log monitoring shell script and alerting through mail
+Oracle ASM Disk Group free space/used space monitoring shell script and alerting through mail
+Oracle RMAN Backup job monitoring shell script and alerting through mail
+Oracle User expiry monitoring shell script and alerting through mail
+Oracle Database Lock details status monitoring shell script and alerting through mail
+ORA 12514 Data guard is not in sync with primary
Performance:
+Unix top CPU and Memory
+Sequence to analysis database level performance
+Object which are all accessed and locked
+Tuning BO report of FCUBS which is taking more than 30mins
+Oracle database is hanging or slow in night due to Auto job
+How to disable DEFAULT_MAINTENANCE_PLAN from DBA_SCHEDULER_WINDOWS
+How to make status column to False in DBA_SCHEDULER_WINDOWS
+Oracle to find over sized(fragmented) index whos size is greater than tablesize
+Wait Event:db file sequential reads
+Wait Event: db file scattered reads
+Wait Event: log file parallel write
+Wait Event: log file sync
+Wait Event: buffer busy waits
+Wait Event: free buffer waits
+Wait Event: enqueue waits
+Wait Event: Direct Path Writes
+Wait Event: Latch Free Waits
+Wait Event: Library cache latch
+Wait Event: Shared pool latch
+Wait Event: Row cache objects latch
+ORACLE RAC Performance reference
+ optimizer_skip_scan_enabled performance issue and wrong stats in explain plan
+Oracle database I/O performance issue
GRID/RAC/ASM:
+Deinstall oracle Grid standalone installation after failed instal
+OS Kernal upgrade on RAC ASM system
+PRVF-5184 : check of following Udev attributes
+PRVF-4661 : Found inconsistent hosts entry in /etc/nsswitch.conf
+Rac GRID instal hangs at oracle.cluster.deployment.ractrans.ClientHandlerSupervisor.threadCleanup
+ntcontab.o - Error in Grid control agent instal
+INS 40912 - Rac Grid installation fail with
++11.2 GRID CRS is not starting after rebooting a cluster node: crsctl start has
+Node-2 root.sh fails with CRS-2674
+ASM terminated ORA-00020: maximum number of processes 100 exceeded
+Adding ASM disk group in VM lab
+enq: DD - contention while adding ASM disk and ASM command hangs
+RAC GRID Root.sh ORA-27091 ORA-15081 unable to queue I/O
+oracleasm createdisk marking disk FAILED with Unable to open device Device or resource busy
+ocrcheck PROC-26: Error while accessing the physical storage
+11.2 GRID CRS is not starting after rebooting a cluster node: crsctl start has
+Moving UNDO tablespace to NEW ASM diskgroup in RAC
+Multiplexing control file in ASM
+Changing Redo Log to new disk group in ASM RAC
+Moving RAC database from one disk group to other new ASM disk group
+ORA-15032: not all alterations performed ORA-15063: ASM discovered an insufficient number of disks for diskgroup
APPS DBA: +OS Kernal upgrade on RAC ASM system
+PRVF-5184 : check of following Udev attributes
+PRVF-4661 : Found inconsistent hosts entry in /etc/nsswitch.conf
+Rac GRID instal hangs at oracle.cluster.deployment.ractrans.ClientHandlerSupervisor.threadCleanup
+ntcontab.o - Error in Grid control agent instal
+INS 40912 - Rac Grid installation fail with
++11.2 GRID CRS is not starting after rebooting a cluster node: crsctl start has
+Node-2 root.sh fails with CRS-2674
+ASM terminated ORA-00020: maximum number of processes 100 exceeded
+Adding ASM disk group in VM lab
+enq: DD - contention while adding ASM disk and ASM command hangs
+RAC GRID Root.sh ORA-27091 ORA-15081 unable to queue I/O
+oracleasm createdisk marking disk FAILED with Unable to open device Device or resource busy
+ocrcheck PROC-26: Error while accessing the physical storage
+11.2 GRID CRS is not starting after rebooting a cluster node: crsctl start has
+Moving UNDO tablespace to NEW ASM diskgroup in RAC
+Moving RAC database from one disk group to other new ASM disk group
+ORA-15032: not all alterations performed ORA-15063: ASM discovered an insufficient number of disks for diskgroup
+Oracle Apps dba R12 installation(12.1.1) and database 11.1.0.7
+Oracle apps fresh installation 12.1.1 and upgrade to 12.1.3
+Rapid Install found an already existing /tmp/RapidInstall
+Apps WorkFlow Too many pending requests already exist in the system
+R12 login fails with FND_NO_DATABASE_CONNECTION
+ Oracle Apps ADPATCH interview question and common information's
+ Oracle Apps CONCURRENT MANAGERS basics and information's
+Oracle Apps concurrent managers interview question and common information's
+Oracle Apps 11i and R12 Apps Password
+Manual cloning of appsTier and db tier with out Rapid cloning adcfgclone.pl
+Updating Test Mail ID override address for Workflow Notification Mailer in backend in R12
+Oracle apps Work Flow mailer inbound response - Unable to connect to the mail account. Check the host, user name and password
+R12 Application font, colour, feel and looks different after applying patch
+oracle apps password reset: Too many pending request already exist in the system. Please check your email or contact the system administrator for further assistance.
+RW-50010 Error script has returned an error: 127 RW-50004 Error code received when running external process
+Oracle Apps Information Centers most of useful matalink note
+admerge patch usage
+AutoPatch error: The following ORACLE error: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
+How to invoke admsi.pl before applying patch.
+Checking adpatch worker status using adctrl
+adpatch - An error occurred while generating Oracle Forms library files. Continue as if it were successful
+adpatch FND_INSTALL_PROCESSES table - ORA-00955: name is already used by an existing object
+Oracle apps How to find the adpatch is applied or not
+In the mid of main adpatch you got error for applying pre patch,So How to apply the pre_patch
+oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25002: Definition of type View Definition not found
+adhoc approver in HRMS Errors- oracle.apps.ame.dynamicapprovals.server.ApprovalsAMImpl.addApprover
+adpreclone.pl - java.io.FileNotFoundException: /appsutil/clone/jlib/oui/jlib/Libraries.old
+RC-50014: Fatal: Execution of AutoConfig was failed - java.sql.SQLException: Could not get connection to the database
+RC-50004 AC-00005 No write permissions for creating the Context file /appsutil/temp.xml - perl adcfgclone.pl dbTier
+SYSADMIN Error Login failed. Please verify your login information or contact the system administrator.
+Oracle apps R12 : Login Page is blank
Unix:
+Unix top CPU and Memory
+SUN Solaris performance - basic check commands
+ elfutils-libelf-devel-static-x86_64 = 0.137-3.el5 is needed by elfutils-libelf-devel-
+ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
+Kernel: Device-mapper: table: 253:8: multipath error getting device
+/var/log/messages error with multipathd: asm!.asm_ctl_spec: add path (uevent)
+Iscsiadm how to remove and read add sigle iscsi lun in RHEL
+Linux - /etc/mail/sendmail.cf is changed and mails are not received
+sendmail 354 enter mail end with . on a line by itself
+How to create password less sudo linux user access on RHEL linux
+RHEL xclock command not found
+Starting httpd Address already in use make_sock
+Unix rpm -qa command hangs
+Putty login takes time after entering username
+Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr
+vnc viewer connect:A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call no address was supplied 10057
+Datasource java.sql.SQLException ORA-28040 No matching Authentication protocol DRSA0010E
+umount lsof: WARNING: can't stat() cifs file system /mnt
+mount cifs -bash: !,uid=,gid=: event not found
+Open a port in RHEL Linux
MYSQL:
+ MYSQL PROD to DR replicaiton(master - slave) setup for high avaliablity
+ MYSQL : [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.
+MYSQL:mysqldump: Error: Binlogging on server not active
+MYSQL: [Warning] Using a password on the command line interface can be insecure.
+MYSQL ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
+MYSQL : ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
+MYSQL: Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs
MISC:
+FCUBS Blank page after login
+Creating read write user for non FCUBS
+Create read only user access for non FCUBS
+Error:Failure of server APACHE bridge:No backend server available for connection: timed out after 10 seconds or idempotent set to OFF.
+Unable to open the weblogic admin console problem in launching weblogic console - Page was not found
+Error: A connection attempt failed because the connected party did not properly respond after a period of time
+Creating read write user for non FCUBS
+Create read only user access for non FCUBS
AWS:
+AWS IAM (Identity And Access Management)
+Install AWS Cli on Windows
+AWS Getting Access key ID and Secret access key for a User.
+Configure AWS Cli with Access key ID and Secret access key
+AWS CLI Create user
+AWS CLI - Add user to a group
+AWS CLI - Attach Policy to User
+AWS CLI - Delete or revoke Policy to User
+AWS - Reset IAM user password
+AWS - Create New EC2 Instance
+AWS Connect to EC2 Instance using Putty
+AWS EC2 - Putty Network Error : Connection timeout
+AWS Create Role
+Attach a Role to EC2 instance
+AWS - AMI User - Assign permission to access EC2 services
+AWS EC2 AMI - Copy the Image to different region
+AWS EC2 AMI golden image creation
+AWS grant IAM user with Marketplace access
+AWS Marketplace testing IAM user access
+AWS Marketplace share the AMI Image
+AWS Create S3 Bucket
+AWS Create role with policy for EC2 instance to access S3
+AWS Grant access to S3 bucket for EC2 AWS Trusted services
+AWS test S3 Access from EC2 Instance using AWS Cli
+AWS Want to access S3 bucket from EC2 instance without IAM user policy
+AWS revoke system role from EC2 instance
+AWS Error: Unable to Locate credentials.You can configure credentials by running "aws configure"
+AWS - Maintaining versioning file or object inside S3
+AWS S3 upload same file to verify S3 Versioning
+AWS S3 Encryption
+AWS S3 Grant public access to object or file
+AWS - S3 Grant Console access to IAM user
+AWS - S3 Grant specific folder or bucket access to IAM user
+ AWS S3 Static website
+AWS S3 Encryption
+AWS S3 Server side Encryption (SSE-S)
+AWS Key Management Service (KMS)
+AWS S3 Bucket lifecycle policy
+AWS S3 replication in same region or different region
+AWS ELB Create Load Balancer
+AWS Load balancer associate with EC2 instance application
+AWS ELB target group status unhealthy and request timed out
+AWS application server Error Code: INET_E_RESOURCE_NOT_FOUND
+AWS ELB adding more target EC2 instance or application
+AWS EBS add new storage disk to EC2 instance
+AWS EBS Create New Elastic Block Store in the same region as like EC2 instance
+AWS EBS Attach new volume EBS to the EC2 Instance
+AWS EBS mount new volume to the EBS EC2 Instance at Linux level
+AWS EFS Create EFS file system
+AWS EFS mounting the NFS file system to EC2 instance
+AWS EFS mount.nfs4: Connection timed out
+AWS EFS mount.nfs4: mount point efs does not exist
+AWS CloudWatch Metrics
+AWS CloudWatch log - Configure for EC2 instance
+AWS CloudWatch - Create role for cloudwatch to attach to EC2
+AWS CloudWatch - Attach CloudWatch role to EC2 instance
+AWS CloudWatch Log - Install Agent on EC2 instance _
+AWS CloudWatch Log - Verify log goup after agent install in EC2 instance
+AWS CloudWatch - awslogs.log:Error:NoCredentialsError: Unable to locate credential
+AWS CloudWatch - awslogs.log:Error Caught exception: An error occurred PutLogEvents operation
+AWS Cloudwatch log group creation
+AWS CloudTrial
+AWS CloudWatch Alarms
+AWS CloudWatch Events
+AWS CloudWatch Events testing
+AWS VPC
+AWS VPC - Create new VPC using templete lauch VPC wizard
+AWS VPC - Simple VPC creation
+AWS VPC - Create subnet on VPC
+AWS VPC - In Subnet Enable Auto-assign Public IP
+AWS VPC - Create EC2 instance inside Custom VPC
+AWS VPC - Create Internet gateway and assign to VPC instance
+AWS VPC - Create Route Table for VPC
+AWS VPC - Associations Route table with Subnet
+AWS VPC - Grant access to public from route table
+AWS VPC - EC2 instance Internet access via Internet Gateway
+AWS NAT Instances Configuration
+AWS NAT Instance - Create EC2 Instance from AWS AMI image
+AWS NAT - Disable source destination check
+AWS NAT - Create Private EC2 Instance for testing NAT
+AWS VPC NAT - Attach Private Route table with NAT instance
+AWS VPC NAT - Allow ping Protocol in NAT Instance
+AWS VPC Peering - Create Peering b/w VPC's
+AWS VPC Peering - Create VPC
+AWS VPC Peering - Accept the Peering Connection
+ AWS VPC Peering - Attach Route table bw VPCs
+AWS VPC NAT Gateway configuration
+AWS VPC NAT Gateway - Create NAT Gateway
+AWS VPC NAT Gateway - Attach Private Route table with NAT gateway
+AWS VPC Endpoint - Create VPC Endpoint
+AWS VPC Flow log
+AWS Athena - To Analyze s3 logs
+AWS Security Services
+AWS Trusted Advisor Dashboard
+AWS GuardDuty
+AWS Inspector - Get Stared
+AWS Inspector agent install using ssh
+AWS Amazon Inspector - Assessment Templates and Run
+AWS Amazon Inspector - Report findings with download option
GoogleCloud:
+Google - Account creation for Google Cloud
+Google Cloud - Add user to the Project
+Google Cloud - Create New Role
+Google Cloud - Console shell for cmd
+Google Cloud - SDK download and install
+Google Cloud - SDK login or config on windows
+Google Cloud - Create Compute Engine VM
+Google Cloud - Connect to VM putty ssh key
+Google Cloud - VM Install Apache
+Google Cloud - VM add new disk and fstab update
+Google Cloud - VM Instance Template
+Google Cloud - VM Instance group creation
+Google Cloud - Create VM snapshot
+Google Cloud - Creating Snapshot schedule
+Google Cloud - Attach Snapshot Schedule to VM disk
+Google Cloud - Create VM from Snapshot backup
+Google Cloud - Create Load Balancer
+Google Cloud - Create Bucket for storing objects
+Google Cloud - Bucket permission
+Google Cloud - Access Bucket from VM
+Google Cloud - VPC Creation
+Google Cloud - Create VM with private VPC
+Google Cloud - VPC Peeting b/w 2 projects
+Google Cloud -Create firewall rule
+Google Cloud - Attach ssh port Private VPC and VM instance
+Google Cloud - Create Cloud SQL (MYSQL)
+Google Cloud - Verify Cloud SQL (MYSQL) install
+Google Cloud - Verify PostgreSQL Install
+Google Cloud - Cloud Spanner instances creation
+Google Cloud - Cloud Spanner database creation
+Google Cloud - Dataproc Clusters
+Google Cloud - pubsub Create Topic
+Google Cloud - pubsub Create Subscriptions for Topic
+Google Cloud - Create Kubernetes Cluster
+Google Cloud - Kubernetes app deployment - nginx
+Google Cloud - 'kuberctl' is not recognized as an internal or external command
+Google Cloud - gcloud for Kubernetes cluster creation
+Google Cloud - kubectl for Kubernetes app deployment
+ Sec - Security
No comments:
Post a Comment