Would changing it have any impact on the different instances of the database? On NT, we don't use shared memory but the SID is still important.And lastly, where can I find out the SID of my database? We can have more then 1 database on the same oracle home so we need a way to id them. 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.S Jan 28 ora_pmon_ora815 shows 7 sids I currently have running on my testbed machine -- ora_pmon_$ORACLE_SID If you aren't on the server -- the sid just doesn't matter, you need the tns entry found in the file.On NT, look at the list of Oracle services in control panel.S Jan 18 ora_pmon_ora9i UTF ora806 13901 0.0 1.03324014080 ?
FROM: # Recovery is required if any of the datafiles are restored backups, # or if the last shutdown was not normal or immediate. Rename the old control files for backup purposes and so that they do not exist when creating the new ones. Edit the "init @ccf This will issue a startup nomount, and then recreate the controlfile.
S Jan 21 ora_pmon_ora734 tkyte 7446 0.0 0.1 944 784 pts/8 S grep pmon ora716 12929 0.0 0.417472 5552 ?
S Jan 22 ora_pmon_ora716 oracle9i 13112 0.0 13.6249688205872 ?
SCOPE & APPLICATION For DBAs requiring to either find or change the db_name or ORACLE_SID. Go through the .profile, .cshrc, .login, oratab, tnsnames.ora, (for SQL*Net version 2), and redefine the ORACLE_SID environment variable to a new value.
To find the current DB_NAME and ORACLE_SID: =========================================== Query the views v$database and v$thread. For example, search through disks and do a grep ORACLE_SID * 4.
Relational Model is about normalisation; or to put it simply, no redundant data. This is actually a GREAT example of a relational model. You are trying to update the primary key (a BIG NO NO in relational databases) and have to do the "on update cascade".