Learn more. Ask Question. Asked 7 years, 1 month ago. Active 6 years, 3 months ago. Viewed 12k times. Improve this question. Lalit Kumar B Vert Vert 29 1 1 gold badge 1 1 silver badge 7 7 bronze badges. No clue what you are asking. Please show the commands you are trying to execute, etc.
When you specify SID client and server on same computer and connect as sysdba you will use OS authentication - oracle username and password will be ignored as long as OS user in in DBA group. When you use service name and connect as sysdba the password file will be used and if sysdba role is not granted to that user user is not present in the password file , you'll get the ORA error.
Thanks for all of your answers — Vert. Add a comment. Active Oldest Votes. Thomas Kyte explained the difference beatifully : A service name is more flexible than a SID would be. A service is a many to many relationship. With the SID - that is more like telling the listener "I want you to connect to this specific database, I know the 'address', here you go" With the SERVICE - you are asking the listener to put you in touch with a database that can service your request, a database that registers using that service.
Improve this answer. Follow these instructions Page 6 on setting up a connection to an autonomous Database. Give a new name for your connection and fill in the username and password for the Oracle database account you wish to connect to.
Fill in the Hostname with the internet host name or IP address of the server where Oracle database is running. Set the port to match where the Oracle Listener is running is the typical default. Otherwise, if the Oracle server is using multi-tenant via oracle 12c or newer then select Service Name and supply the service name for the database instance.
Other advanced authentication, encryption and security settings can then be specific if necessary. Below is an example of connecting to an Oracle 12c instance on the local server using the Oracle system account. The password for this account was set up during the database installation.
Test the connection by clicking on the test button. And lastly, where can I find out the SID of my database? I don't seem to able to find it in technet. 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.
0コメント