如何启动 在Linux AS4下的 Oracle? 如果没有配置路径参数,找到sqlplus文件在其目录下执行:./sqlplus /nolog>startup 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 启动和停止数据库:启动和停止数据库的最简单方法是从 OEM 控制台启动和停止。要从命令行执行此操作,请在以 oracle 身份登录后使用 SQL*Plus,如下所示:启动:$ sqlplusSQL*Plus:Release 10.1.0.2.0 - Production on Sun Jun 13 22:27:48 2004Copyright (c) 1982, 2004, Oracle.All rights reserved.Enter user-name:/ as sysdbaConnected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 188743680 bytesFixed Size 778036 bytesVariable Size 162275532 bytesDatabase Buffers 25165824 bytesRedo Buffers 524288 bytesDatabase mounted.Database opened.SQL> exitShutdown:$ sqlplusSQL*Plus:Release 10.1.0.2.0 - Production on Sun Jun 13 22:25:55 2004Copyright (c) 1982, 2004, Oracle.All rights reserved.Enter user-name:/ as sysdbaConnected to:Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> exit=======================================================使用 SQL*Plus 访问数据库 以 oracle 身份登录到 Linux。设置环境。设置 Oracle 环境变量:$ export ORACLE_BASE=/u01/app/oracle$ export ORACLE_SID=demo1$ export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1$ export PATH=$PATH:$ORACLE_HOME/bin运行 SQL*Plus:$ sqlplusSQL*Plus:Release 10.1.0.2.0 - Production on Sat Jun 5 16:59:21 2004Copyright (c) 1982, 2004, Oracle.All rights reserved.Enter user-name:/ as sysdbaConnected to:Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> 启动和停止 Oracle Enterprise Manager 数据库控制:$ emctl start dbconsole$ emctl stop dbconsole启动和停止 iSQL*Plus:$ isqlplusctl start$ isqlplusctl stop启动和停止监听器:监听器接受客户端的连接请求,并在验证证书后创建数据库连接。要使用 OEM 或 iSQL*Plus,必须先启动监听器。$ lsnrctl start$ lsnrctl stop 请教数据库设计 如何才算恰当的退出循环 請各位大俠給一些ORACLE dba 方面的資料 感謝﹗ oracle 日志可以用即时客户端提取吗?谢谢! 请问存储过程中,这句话是什么意思? 海量数据面前,预统计和动态数据之间矛盾如何处理? 定义一个这样的游标 oracle 数据库迁移问题 关于序列问题!求助!!! oracle8i中有毫秒吗?oracle9i中timestamp是带毫秒的,那8i中怎么表示毫秒呢?谢谢 很困难select 语句问题? 问oracle的几个题目
Connected to an idle instance.SQL> startup
ORACLE instance started.Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162275532 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL> exitShutdown:$ sqlplusSQL*Plus:Release 10.1.0.2.0 - Production on Sun Jun 13 22:25:55 2004Copyright (c) 1982, 2004, Oracle.All rights reserved.Enter user-name:/ as sysdbaConnected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
=======================================================
使用 SQL*Plus 访问数据库 以 oracle 身份登录到 Linux。设置环境。设置 Oracle 环境变量:$ export ORACLE_BASE=/u01/app/oracle
$ export ORACLE_SID=demo1
$ export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1
$ export PATH=$PATH:$ORACLE_HOME/bin运行 SQL*Plus:$ sqlplusSQL*Plus:Release 10.1.0.2.0 - Production on Sat Jun 5 16:59:21 2004Copyright (c) 1982, 2004, Oracle.All rights reserved.Enter user-name:/ as sysdbaConnected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL>
启动和停止 Oracle Enterprise Manager 数据库控制:$ emctl start dbconsole
$ emctl stop dbconsole启动和停止 iSQL*Plus:$ isqlplusctl start
$ isqlplusctl stop启动和停止监听器:监听器接受客户端的连接请求,并在验证证书后创建数据库连接。要使用 OEM 或 iSQL*Plus,必须先启动监听器。$ lsnrctl start
$ lsnrctl stop