Oracle what does sid stand for

Connect and share knowledge within a single location that is structured and easy to search. Not strictly true. Oracle considers the "Database" to be the files. What's going on?! You can specify multiple services names in order to distinguish among different uses of the same database. For example:. You can also use service names to identify a single service that is available from two different databases through the use of replication.

I just thought I'd leave this here as it's mildly relevant to the question and can be helpful when attempting to weave around some less than clear idiosyncrasies of oracle networking.

In case if the above link is not accessable in future, At the time time of writing this answer, the above link will direct you to, "Database Service and Database Instance Identification" topic in Connectivity Concepts chapter of "Database Net Services Administrator's Guide".

This guide is published by oracle as part of "Oracle Database Online Documentation, 10g Release 2 SID is a unique name for an Oracle database instance. ORA file. Also known as System ID. Stack Overflow for Teams — Collaborate and share knowledge with a private group. It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. I've searched this topic in Google and there are several information, but it makes me confused more..

Database is just storage that user applications' data is stored. When instance runs, it access to DB, mount the control files, open the data files and redo logs. It is a collection of the files datafile, controlfile, redo log, tempfile, block change tracking file, etc. Typically one instance belongs to one database, but a RAC database can have multiple instances on multiple nodes. SID identifies the instance by the name.

Note that it is not a strictly unique identifier, multiple instances can exist on the same server with the same name, running from different Oracle Homes. Sign up to join this community. The best answers are voted up and rise to the top. Questions What is a SID, how to change it, how to find out what it is.

Question and Answer. Ganesh, June 17, - am UTC. It is amaizing how much mechanical work is required for simple things in oracle. Relational Model is about normalisation; or to put it simply, no redundant data. What we see here: an SID in dosen of places?

September 13, - pm UTC. The simple thing here is -- don't change the SID. The database is a relational model -- the software that runs it, well, its not. The primary key of the database is the SID. If you ever update your primary key value -- you have to do the same thing find all of the foreign keys and update them as well. How long should this take frank, September 14, - am UTC.

I tried something similar to copy a 70G db. Didn't want to exp-imp. September 14, - am UTC. Thanks, Tom February 22, - am UTC. How did you connect in the first place? Liz, March 01, - pm UTC. Excellent description of changing a sid.

I did that all the time at a previous job to create test instances. I found the why a sid portion to fascinating. It was how to find out a sid portion that got me wondering. If you don't know the sid, how did you connect to the instance to ask it what it's sid is? March 01, - pm UTC. On NT, look at the list of Oracle services in control panel.

Fenng, August 20, - am UTC. It's so cool. But don't know if it's fit for Oracle9i. August 20, - am UTC. Thanks Mr. March 20, - am UTC. You have no existing control files -- no binary backups, no "backup to trace"? Then the only tool you need is vi or your favorite text editor.

I don't understand "backing up the spfile or pfile" in this context though? No, you don't need to back them up -- they are what tell Oracle where to find the controlfiles - where to put them when you do the create controlfile. So could you explain the question in the title?

I can set it to any value and still be able to bring up the database even the the instance SID is totally different.

Is it used for OPS? I need a clue. June 20, - pm UTC. In a cluster, if all of the instances of Oracle running had the same sid, you might want to name each instance differently so you could tell which one you were connected to or to make connecting to a specific instance possible. Tom, Can you please validate the following procedure to do the cloning of a open database?

Take a hot backup of all the datafiles 2. Transfer the datafiles and archive logs to the new server. Get the control file to trace. Edit the parameters for as for normal cloning. In the new init. June 30, - am UTC. Hi Tom: Look forward to your sessions at the Oracle World August 13, - am UTC. August 13, - pm UTC. I'm feeling tidly winky now Hi Tom: On the serious side of things I meant for cloning on 9i Rel 2 or earlier versions.

A reader, August 13, - pm UTC. Hi Tom, I try to understand that: I create a clone database; but at the time to restore datafiles, one or more datafiles are read-only r--r--r-- on UNIX ; this a bug of the backup software. What happens precisely inside Oracle? What checks are made, in which files control files, datafiles? I tried to dump files at each step, but can't understand. Thanks for your help. October 15, - pm UTC. I'll try to be more precise and to not forget any crucial information: here are the steps: 1.

Viewed k times. Thanks Michael. Improve this question. Add a comment. Active Oldest Votes. Improve this answer. Cheers, Paul. SID is instance. Better avoid using the term 'database instance', just instance. Bernaridho Bernaridho 1. It describe the whole picture in thoroughly.