Change SID on Oracle
来源:互联网 发布:无本网络暴利项目 编辑:程序博客网 时间:2024/06/06 00:53
david -- Thanks for the question regarding "Change SID on Oracle Express (XE) 10.2.0", version XE 10.2.0
Submitted on 23-Jun-2008 9:17 Central time zone
Tom's latest followup | Bookmark | Bottom
Last updated 24-Jun-2008 9:36
You Asked
I'm trying to change the SID for an Oracle Express XE 10.2.0 install on Windows.I keep finding "Check Ask Tom" references, but all I've found on your site is a unix guide and an nt guide for version 8i. There have been a lot of changes since 8i and I'm having trouble using the guide, not all the programs mentioned in it seem to exist anymore.
What do I have to do?
Thanks
and we said...
Ok, here is a way, basically the same as it always was, just oradim is named oradim now, not oradim80. We do not need to rename the database, just want to change the sid from XE to SOMETHIN (8 characters max)1) shutdown database cleanly
sqlplus / as sysdbashutdown
2) stop the oracle services using control panel. (oracleserviceXE and the listener - or use lsnrctl stop from command line)
3) rename or copy C:\oraclexe\app\oracle\product\10.2.0\server\dbs\spfileXE.ora to C:\oraclexe\app\oracle\product\10.2.0\server\dbs\spfileSOMETHIN.ora
4) create C:\oraclexe\app\oracle\product\10.2.0\server\database\initSOMETHIN.ora by copying C:\oraclexe\app\oracle\product\10.2.0\server\database\initXE.ora and modify the spfile line to point to the new spfile
5) create the new service to start database and remove the old one
oradim -new -sid SOMETHIN -startmode auto -pfile C:\oraclexe\app\oracle\product\10.2.0\server\database\initSOMETHIN.oraoradim -delete -sid XE
6) start listener
lsnrctl start
7) fix your environment
set ORACLE_SID=SOMETHIN
8) the database will eventually register with listener, but you can make it happen now:
sqlplus / as sysdbaalter system register;if you query:
SQL> select instance_name from v$instance;INSTANCE_NAME----------------somethinYou'll see the new sid....
- Change SID on Oracle
- oracle中的sid
- 获得Oracle的SID
- Oracle 如何 查看 sid
- Oracle查询SID
- Oracle 如何 查看 sid?
- oracle:SID匹配错误
- oracle sid 和service_name
- oracle SID详解
- Oracle default SID list
- 查看oracle sid
- linux 查询oracle sid
- oracle sid 查看
- 修改Oracle SID
- 怎样修改Oracle的SID?
- 关于Oracle SID存在解決辦法
- 在oracle数据库查找SID
- 一、更改ORACLE SID名称
- 如何限制Dedecms文章或产品描述的字数
- uva 10192 Vacation
- 明智地使用多继承
- 如何在网站内 运行 JS 代码
- 原来OneNote的文字识别功能如此强大
- Change SID on Oracle
- 可配置BOM组件特性查询
- 关于变量赋值和Box
- FLEX 中关于组件的MouseX/Y和组件事件的LocalX/Y的区别
- windows程序设计 第五章笔记 GDI(1)
- C++一些资源
- JVM工作原理和特点
- Google推出新的移动广告形式,地理位置将影响搜索广告排名
- OVERLAPPED I/O