Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you how to use the oradim command. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Create a new instance service: oradim-new-sid orcl-pfile pfilelujing

Delete an instance service: oradim-delete-sid orcl

Under Windows, 10g and 11g may coexist, and their sid is still the same. At this point, you need to use the oradim command to create an instance to serve the database. Now there are two databases under windows 2003, a database of 10.2.0.5.0, ORACLE_SID=orcl. Another database of 11.2.0.4.0, ORACLE_SID=orcl is currently running an 11g database. Due to business needs, we now need to open a 10g database. By viewing the service, we can see that the database of the current service is 11g (figure). Log in to computer Management-Services and applications-Services-find OracleServerorcl- double-click-View the path to the executable

We need to delete this instance with the $ORACLE_HOME/bin/oradim command of 11g because the path of $ORACLE_HOME/bin of 11g has been written to the system's environment variable. So you can simply delete Oradim-delete-sid orcl

Log in to 10g $ORACLE_HOME/bin and use the 10g oradim command to create an instance service (10g) e:cd E:\ oracle\ product\ 10.2.0\ db_1\ binoradim-new-sid orcl-pfile E:\ oracle\ product\ 10.2.0\ db_1\ database\ initORCL.ora We can see that the new service is 10g

Still under the 10g bin path, log in to the database using 10g sqlplus and check the version number of the current database. You can see that the corresponding data file is 10g data file sqlplus / as sysdba;SQL > select * from v$version.

Delete the instance service of 10g and delete it under the bin of 10g. It can be seen that in the computer-managed service, the instance service just created has been deleted. Oradim-delete-sid orcl

The above is the use of the oradim command shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.