Tag Archives: Oracle DBA Tips and Tricks

How to change the SID of an Oracle XE instance

When you install oracle database 11g express, by default its SID name is set to XE. If you want to change your existing SID from XE to your SID, follow below steps to get it done. Take backup of your oracle database before doing all such things. I have tested this on Oracle database 11g

Fixed: Oracle not started-ORA-16038, ORA-19809, ORA-00312 error

Oracle Error

Oracle Error Description: When you try to startup your database and it fails with the error code ORA-16038, ORA-19809, ORA-00312. Just follow the below mentioned procedure to get the solution of above problem. SQL> startup ORACLE instance started. Total System Global Area 178792260 bytes Fixed Size 2116288 bytes Variable Size 218440552 bytes Database Buffers 42943340

Siteground SALE
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)