首页/新闻资讯/详情

重庆思庄技术分享-oracle数据库修改db_name

发布时间：2026/10/1 12:39:26

重庆思庄技术分享-oracle数据库修改db_name 1.创建pfile.ora文件SQL create pfile/home/oracle/pfile.ora from spfile;2.关闭数据库后启动至mount状态SQL shutdown immediate;SQL STARTUP MOUNT;3.在命令行中输入nid命令进行修改修改成功后数据库会自动关闭nid target/ DBNAME新名字例如[oracleCJQYY dbs]$ nid target/ DBNAMEwebemrcsDBNEWID: Release 19.0.0.0.0 - Production on Fri Jul 24 23:28:21 2026Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.Connected to database PTDB (DBID1833283942)Connected to server version 19.19.0Control Files in database:/data/webemrcs/control01.ctl/data/webemrcs/control02.ctlChange database ID and database name PTDB to WEBEMRCS? (Y/[N]) YProceeding with operationChanging database ID from 1833283942 to 140534101Changing database name from PTDB to WEBEMRCSControl File /data/webemrcs/control01.ctl - modifiedControl File /data/webemrcs/control02.ctl - modifiedDatafile /data/webemrcs/datafile/system.268.113823270 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/sysaux.261.113823273 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/undotbs1.264.113823275 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/system.312.113823326 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/sysaux.311.113823326 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/users.267.113823275 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/undotbs1.310.113823326 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/undotbs2.308.113823347 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/system.302.113823839 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/sysaux.304.113823839 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/undotbs1.303.113823839 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/csformbasic.300.113823863 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/csformbus.299.113823863 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/csformbushisdata.331.113823863 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/csformcontenthisdata.332.113823864 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/maaihisdata.333.113823864 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/meddocbase.334.113823865 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/meddocbus.335.113823865 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/meddocbushisdata.336.113823865 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/meddoccontenthisdata.337.113823866 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/med_i_doc.338.113823866 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/scoresbushisdata.340.113823867 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/scorescontenthisdata.341.113823867 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zlemrbushisdata.342.113823868 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zlemrcontenthisdata.343.113823868 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zl_basic_config.344.113823868 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zl_maai.345.113823869 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zl_qcrule.346.113823870 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zl_scores.347.113823871 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zl_zlemr.348.113823872 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/users.350.113823940 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/undo_2.351.113824333 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zl_zlemr02.db - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zl_zlemr03.db - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zl_zlemr04.db - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/zl_zlemr05.db - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/csformbus02.db - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/temp.309.113823328 - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/temp.db - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/temp02.db - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/tempb.db - dbid changed, wrote new nameDatafile /data/webemrcs/datafile/temp_new.db - dbid changed, wrote new nameControl File /data/webemrcs/control01.ctl - dbid changed, wrote new nameControl File /data/webemrcs/control02.ctl - dbid changed, wrote new nameInstance shut downDatabase name changed to WEBEMRCS.Modify parameter file and generate a new password file before restarting.Database ID for database WEBEMRCS changed to 140534101.All previous backups and archived redo logs for this database are unusable.Database has been shutdown, open database with RESETLOGS option.Succesfully changed database name and ID.DBNEWID - Completed succesfully.###按上面的提示可以选择重建密码文件也可以不重建如果ORACLE_SID未变化的话可以远程连接验证一下4.修改pfile.ora中的db_name5.以修改后的pfile.ora文件启动至nomount然后创建新的spfile然后以spfile启动至nomountSQL STARTUP NOMOUNT pfile/home/oracle/pfile.ora;SQL create spfile from pfile/home/oracle/pfile.ora;SQL shutdown immediate;SQL STARTUP NOMOUNT6.启动至mount然后以resetlogs打开SQL alter database mount;SQL alter database open resetlogs;7.验证SQL show parameter name-------------------------备注可以更方便不创建pfile在nid转换后直接STARTUP MOUNT;ALTER SYSTEM SET DB_NAME新db_name SCOPESPFILE;SHUTDOWN IMMEDIATE;重新启动并 RESETLOGSSTARTUP MOUNT;ALTER DATABASE OPEN RESETLOGS;SHOW PARAMETER DB_NAME;SELECT DBID, NAME FROM V$DATABASE;
延伸阅读

更多相关文章

资深工程师如何构建立体技术护城河：从技能点到价值网
2026/10/1 12:39:25

资深工程师如何构建立体技术护城河：从技能点到价值网

最近和一位朋友聊天，他今年四十出头，在一家互联网公司做技术架构。他提到一个现象，让我思考了很久：团队里新来的年轻人，用着最新的框架和工具，解决业务问题的速度很快，而他引以为傲的“系统设计…

Gemini 3 Flash与3.1 Pro实测对比：AI模型选型中的效果与成本权衡
2026/9/30 20:22:55

Gemini 3 Flash与3.1 Pro实测对比：AI模型选型中的效果与成本权衡

1. 项目概述：一次关于“性价比”的深度拷问最近在折腾AI应用开发，特别是需要频繁调用API的场景，成本控制就成了一个绕不开的坎。Google的Gemini系列模型无疑是当前最炙手可热的选择之一，尤其是Gemini 3 Flash和Gemini 3.1 Pro这两…

2024年美容院网站建设全攻略：如何用极简页面撬动百万客流？
2026/9/27 5:52:35

2024年美容院网站建设全攻略：如何用极简页面撬动百万客流？

做实体生意的人，特别是开美容院的老板，我特别理解你的那种焦虑。每天睁眼就是房租、人工、进货，闭眼就是客户投诉、员工离职。很多时候，你觉得缺客户，好像去抖音投流、去美团买套餐就能解决一切。但今天我想跟你掏心窝子说句话，如果你的线上门户——也就是你的网站，没做…

C++ Qt斗地主源码解析：MVC分层与AI出牌逻辑实战
2026/10/1 12:36:51

C++ Qt斗地主源码解析：MVC分层与AI出牌逻辑实战

简介：这是一份面向计算机专业学生的C与Qt期末大作业项目，以单机版斗地主为载体，完整演示了从游戏规则到图形界面的开发流程，适合用于课程设计参考或综合实践练手。资源包为5.76MB的ZIP压缩包，共119个文件，其…

素数判断算法全解析：从数学原理到C/Java工程优化
2026/10/1 12:36:51

素数判断算法全解析：从数学原理到C/Java工程优化

素数不是新鲜话题，但每次写代码遇到“判断素数”这种基础问题，总有人把简单的东西搞复杂，或者反过来把朴素的算法用到性能瓶颈。最近我在整理算法笔记，正好把素数这条线从头到尾捋了一遍：从定义、判断、数学性质&#…

刘强东效仿雷军：创始人IP如何重塑品质零售与履约效率
2026/10/1 12:36:51

刘强东效仿雷军：创始人IP如何重塑品质零售与履约效率

最近商业圈有件事挺有意思：刘强东做了一件雷军该做的事。放在以前，这个判断可能会让很多人摸不着头脑——一个做自营电商起家的，一个造手机造车的，两个人赛道八竿子打不着。但2025年之后，你再回看这两个人的动作&#…

AI-Lossless-Zoomer新版路线图：五大功能深度解析
2026/10/1 12:36:51

AI-Lossless-Zoomer新版路线图：五大功能深度解析

我去年接手过一批90年代老照片的数字化整理，扫描件原图只有72dpi，要放大打印成A3画册，试过Photoshop的插值算法，也试过几款商业放大软件，效果始终差一口气。后来接触到AI-Lossless-Zoomer这个项目，才彻底理…

五大前端框架（React 19/Vue 3.5/Svelte 5/Solid/Qwik）横向评测与选型指南
2026/10/1 12:36:51

五大前端框架（React 19/Vue 3.5/Svelte 5/Solid/Qwik）横向评测与选型指南

1. 这次评测的起因与框架范围 最近在做技术规划时，团队内部连续讨论了好几轮"新兴框架到底选哪个"的问题。React 19正式发布、Vue 3.5稳定落地、Svelte 5带着runes机制重新定义写法、Solid和Qwik也在各自的细分方向上持续迭代。这几年前端框架的更新节奏明…

基于Spring Boot的废旧物资预约回收系统：毕设项目全链路解析
2026/10/1 12:31:51

基于Spring Boot的废旧物资预约回收系统：毕设项目全链路解析

每年帮学生复审毕业设计的Java项目，我都会遇到同一类题目：基于Spring Boot的业务管理系统。这次拿到的“瑞回宝废旧物资预约回收系统”比较有代表性——题面是一个环保回收业务，背后却串联了Spring Boot后端开发从项目初始化、数据建模、状态…

东莞市品牌网站建设报价常见报错与解决
2026/10/1 5:21:14

东莞市品牌网站建设报价常见报错与解决

东莞品牌网站建设报价单背后：一份保姆级建站教程避坑实录 网站做好了没人访问，这大概是很多老板最头疼的事。花了大几万做的品牌站，上线后流量惨淡，比路边摊还冷清。别急着骂外包公司，很多“东莞品牌网站建设报价”里藏着不少猫腻，比如用模板站冒充定制…

如何划分训练/验证集：Spirula Studio五种eval_mode策略详解
2026/9/29 21:48:03

如何划分训练/验证集：Spirula Studio五种eval_mode策略详解

如何划分训练/验证集：Spirula Studio五种eval_mode策略详解 【免费下载链接】spirula-studio Cross-vendor 3D Gaussian Splatting trainer - video to splat to mesh, Vulkan or CUDA. 项目地址: https://gitcode.com/GitHub_Trending/sp/spirula-studio Sp…

SEO怎么推广速查手册新手避坑实战指南
2026/10/1 10:48:55

SEO怎么推广速查手册新手避坑实战指南

SEO怎么推广速查手册新手避坑实战指南 模板网站太丑不够用？别急着加滤镜，那是治标不治本。很多老板盯着后台流量掉得眼红，却还在纠结首页Banner的圆角是不是3像素。这就像穿着西装去挖土，姿势不对，努力白费。我整理这份 速查手册…

还想了解更多？直接咨询顾问

免费诊断 + 免费方案 + 透明报价。

全国咨询热线400-8866-253
免费获取方案
☎咨询二维码 ☎ ↑