DBA OCP | Database Engineer | Developer (MS Access,Wordpress)
Background: Amazon EC2 instance assigned with a public and private ip address. The public ip address changes when the instance stopped and started again but not when the instance restarted. Due to this nature service is prone to interruption if the instance stopped for maintenance and started again. Workaround: Amazon offers the Elastic IP for…
Background: WordPress is currently the most popular platform for creating websites. One can build his website in WordPress on shared hosting service or in dedicated servers. Both means have their advantages and disadvantages, like when you use shared hosting service you have your environment ready, you will only work in your website/blog having little control…
After you have launched your Amazon EC2 Linux instance it’s time to connect to it. You can connect it through a standalone SSH client like BitVise SSH client or PuTTY. Here we will use bitvise SSH client to connect to EC2 Linux installation. Requirements: Private Key file(.pem) downloaded during Launch of your EC2 instance. …
Developing or deploying applications over cloud infrastructure made life easy for the professionals. Amazon public cloud offers computing solution named as EC2 which is easy to deploy with the options to select from a pool of operating systems. Amazon cloud services are offered in a wide variety of price ranges from low to high. On…
Background For the IGW application testbed preparation we need the schema export and then be imported. When export initiated by Data Pump EXPDP the oracle error showed up. UDE-22303: operation generated ORACLE error 22303 OCI-22303: type “SYS”.”KU$_STATUS1020″ not found Workaround Upon investigating in the alert log file the below lines are showing up indicating a…
Background: After shutdown and restarted the oracle instance by an executive, client can’t connect to database instance though database is up and running and listener service is up. OS: Windows Server 2012 x64, Oracle: 11g R2, Data Guard Configured Workaround: From the alert_SID.log file found the below error raised after shutdown and consecutive startup and when…
Background: All of a sudden importing data from spreadsheet in a form produced the above error(it was tested and worked fine over two weeks), the same operation in another form is executing fine. This is bit frustrating when everything seems fine, no errors in logic or elsewhere but things are not working. Solution: Digging down further…