Administration

How to Move Oracle Database

Posted on
Actually, this topic “How to Move Oracle Database” follows my previous post: How to Move ORACLE HOME. But I think it can be used in any moving operations. Generally speaking, this post will include the following subtle topics: How to move spfile How to move control files How to move database files How to move […]
Oracle Home

How to Move ORACLE HOME

Posted on
Allow me to ask you a question before going further: why would you like to move ORACLE HOME to another place? You may leave your comment below this post, I am curious about it. As for me, it’s because my client like old-fashioned file structure and don’t like Optimal Flexible Architecture (OFA) to be used, […]
Shell Script

How to Auto Start Oracle Database on Solaris

Posted on
By default, Oracle software installation does not deploy startup and shutdown init scripts on the platform, you have to create them by yourself. Here I introduce my scripts for you to use or modify with. Turn on startup option in oratab Please change the startup option to “Y” at the last character of the line. […]
Shell Script

How to Auto Start Oracle Database on Linux

Posted on
By default, Oracle software installation does not deploy automatic startup and shutdown init scripts on the platform, you have to create them by yourself. Here I introduce my scripts for you to use or modify with. Turning on startup option in oratab Please change the startup option to “Y” at the last character of the […]