Open a text editor, add the lines below and save it as initoraXE.ora in C:\oraclexe\app\oracle\admin\oraXE\pfile\. Important : Remember to stop the default service for the "XE" database which is called "OracleServiceXE" and start the service just created "OracleServiceoraXE" for our new database in the services console. Oradim -new -sid %ORACLE_SID% -intpwd passwordhere -startmode M
Also a password file is created under database directory (ORACLE_HOME\database) with the SID embedded in the name (PWDoraXE.ora), this password file is used to authenticate the DBA before starting an instance. Since could be more than one oracle instance running, oracle uses the SID to difference them.Įvery instance on windows requires a windows service which can be created using oradim tool, the created service can be checked in the services list: type services.msc in the console or a link can be found in the control panel -> admin tools -> Services. Using the this command we declare the variable for oracle SID.
Under the admin directory (C:\oraclexe\app\oracle\admin\) we have to create the structure for the new database (this is called OFA Oracle Flexible Arquitecture), the directory is called oraXE which will be the name of the database, and the directories adump, bdump, cdump, dpdump, pfile, udump are created in it: Create a windows service and password file There are two ways for creating an Oracle database, one is using Oracle Database Configuration Assistant and the other is manually, I'll provide a small step by step guide for the latter on windows XP.ģ.