四种启动方式:
1、startup nomount
非安装启动:这种方式启动下可执行:重建控制文件、重建数据库、启动instance,即启动SGA和后台进程,这种启动只需要init.ora文件。
2、startup mount dbname
安装启动:这种方式启动下可执行:数据库日志归档、数据库恢复、重新命名一些数据库文件 ,如:系统表空间或日志文件。执行“nomount”,然后打开控制文件
3、startup open dbname
首先执行“nomount”,然后执行“mount”,再打开包括Redo log文件在内的所有数据库文件, 这种方式下可访问数据库中的数据。
4、startup等于以下三个命令
startup nomount
alter database mount
alter database open
ORA-12528问题解决:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
1:修改listener.ora的参数
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ammicly)
(ORACLE_HOME = c:\oracle\product\10.1.0\db_1)
(SID_NAME =
ammicly)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lypch )(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
2:修改tnsnames.ora的参数
AMMICLY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lypch )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ammicly)
(UR=A)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
启动数据库
SQL> conn /as sysdba
SQL> alter database mount;
SQL> alter database open;
这样就可以启动数据库了;
或者用Oradim -shutdown -sid ammicly -shuttype srvc,inst -shutmode immediate -syspwd ammic;关闭数据库
在用oradim -startup -sid ammicly -starttype srvc,inst -syspwd ammic;启动数据库解决;也可以在截面上从启动数据库服务来解决;
ORA-12528:监听中的服务使用了动态服务,系统启动后,数据库没有正常的MOUNT。因此在动态模式下,就会出现这个问题,用静态的就不会有这个问题,因此上面的方法就是把监听设置为静态,或者在tnsnames.ora中追加(UR=A)或者从启动服务,三种方法解决问题
分享到:
相关推荐
oracle启动失败,ORA-00702报错,windows,linux系统下解决办法
win 8 升级 win 10 后,oracle 11g 无法启动及客户端连接,命令行sqlplus登录,startup 时报 ORA-00119 和 ORA-00132 的错误。 1. sqlplus /nolog 2. conn / as sysdba 3. startup 报错: ORA-00119 和 ORA-00132
主要介绍了IDEA遇到Internal error. Please refer to http://jb. gg/ide/critical-startup-errors的问题及解决办法,本文通过图文并茂的形式给大家介绍的非常详细,需要的朋友可以参考下
# Oracle listener and instance startup echo -n "Starting Oracle: " su - $ORA_OWNR -c "$ORACLE_HOME/bin/dbstart" su - $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl start" touch /var/lock/Oracle su - $ORA_OWNR...
oracle11g安装后,本地无法登录! 前提:服务全部打开,监听也配置好了! win7 64位 oracle 11g 简单的sql命令: 先登录到sqlplus:sqlplus/nolog; 登录数据库:connsystem/managerassysdba; 然后启动数据库:...
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup //------------------------------------------------------------------------------------------------ 【在注册表里的位置(可更改)】 [HKEY_...
<startup> <supportedRuntime version="v4.0.30319"/> <!-- 4.0 RTM --> <supportedRuntime version="v4.0.21006"/> <!-- 4.0 Beta2 --> <supportedRuntime version="v4.0.20506"/> <!-- 4.0 Beta1 --> ...
/usr/local/apache-tomcat-7.0.28/bin/startup.sh netstat -lnt 发现了80开头的端口 Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 0.0.0.0:111 ...
- nacos: `sh ./docker/nacos/startup.sh` - seata-server - 导入配置: `sh ./docker/seata-server/conf/nacos-config.sh ${nacos-address}` - 启动: `sh ./docker/seata-server/bin/seata-server.sh` - mysql ...
This only affects Oracle Real Application Clusters and can be reported in ASM as well as database instances. The issue was introduced in Oracle 10.2.0.4 so earlier versions are not affected Possible ...
前段时间,早上刚到公司,打开电脑就发现启动Oracle实例的时候报了下面的错误: SQL> startup nomount; ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORA-16032: parameter LOG_...
此压缩包内为示例版页面源代码,其中包含: ...完整版下载地址:https://themeforest.net/item/bulkit-agency-startup-and-saas-template/21278677?ref=cssninjaStudio&clickthrough_id=1251402193&redirect_back=true
通过此链接解决 具体来说,此评论: sudo mkdir -p /etc/opt/chrome/native-messaging-hosts/ sudo ln -s /etc/chromium/native-messaging-hosts/com.github.browserpass.native.json /etc/opt/chrome/native-...
oracle基础上课记录笔记 3/08 ====================================== 启动/关闭oracle服务 net start/stop OracleServiceORCL 手动 --------------------------- c:\> sqlplus /nolog 进入数据库 sql> conn /as ...
* >> startup_rvc * 3. 双击RobotStudio.m, 点击执行开始执行。 # Installation introduction: * 1. Change the Matlab working space to the "RobotStudio"; * 2. Command the following command lines: * >> ...
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current ...
文章目录1.视界2.背景2.1 开始2.2 恐慌2.3 转机2.3.1 时间机器2.3.2 重新安装3.2.3 磁盘恢复4.欣喜5.神转折6.忐忑7....磁盘管理10.两天后11.小结12....工作一天,回到酒店,打开电脑,脸上网络,之后关机睡觉,谁想到第二...
第三,⽤旧数据库的参数启动新的实例 SQL> startup pfile='D:/oracle/ora92/database/INITora92.ORA'; ORACLE 例程已经启动。 Total System Global Area 85006980 bytes Fixed Size 453252 bytes Variable Size ...
====================research the source about apache-tomcat-7.0.57====================/org/apache/catalina/startup/Bootstrap---2014/11/28/org/apache/catalina/startup/Catalina---2014/11/28当Bootstrap...
sh startup.sh 方式2: ./startup.sh 8.修改防火墙的规则: 方式1:service iptables stop 方式2:放行8080 端口 修改配置文件 cd /etc/sysconfig vi iptables 复制(yy p) -A INPUT -m state --state NEW -m...