If you don't have the right ORACLE_SID ("oraXE") you may get an "ORA-12560: TNS:protocol adapter error". Sqlplus /nolog : start the sqlplus client, the "/nolog" is to not be prompted for username/password.Ĭonnect / as sysdba : authenticate through the operating system with sysdba privileges. Sql>startup nomount pfile=C:\oraclexe\app\oracle\admin\oraXE\pfile\initoraXE.ora You can now authenticate through the operating system (no login or password) to start up the database, like this:
Undo_management: this parameter is used for choosing between automatic undo management (AUTO) or manually undo management (MANUAL, this is the default) in the latter is needed to create, size and monitor closely undo (rollback) segments, it's recommended to be set to AUTO.ĭb_name : The database name must be the same used in the create statement.ĭb_block_size : The default or standard database block size, this is the mininal logical unit of storage in oracle this should be a multiple of the operating system block size.īefore you try to connect to start the instance check that you have the right ORACLE_SID: In this case there are three files copies, its recommended to store each copy on different physical disk which is called multiplexing. This are just some basic initial parameters, the ones that are not specified are taken by default.Ĭontrol_files = (C:\oraclexe\oradata\oraXE\control01.ctl,Ĭontrol_files : Here we define where will be our control files, those are used for store management information of the database like location of the datafiles, timestamp of the creation of the database,etc. 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
Create database manually in oracle 10g password#
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.
Create database manually in oracle 10g windows#
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.ģ.
0 kommentar(er)
