DBA OCP | Database Engineer | Developer (MS Access,Wordpress)
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…
Background: Generally we use ctrl+c to quit any task in windows command prompt or ctrl+z in Unix flavors. For oracle data pump exports/imports this is not the case when you type any of them, ctrl+c or ctrl+z actually pause the job and closing the command or shell window doesn’t quit the oracle data pump job…
Background: Taking regular backups for database is crucial to recover from any disaster or from accidental operations on database by its users. Backups in Oracle Database can be taken in two ways one is physical and other is logical. Export/Export Dump is a kind of logical backups that could be taken in oracle databases. We…