achduliebe
MIS
Does anyone have knowledge of how to globally change every occurrence of the Oracle SID throughout a system? We would like to change it inside a file, directory, and filename. If this is possible.
Thanks!
Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to globally change SID?
- Thread starter achduliebe
- Start date
- Status
Hi achduliebe,
A utility to change that automatically, and safely (more to the point), would be costly to write.
However -- it would be fairly easy to write an shell script that searched through all text files on the system for the Oracle SID you mention and print out the names of the files that contain it. You could then edit each script and change the oracle sid (taking a backup of the script as you did so, of course) Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.
A utility to change that automatically, and safely (more to the point), would be costly to write.
However -- it would be fairly easy to write an shell script that searched through all text files on the system for the Oracle SID you mention and print out the names of the files that contain it. You could then edit each script and change the oracle sid (taking a backup of the script as you did so, of course) Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.
- Status
Similar threads
- Locked
- Question