In an immediate shutdown, Oracle Database terminates and rolls back active transactions, disconnects clients, and shuts down. In an abort shutdown, Oracle Database terminates active transactions and disconnects users; it does not roll back transactions.
The database performs automatic recovery and rollback the next time it is started. Use this mode only in emergencies. Select Start up instance when service is started , Shut down instance when service is stopped , or both. To start or stop Oracle Database through Oracle Database Services, set the following registry parameters to the indicated values:. This parameter sets the full path to the initialization parameter file. This includes any database in the current Oracle home.
Default value is false. This parameter controls database shutdown mode. Set it to a abort , i immediate , or n normal. Default mode is i immediate if you do not set this parameter. This parameter sets maximum time to wait before the service for a particular SID stops. The registry location of these required and optional parameters is determined by the number of Oracle home directories on your computer. If you have only one Oracle home directory, then these parameters belong in:.
Use Password Utility to create password files. Password Utility is automatically installed with Oracle Database utilities. Password files can be used for local or remote connections to Oracle Database.
The value exclusive specifies that only one instance can use the password file and that the password file contains names other than SYS. If that is not set, then it uses the default:. The default value is shared. It specifies that multiple instances for example, a Real Application Clusters environment can use the password file. However, the only user recognized by the password file is SYS.
The shared value of this parameter affords backward compatibility with earlier Oracle releases. Oracle Database looks for the same files as it does when the value is exclusive. The value none specifies that Oracle Database ignores the password file and that authentication of privileged users is handled by the Windows operating system. Grant appropriate privileges to each user.
The password file is not automatically hidden. It can be made invisible and visible again from two different locations:. Please explain. Thanks GoJo. The SID is a site identifier. We can have more then 1 database on the same oracle home so we need a way to id them. Changing it harder then it looks. I know you are on unix, so here are the steps for changing it or the database name under Unix - they are different on NT.
Shutdown the instance 2. Backup all control, redo, and data files. Go through the. These are only used at database creation. This is optional. This file simplifies the "startup exclusive" process to start your database. Start up the database and verify that it works. Once you have done this, shutdown the database and take a final backup of all control, redo, and data files. Change locations to the directory where your trace files are located. Edit the "ccf. FROM: Recovery is required if any of the datafiles are restored backups, or if the last shutdown was not normal or immediate.
Save and exit the "ccf. Rename the old control files for backup purposes and so that they do not exist when creating the new ones. Run the "ccf. If, at this point, you receive the error that a file needs media recovery, the database was not shutdown normally as specified in step 4.
It may be possible to open the database after applying the current logfile. BUT this is not guaranteed.
If, after applying the current logfile, the database will not open then it is highly likely that the operation must be restarted having shutdown the database normally. To apply the necessary redo, you need to check the online logfiles and apply the one with the same sequence number as reported in the message.
Make sure the database is working. Shutdown and backup the database. Rating 58 ratings Is this answer out of date?
You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels.
And of course, keep up to date with AskTOM via the official twitter account. 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 Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search.
But I'm looking for something requiring less time. The other option to assign names in the clients tnsnames. Since 9i dbnewid utility nid can be used to change database name and DBID if required.
If database name being changed only then resetlogs is not required:. This post by Kaunain Ahmed describes the necessary steps:. Here's a post by AskTom which references the process in more detail. While it's for 10g, it should still work. This connection is made using the parameters. This is where the connection between the Oracle Instance and the database is made. Sign up to join this community. The best answers are voted up and rise to the top.
Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Ask Question.
0コメント