OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » sid

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sid [message #149789]

Mon, 05 December 2005 00:13

risy_s
Messages: 44
Registered: September 2005
Location: Mumbai

Member

hello everybody...

i want to create a sid. named xyz in my database what is the command for this..?

it this command work

c:\oradim -new -sid xyz

help me
Rushikesh

Report message to a moderator

Re: sid [message #149799 is a reply to message #149789]

Mon, 05 December 2005 00:34

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

It is the command and if you have tried help from your machine then you would have got everything.

Just write

 oradim

on your command prompt and it will give you everything.

Report message to a moderator

Re: sid [message #149817 is a reply to message #149799]

Mon, 05 December 2005 02:42

risy_s
Messages: 44
Registered: September 2005
Location: Mumbai

Member

thakns tarun
kindly reply me about this

if i want to create new sid named XYZ in my running database named ABC is it possible....??

which command should i prefer

c:\>oradim -new -sid XYZ
OR
c:\>oradim -new sid XYZ -pfile c:\oracle\oradata\ABC\pfile\init.ora

kindly reply me asap
rushikesh

Report message to a moderator

Re: sid [message #149828 is a reply to message #149817]

Mon, 05 December 2005 03:40

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

If you are thinking to rename a database then its a total different concept.

Read the docs for renaming a database.

Report message to a moderator

Re: sid [message #149856 is a reply to message #149828]

Mon, 05 December 2005 06:21

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

As said,
read the documentation and understand what you are about to do and
also look into utility nid

oracle@mutation#nid
DBNEWID: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

Keyword     Description                    (Default)
----------------------------------------------------
TARGET      Username/Password              (NONE)
DBNAME      New database name              (NONE)
LOGFILE     Output Log                     (NONE)
REVERT      Revert failed change           NO
SETNAME     Set a new database name only   NO
APPEND      Append to output log           NO
HELP        Displays these messages        NO

Report message to a moderator

Previous Topic:	server crash scenario
Next Topic:	what is the results meaning that select server from v$session ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 13:25:02 CST 2025