oracle 手工建库解决办法
oracle 手工建库
1 .C:\Users\Administrator>oradim -new -sid xydyfy -pfile D:\oracle\admin\xydyfy\pfile\initXYDYFY.ora - startmode auto
实例已创建。
2 .C:\Users\Administrator>set oracle_sid =xydyfy
3 .C:\Users\Administrator>orapwd file =D:\oracle\admin\xydyfy\password\PWDxydyfy.ora password=oracle
Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n> nosys
dba=<y/n>
where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA,
force - whether to overwrite existing file (opt),
nosysdba - whether to shut out the SYSDBA logon (opt for Database Vault only
).
There are no spaces around the equal-to (=) character.
问题:问什么老提示orapwd 的格式呢? 大侠们分析分析!
补充: 我系统win 7 32位,我装的也是32位oracle 10g
个人经历:我记得上次我从装oracle时,把oracle自带的orcl 实例也一起装上了,自己从新建库时在orapwd 的地方顺利通过。
------解决方案--------------------
orapwd file =D:\oracle\admin\xydyfy\password\PWDxydyfy.ora password=oracle
把 file =d之间的空格去掉
------解决方案--------------------
------解决方案--------------------
有空格就成两个参数了。
------解决方案--------------------
There are no spaces around the equal-to (=) character.
提示中说的很清楚么!
1 .C:\Users\Administrator>oradim -new -sid xydyfy -pfile D:\oracle\admin\xydyfy\pfile\initXYDYFY.ora - startmode auto
实例已创建。
2 .C:\Users\Administrator>set oracle_sid =xydyfy
3 .C:\Users\Administrator>orapwd file =D:\oracle\admin\xydyfy\password\PWDxydyfy.ora password=oracle
Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n> nosys
dba=<y/n>
where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA,
force - whether to overwrite existing file (opt),
nosysdba - whether to shut out the SYSDBA logon (opt for Database Vault only
).
There are no spaces around the equal-to (=) character.
问题:问什么老提示orapwd 的格式呢? 大侠们分析分析!
补充: 我系统win 7 32位,我装的也是32位oracle 10g
个人经历:我记得上次我从装oracle时,把oracle自带的orcl 实例也一起装上了,自己从新建库时在orapwd 的地方顺利通过。
------解决方案--------------------
orapwd file =D:\oracle\admin\xydyfy\password\PWDxydyfy.ora password=oracle
把 file =d之间的空格去掉
------解决方案--------------------
------解决方案--------------------
有空格就成两个参数了。
------解决方案--------------------
There are no spaces around the equal-to (=) character.
提示中说的很清楚么!