我们只能创建 8 个控制文件。
如果我创建 9 个文件，我应该得到错误：ORA-00208：控制文件名的数量超过 8 个限制。
但我收到错误 ORA-03113: end-of-file on communication channel。
为什么不是 ORA-00208？
我正在尝试计算 Oracle 数据库startup命令的运行时间。该视图V$INSTANCE包含STARTUP_TIME告诉数据库何时启动的列。startup但是，我需要找到从我们输入到打开数据库所经过的时间。
因为，我们无法查询SYSDATE或SYSTIMESTAMP数据库未打开时，我发现很难提出逻辑。
有没有其他方法我们可以获得startup操作的经过时间？
PDI(spoon.bat) 在启动时崩溃。这是 /logs/spoon.log：
09:59:04,793 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
09:59:08,932 INFO [KarafInstance]
*******************************************************************************
*** Karaf Instance Number: 1 at f:\user\pdi-ce-8.0.0.0-28\data-integration\ ***
*** .\system\karaf\caches\spoon\data-1 ***
*** FastBin Provider Port:52901 ***
*** Karaf Port:8802 ***
*** OSGI Service Port:9051 ***
*******************************************************************************
?ub 20, 2018 9:59:09 AM org.apache.karaf.main.Main$KarafLockCallback lockAquired
INFO: Lock acquired. Setting startlevel to 100
2018-02-20 09:59:14.928:INFO:oejs.Server:jetty-8.1.15.v20140411
2018-02-20 09:59:15.055:INFO:oejs.AbstractConnector:Started [email protected]:9051
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/core
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/configuration/beans
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/configuration/parameterized-types
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/configuration/security
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://schemas.xmlsoap.org/wsdl/
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://www.w3.org/2005/08/addressing
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/08/addressing
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-management (171) [org.apache.cxf.management.InstrumentationManager]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-wsdl (174) [org.apache.cxf.wsdl.WSDLManager]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-xml (176) [org.apache.cxf.binding.xml.XMLBindingFactory, org.apache.cxf.binding.xml.wsdl11.XMLWSDLExtensionLoader]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-soap (177) [org.apache.cxf.binding.soap.SoapBindingFactory, org.apache.cxf.binding.soap.SoapTransportFactory]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/bindings/soap
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-policy (195) [org.apache.cxf.ws.policy.PolicyEngine, org.apache.cxf.policy.PolicyDataEngine, org.apache.cxf.ws.policy.AssertionBuilderRegistry, org.apache.cxf.ws.policy.PolicyInterceptorProviderRegistry, org.apache.cxf.ws.policy.PolicyBuilder, org.apache.cxf.ws.policy.PolicyAnnotationListener, org.apache.cxf.ws.policy.attachment.ServiceModelPolicyProvider, org.apache.cxf.ws.policy.attachment.external.DomainExpressionBuilderRegistry, org.apache.cxf.ws.policy.attachment.external.EndpointReferenceDomainExpressionBuilder, org.apache.cxf.ws.policy.attachment.external.URIDomainExpressionBuilder, org.apache.cxf.ws.policy.attachment.wsdl11.Wsdl11AttachmentPolicyProvider, org.apache.cxf.ws.policy.mtom.MTOMAssertionBuilder, org.apache.cxf.ws.policy.mtom.MTOMPolicyInterceptorProvider]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (178) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/transports/http/configuration
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/simple
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-frontend-jaxws (180) [org.apache.cxf.jaxws.context.WebServiceContextResourceResolver]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxws
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxrs
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxrs-client
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/binding/coloc
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-local (191) [org.apache.cxf.transport.local.LocalTransportFactory]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-object (192) [org.apache.cxf.binding.object.ObjectBindingFactory]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/binding/object
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/policy
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://www.w3.org/ns/ws-policy
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://www.w3.org/2006/07/ws-policy
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/09/policy
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://www.w3.org/2000/09/xmldsig#
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://docs.oasis-open.org/ws-sx/ws-securitypolicy/200702
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-addr (212) [org.apache.cxf.ws.addressing.policy.AddressingAssertionBuilder, org.apache.cxf.ws.addressing.policy.UsingAddressingAssertionBuilder, org.apache.cxf.ws.addressing.policy.AddressingPolicyInterceptorProvider, org.apache.cxf.ws.addressing.impl.AddressingWSDLExtensionLoader, org.apache.cxf.ws.addressing.WSAddressingFeature$WSAddressingFeatureApplier, org.apache.cxf.ws.addressing.MAPAggregator$MAPAggregatorLoader]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/ws/addressing
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-security (214) [org.apache.cxf.ws.security.policy.WSSecurityPolicyLoader, org.apache.cxf.ws.security.cache.CacheCleanupListener]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-rm (216) [org.apache.cxf.ws.rm.RMManager, org.apache.cxf.ws.rm.policy.RMPolicyInterceptorProvider, org.apache.cxf.ws.rm.policy.RM10AssertionBuilder, org.apache.cxf.ws.rm.policy.RM12AssertionBuilder, org.apache.cxf.ws.rm.policy.WSRMP12PolicyLoader, org.apache.cxf.ws.rm.policy.MC11PolicyLoader, org.apache.cxf.ws.rm.policy.RSPPolicyLoader]
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://cxf.apache.org/ws/rm/manager
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
INFO: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2005/02/rm/policy
?ub 20, 2018 9:59:16 AM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-javascript (217) [org.apache.cxf.javascript.JavascriptServerListener]
?ub 20, 2018 9:59:17 AM org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess
INFO: New Caching Service registered
09:59:17,972 ERROR [KarafCapabilityProvider] No feature found matching id: common-ui-client-config
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/F:/user/pdi-ce-8.0.0.0-28/data-integration/launcher/../lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/f:/user/pdi-ce-8.0.0.0-28/data-integration/plugins/pentaho-big-data-plugin/lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
?ub 20, 2018 9:59:20 AM org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be /lineage
?ub 20, 2018 9:59:20 AM org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be /i18n
?ub 20, 2018 9:59:21 AM org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be /marketplace
?ub 20, 2018 9:59:22 AM org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be /repositories
?ub 20, 2018 9:59:24 AM org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be /browser
09:59:30,154 ERROR [XulParser] handler not found: W?NDOW
2018/02/20 09:59:30 - General - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Error initializing transformation
2018/02/20 09:59:30 - General - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : org.pentaho.ui.xul.XulException: java.lang.NullPointerException
2018/02/20 09:59:30 - General - at org.pentaho.ui.xul.impl.AbstractXulLoader.loadXul(AbstractXulLoader.java:134)
2018/02/20 09:59:30 - General - at org.pentaho.ui.xul.swt.SwtXulLoader.loadXul(SwtXulLoader.java:128)
2018/02/20 09:59:30 - General - at org.pentaho.ui.xul.swt.SwtXulLoader.loadXul(SwtXulLoader.java:122)
2018/02/20 09:59:30 - General - at org.pentaho.ui.xul.impl.AbstractXulLoader.loadXul(AbstractXulLoader.java:238)
2018/02/20 09:59:30 - General - at org.pentaho.di.ui.spoon.Spoon.init(Spoon.java:850)
2018/02/20 09:59:30 - General - at org.pentaho.di.ui.spoon.Spoon.createContents(Spoon.java:9209)
2018/02/20 09:59:30 - General - at org.eclipse.jface.window.Window.create(Window.java:426)
2018/02/20 09:59:30 - General - at org.eclipse.jface.window.Window.open(Window.java:785)
2018/02/20 09:59:30 - General - at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9240)a
2018/02/20 09:59:30 - General - at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:692)
2018/02/20 09:59:30 - General - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2018/02/20 09:59:30 - General - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2018/02/20 09:59:30 - General - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2018/02/20 09:59:30 - General - at java.lang.reflect.Method.invoke(Method.java:498)
2018/02/20 09:59:30 - General - at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
2018/02/20 09:59:30 - General - Caused by: java.lang.NullPointerException
2018/02/20 09:59:30 - General - at org.pentaho.ui.xul.impl.XulParser.parseDocument(XulParser.java:92)
2018/02/20 09:59:30 - General - at org.pentaho.ui.xul.impl.AbstractXulLoader.loadXul(AbstractXulLoader.java:126)
2018/02/20 09:59:30 - General - ... 14 more
2018/02/20 09:59:30 - General - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Error starting Spoon shell
2018/02/20 09:59:30 - General - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : java.lang.NullPointerException
2018/02/20 09:59:30 - General - at org.pentaho.di.ui.spoon.Spoon.init(Spoon.java:903)
2018/02/20 09:59:30 - General - at org.pentaho.di.ui.spoon.Spoon.createContents(Spoon.java:9209)
2018/02/20 09:59:30 - General - at org.eclipse.jface.window.Window.create(Window.java:426)
2018/02/20 09:59:30 - General - at org.eclipse.jface.window.Window.open(Window.java:785)
2018/02/20 09:59:30 - General - at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9240)
2018/02/20 09:59:30 - General - at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:692)
2018/02/20 09:59:30 - General - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2018/02/20 09:59:30 - General - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2018/02/20 09:59:30 - General - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2018/02/20 09:59:30 - General - at java.lang.reflect.Method.invoke(Method.java:498)
2018/02/20 09:59:30 - General - at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
stopping
我该如何解决这个问题？
我正面临这个不寻常的问题。我想从 noarchivelog 模式启用归档日志模式，并使用 alter 命令进行相同的操作 ALTER SYSTEM SET log_archive_dest='LOCATION=D:\Oracle\Redo Log Archive\'，然后关闭数据库。当我尝试以 SQL>STARTUP mount 的方式重新启动时，它给出了以下错误
ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed。搜索网络后，我尝试
sql>ALTER SYSTEM SET log_archive_dest_1='LOCATION=D:\Oracle\Redo Log Archive\' scope=both;但得到
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
对于其他类似SQL>archive log list显示上述错误的命令，即ORA-01034: ORACLE not available.
PS：在 pfile 文件夹的 init.ora 中没有任何 log_file_dest_1 参数。有什么方法可以手动添加它并启动数据库或任何其他方式，因为来自 sql plus 的更改命令不起作用。
我在端口 3059 上运行 Windows 7 上的 Firebird 2.5 经典服务器。该服务设置为自动启动并且运行良好。
我已经在端口 3050 上安装了 Firebird 3.0.2 作为经典服务器，但服务不会自动启动。我可以手动启动它，但我真的需要它自动启动。
错误 1053：“服务未及时响应”
是我在事件查看器中得到的错误。Windows 只有一个管理员用户，没有密码。那只是错误。
我的本地 Postgres 服务器配置为在计算机启动时启动。我刚刚更改了postgresql.conf文件，不得不重新启动服务器。我做了：
pg_ctl restart
从在下一个命令提示符处启动服务器的命令行 BUT：
pg_ctl：旧的服务器进程（PID：2968）似乎消失了 无论如何启动服务器 服务器启动 D:\>2016-10-12 16:24:48 EDT LOG：将日志输出重定向到日志收集器进程 2016-10-12 16:24:48 EDT 提示：未来的日志输出将出现在目录“pg_log”中。
如果我ctrl-c退出它或关闭命令窗口，则会关闭服务器。如何pg_ctl在后台使用（重新）启动服务器，模拟默认情况下的工作方式（作为 Windows 服务）？
我必须在 RHEL 6.8 操作系统上为 Oracle DB 12c 设置自动启动。用户 oracle 没有登录 shell，例如
sudo su - oracle -s /bin/bash
我遵循了RHEL 设置指南。init.d 脚本如下所示：
#!/bin/bash
# chkconfig: 35 99 10
# description: Starts and stops Oracle processes
ORA_HOME=/opt/oracle/product/12cR1/db
ORA_OWNER=oracle
PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
case $1 in
'start')
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart"
;;
'stop')
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut"
;;
*)
echo "usage: $0 {start|stop}"
exit 1
esac
#
exit
操作系统重启后。Oracle DB 未启动。有什么问题？$ORACLE_HOME/startup.log 之外还有其他日志吗？
我在 oracle linux 6.7 上有 oracle 数据库 11.2.0.4 。
我已经使用 asm 选项安装了 oracle 数据库单实例。
我有 2 个用户：oracle 和 grid
我的数据库是开放的，一切都很好！
我想安装用于将数据库连接到 sql server 的 oracle 网关。这个产品给我一个错误：你不能在 /u01/app/grid/product/11.2.0/ASM 上创建目录。
要解决此错误，请执行以下命令：
chown -R 网格：oinstall /u01
chmod -R 775 /u01
执行这些命令并重新启动服务器后，我无法启动数据库。
我的磁盘组已安装，但我无法使用 oracle 用户启动数据库：
sqlplus sys/****** 作为 sysdb
sql > 启动
ORA-01078: 处理系统参数失败
ORA-01565: 识别文件 '+DATA/orcl/spfileorcl.ora' 时出错
ORA-17503: ksfdopn:2 无法打开文件 +DATA/orcl/spfileorcl.ora
ORA-12547: TNS: 失去联系
……………………………………………………………………………………………………………………
使用网格用户，下面的命令输出为：
srvctl 启动数据库 -d orcl
PRCR-1079：无法启动资源 orcl.db
ORA-12547: TNS: 失去联系
CRS-5017：资源操作“ora.orcl.db start”遇到以下错误：
ORA-12547: TNS: 失去联系
. 有关详细信息，请参阅“/u01/app/grid/product/11.2.0/ASM/log/it/agent/ohasd/oraagent_grid/oraagent_grid.log”中的“(:CLSN00107:)”。
CRS-2674：在 'it' 上启动 'ora.orcl.db' 失败
ORA-12547: TNS: 失去联系
谁能帮我 ？
每当我尝试打开 Oracle 时，都会出现以下错误：ORA-01109: database not open
所以按照各种博客和论坛的建议，我尝试了以下一系列命令
c:> sqlplus /nolog
sql> connect sys/manager as sysdba
sql> shutdown immediate
sql> startup
（以及启动安装、启动力等）
我得到 ORA-01589: must use RESETLOGS or NORESETLOGS options for database open
如果我尝试：
SQL> alter database open noresetlogs;
I get error ORA-00600: internal error code error
如果我在恢复后尝试重置日志，我会得到以下选项：
ORA-01152: file 1 was not restored from a sufficiently old backup
我在数据库上没有任何重要数据，我只是开始一个虚拟项目。所以我不太关心数据，我的目标是只使用 ORACLE 处理一些新表。
任何帮助将非常感激。
mysqld 不再重新启动...在日志中，明显的原因是：
mysqld started
[Warning] Ignoring user change to 'root' because the user was set to 'mysql' earlier on the command line
[ERROR] /usr/libexec/mysqld: unknown variable 'password=mypassword'
mysqld ended
/etc/my.cnf 没有什么相关的，也没有这样的变量，顺便说一下，消息中有正确的 mysql root 密码值（！！！？）：
[mysqld]
user=mysql
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Centos 5.9 上的 Mysql 5.0.95。重启前一切正常！！
也试过
/usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --no-defaults
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld ended