Could some body guide me how to create a database
manually on windows 2000.
How can i set the password for "internal" account
when i am creating a database manually on WIN2000.
Is password for INTERNAL account is mandatory on WIN2000.
When ur installing oracle software it will ask do u want to create a database,say no and after sucessfully installing oracle.Then use oradim utility to create a service.Make a entry of this in the registry i.e oracle_sid=orcl.
Then connect to svrmgrl as internal and start the database in nomount stage.
Then execute the create database command.
This will create a new database for u.
hi anand thanx
could u pls give me the exact syntax of orodim utility with and example.
oradim /? gives the output:
DIM-00002: Valid commands are: -DELETE, -EDIT, -NEW, -STARTUP, and -SHUTDOWN
Please enter one of the following command:
Create an instance by specifying the following parameters:
-NEW -SID sid | -SRVC service [-INTPWD password] [-MAXUSERS number] [-STARTMODE a|m] [-PFILE file] [-TIMEOUT secs]
Edit an instance by specifying the following parameters:
-EDIT -SID sid [-NEWSID sid] [-INTPWD password] [-STARTMODE auto|manual] [-PFILE filename]
[-SHUTMODE a|i|n] [-SHUTTYPE srvc|inst|srvc,inst] [-TIMEOUT seconds]
Delete instances by specifying the following:
-DELETE -SID sid | -SRVC service name
Startup services and instance by specifying the following parameters:
-STARTUP -SID sid [-USRPWD password] [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename]
Shutdown services and instance by specifying the following parameters:
-SHUTDOWN -SID sid [-USRPWD password] [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE a | i | n]
Query for help by specifying the following parameters: -? | -h | -help
An example of creation of a service:
C:\Oracle\Ora81\bin\oradim -new -sid ORCL -intpwd internal -startmode auto -pfile C:\Oracle\Ora81\admin\orcl\pfile\initORCL.ora
Click Here to Expand Forum to Full Width