处理步骤:
1、在Oracle安装路径下找到\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora,
打开该文件,找到“(ADDRESS = (PROTOCOL = TCP)(HOST = **************)(PORT = 1521))”,并复制
2、在Oracle安装路径下查找\oracle\admin\orcl\pfile\init.ora.0122213856132,
打开该文件,找到local_listener="(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))",选中并粘贴
3、打开cmd,输入:
sqlplus/nolog
conn sys as sysdba;
startup
startup pfile:'D:\oracle\admin\orcl\pfile\init.ora.0122213856132';
执行完以上步骤会提示数据库已装载完毕,数据库已打开