Assuming that you have done the following items: OPatch utility has been replaced with the newest one. The bundle patch p33575656 (220.127.116.11.220118) we're going to… Read More »How to Patch Oracle Database 19c on Windows (33575656)
Extract Oracle Home 19.3 Image Since release 18c, all database software installation packages become image-based to reduce installation time, so we start the procedure from… Read More »How to Install Oracle Database 19c on Windows
Connected to an idle instance Actually, Connected to an idle instance is a message rather than an error, it indicates that the database you entered… Read More »How to Resolve "Connected to an idle instance"
After our Oracle database 12.2 has been created on Windows server, we should open port 1521 on firewall for incoming connections. For Linux, you can… Read More »How to Open Port 1521 on Windows Server
The goal in this post is to install an Oracle database 12.2 on windows server 2012. Here we separate our job into 2 major steps:… Read More »How to Install Oracle Database 12.2 on Windows Server
In my case, I plan to use SPFILE to startup the database instance which used to use a known PFILE to open. But the problem… Read More »How to Point to SPFILE in PFILE to Trick Scripts