| oradim problem [message #146994] |
Tue, 15 November 2005 03:11  |
ashuj20
Messages: 12
Registered: October 2005
Location: new delhi
|
Junior Member |
|
|
Hi,
i am using th following command to create a new service on win 2000 to clone a database ,but this command hang on for a long time and creates no service on win2000
oradim -new -sid <NEW_SID> -intpwd <password> -startmode auto -pfile <path_name>
can someone help me finding to reason
thanks in advance
Ashish
|
|
|
|
|
|
| Re: oradim problem [message #147128 is a reply to message #146994] |
Tue, 15 November 2005 20:04  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Starting and Stopping Oracle on Windows with oradim
The dbstart and dbstop shell scripts do not exist on Windows platforms. Consequently Oracle database startup and shutdown is implemented completely differently. The oradim utility provides more than just the ability to start and stop Windows databases. Windows oradim can create and edit databases. It also allows DBAs to configure script-based installation mechanisms.
The oradim utility is used on the Windows platform to perform these tasks.
C:\oracle9i\bin\oradim -startup -sid ORCL92 –usrpwd manager
-starttype SRVC,INST -pfile C:\oracle9i\admin\ORCL92\pfile\init.ora
• startup – Indicates that the specified instance should be started.
• sid – The SID of the database to start.
• usrpwd – The password for the database user.
• starttype – Specifies whether to start the instance, the service, or both
The following command can be used to shutdown the instance with oradim:
C:\oracle9i\bin\oradim -shutdown -sid ORCL92 -shutttype SRVC,INST –shutmode A
Notice that no password is needed to perform this task.
The shuttype parameter specifies what is to be stopped – the service (SRVC), the instance (INST), or both (SRVC, INST). The shutmode specifies the method that should perform the shutdown – (A)bort, (I)mmediate, or (N)ormal.
Each operation, regardless of success, is logged in the oradim log file.
[Updated on: Tue, 15 November 2005 20:06] Report message to a moderator |
|
|
|
|
|
| Re: oradim problem [message #147350 is a reply to message #147303] |
Thu, 17 November 2005 06:02 |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
| Quote: |
oradim -new -sid <NEW_SID> -intpwd <password> -startmode auto -pfile <path_name>
|
You have only posted the syntax of the oradim utility, what parameters have you actually used?
Jim
|
|
|
|
| Re: oradim problem [message #147461 is a reply to message #146994] |
Thu, 17 November 2005 12:51 |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Jim,
I am sorry, I do not use oradim so I can not say which parameters we use. We are a Solaris shop.
Thanks for understanding.
Neil.
|
|
|
|
|
|
| Re: oradim problem [message #147655 is a reply to message #146994] |
Fri, 18 November 2005 16:40 |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi
Is your issue resolved.....let me know.
Tell me which version of oracle are you using.....
Have you set the path for your oracle home......
when you are specifying pfile option.....make ensure that init parameter file is existing at proper location.
you can do any of the following thing
1) at your dos prompt first type the command before u type oradim command at command prompt
c:> set oracle_Sid= sid name
here sid name is your service name....
after typing the above command then type your oradim command
2)Go to your oracle directory location under that change to bin
directory and try your oradim command
eg e:\oracle\bin>oradim........
if above dosen't work then pls send me a oradim log file for error which is stored in oracle\database folder
Regards
Dilip
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
I think you gave a fairly valid post, in that you gave the op more info on the OraDim utility. (I don't really use it much myself) My post was directed at the OP, who has not posted the actual code the he/she uses, but rather the generic syntax of the OraDim utility. It would be more useful if the op posted the actual code that they were using. 