| Oracle 10g Install on Windows - password file [message #235038] |
Thu, 03 May 2007 17:03  |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
Hi,
I wanted to know when you run the oradim it creates a password file for you, right? Because when I looked in the
C:\oracle\product\10.2.0\db_1\database directory I found the password file (PWDsid.ora) there. So why do some people say that you should create another password file after that using the orapwd utility?
The command that I ran was as follows:
C:\oracle\product\10.2.0\db_1\BIN>oradim -new -sid fprccat -intpwd <password> -maxusers 300 -STARTMODE MANUAL -PFILE C:\oracle\admin\fprccat\pfile\initFPRCCAT.ora
|
|
|
|
|
|
| Re: Oracle 10g Install on Windows - password file [message #235041 is a reply to message #235039] |
Thu, 03 May 2007 17:30  |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
Yes I know it creates a service for you. But specifically, what does the -INTPWD parameter do in the oradim command?
>>oradim is used to create a service in windows environment. It will
use an existing passwordfile.
What if it is a fresh install with a new database? Meaning, there is not existing password file.
Thanks
|
|
|
|
| Re: Oracle 10g Install on Windows - password file [message #235043 is a reply to message #235041] |
Thu, 03 May 2007 17:48 |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
Please let me know if these instructions make any sense. I am following notes from a Sr. DBA.
================
Create instance (Windows service) and password file
On Windows, you must create the appropriate service before you build the database. This is done by the oradim command. It is also important in Windows to create the password file, using ORACLE_HOME\bin\orapwd. Sometimes you can get away with not doing this in Unix and Linux, although the password file will be generated “behind the scenes.”
Run oradim to create Windows service OracleServicerctest:
D:\>D:\oracle\product\10.2.0\db_1\bin\oradim -new -sid rctest -intpwd <oracle_password> -maxusers 300 -STARTMODE MANUAL -PFILE D:\oracle\admin\rctest\pfile\initrctest.ora
Instance created.
NOTE: The service created is left in manual start mode until the database is created, and any needed user data is imported. This is for convenience.
Create oracle connect users password file: D:\oracle\product\10.2.0\db_1\database\PWDrctest.ora
D:\> D****** entries=20 force=y
D:\>dir D:\oracle\product\10.2.0\db_1\database\*.ora
08/09/2006 01:11 PM 3,584 PWDrctest.ORA
1 File(s) 3,584 bytes
0 Dir(s) 59,970,793,472 bytes free
NOTE: This creates a password file, PWDrctest.ORA, in ORACLE_HOME\database, with 300 maximum users, all with the password specified (“<oracle_password>”). You may not want all your users to have the same password. You can override this setting from the command line for each individual user after database creation, or specifically in CreateUsers_rctest.sql.
|
|
|
|
| Re: Oracle 10g Install on Windows - password file [message #235044 is a reply to message #235041] |
Thu, 03 May 2007 17:49 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
You are mixing up versions.
I do not see an INTPWD option in 10g (10g Release 2 (10.2) I just looking up docsets. I do not run oracle on windows and cannot test it).
In 9i, you do have such an option and as per doc (again)
-INTPWD password is the password for the new instance. This is the password for the user logged in with SYSDBA privileges. Option -INTPWD is not required. If you do not specify it, then operating system authentication is used, and no password is required.
>>What if it is a fresh install with a new database? Meaning, there is not existing password file.
Already answered it.
First lookup why you need a passwordfile. If you intent to use one, create one!.
[Updated on: Thu, 03 May 2007 17:51] Report message to a moderator |
|
|
|
| Re: Oracle 10g Install on Windows - password file [message #235045 is a reply to message #235043] |
Thu, 03 May 2007 17:53 |
|
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Did you miss this? The Author notes to create password file with ORAPWD
| Quote: | This is done by the oradim command. It is also important in Windows to create the password file, using ORACLE_HOME\bin\orapwd
|
And
>> D:\> D****** entries=20 force=y
Seems this truncated/masked line/code is the one to create a passwordfile. The paramaters used (entries and force) are valid ORAPWD paramters.
[Updated on: Thu, 03 May 2007 17:56] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Oracle 10g Install on Windows - password file [message #235049 is a reply to message #235047] |
Thu, 03 May 2007 18:23 |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
|
No I did not use DBCA. Our Sr. DBA doesn't like to use it as he bleives it creates a lot of unnecessary schemas and other things. He always customizes his db creation scripts, so that is what I am doing. All I have to do is change the database name and some directory paths and the rest is the same as his scripts. So it is easier for me.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
