监听实例和删除数据库[ Oracle @ POC-Oracle~] $ lsnrctl stop [ Oracle @ POC-Oracle~] $ sqlplus/assysdbasql * plus:版本19.0.0.0.0-production ontuejan 510336043360432021版本19.3.0.0版权声明(c ) 1982， 2002 Oracle.all rights reserved.connected to : Oracle数据库19 centerpriseeditionrelease 19.0.0.0.0 -生产版本] $ find.//- name $ Oracle _ sid./app/Oracle/diag/RDBMS/upbs./app/Oracle/Oracle upbs./app/Oracle/dbca/upbs./database/aa base-name $ Oracle _ sid *./oradata/temp/upbs _ temp.DBF./oradata/upbs.DBF删除入站cfgtoollogs/dbca/upb SRM-RF./app/Oracle/admin/upb SRM-RF./app/Oracle/audiiit upb SRM-RF./database/admin upbs_temp.DBF删除实例配置项目VI/重建DBF database:N数据库实例数据库实例dbca-silent-create数据库- template name general _ purpose.DBC-gdbnameupbbbbc 修改欧盟PBS-sidu PBS-response erse tal 32 utf8- memory percentage 30-emconfiguration local环境变量[oracle@POC-ORACLE ~] $ VI.bash _ profile Oracle _ sid=upbsoracle _ un qname=upbs重建完成后，检查监听[oracle@POC-ORACLE ~] $ lsnrctlstatuslsnrctlforlinux :版本19.0.0.0.0-production on 05-Jan-202110336048336003版权所有(c ) 1991 orrright ption=(address=) protocol=TCP ) HOST=POC-ORACLE ) port=1521 satusofthelistener---------- aliaslistion time 0day s 13h r.12 min.50 sectraceleveloffsecurityon : localosauthenticationsnmpofflistenerparameterfile/u01/network/ara u01/app/Oracle/diag/tnslsnr/POC-Oracle /监听器/alert/log.xmllisteningendpointssummary . (描述=(地址=) protocol=TCP ) ) HOST=POC-ORACLE ) (端口=1521 ) ervice'orcl'has1instance ).Instance 'orcl '，status READY，has1handler(s ) forthis service.service ' orclxdb ' has Has1Handler(s ) forthis service . service ' upbs ' has1instance ) s ).Instance 'upbs '，status READY， has1Handler(s ) forthis service . service ' upbsxdb ' has1instance ) s ).Instance 'upbs '，status READY，has1Handler(s
LRM-001093360 couldnotopenparameterfile '/u01/database/DBS/init orcl是指在网上查询，将相应pfile中的初始化ora复制到相应的目录中
[ Oracle @ POC-Oracle pfile ] $ pwd/u01/app/Oracle/admin/upbs/pfile-rw-r---1 oracledb a 2055月4日21336030