启动数据库、启动监听

1.oracle登录
AIX Version 5
Copyright IBM Corporation, 1982, 2008.
login: oracle
oracle's Password: oracle
*******************************************************************************
* *
* *
* Welcome to AIX Version 5.3! *
* *
* *
* Please see the README file in /usr/lpp/bos for information pertinent to *
* this release of the AIX Operating System. *
* *
* *
*******************************************************************************
Last unsuccessful login: Mon Jun 29 10:56:07 BEIST 2009 on ftp from ::ffff:103.198.13.156
Last login: Mon Jun 29 11:21:36 BEIST 2009 on /dev/pts/1 from 103.198.8.161
$
2.oracle dba登录
$ sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production on Mon Jun 29 11:23:42 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
SQL>
3、关闭数据库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
4、启动数据库
SQL> startup mount
ORACLE instance started.
Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
5.启动Oracle10g监听程序

AIX Version 5
Copyright IBM Corporation, 1982, 2008.
login: oracle
oracle's Password:
*******************************************************************************
* *
* *
* Welcome to AIX Version 5.3! *
* *
* *
* Please see the README file in /usr/lpp/bos for information pertinent to *
* this release of the AIX Operating System. *
* *
* *
*******************************************************************************
Last unsuccessful login: Mon Jun 29 10:56:07 BEIST 2009 on ftp from ::ffff:103.198.13.156
Last login: Mon Jun 29 11:27:07 BEIST 2009 on ftp from ::ffff:103.198.13.156
$ lsnrctl
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production on 29-JUN-2009 11:27:34
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=103.17.1.39)(PORT=1521)))
The command completed successfully
LSNRCTL> start
Starting /u01/app/oracle/product/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production
System parameter file is /u01/app/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=103.17.1.39)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=103.17.1.39)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production
Start Date 29-JUN-2009 11:28:22
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/app/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=103.17.1.39)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "hxfp" has 1 instance(s).
Instance "hxfp", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>


解决问题:
1.错误信息:ORA-01219: database not open: queries allowed on fixed tables/views only
SQL>alter database open;
### 启动Oracle数据库监听器 对于启动Oracle数据库监听器的操作,具体方法依赖于操作系统环境。以下是针对不同操作系统的解决方案。 #### Windows环境下启动Oracle监听器 当遇到本地计算机上的`OracleOraDb10g_home1TNSListener`服务启动后又停止的情况时,可以尝试以下解决办法[^1]: - 使用命令提示符或PowerShell作为管理员身份运行。 - 输入并执行 `net start OracleOraDb10g_home1TNSListener` 命令来重新启动监听器服务。 #### Unix/Linux系统下的启动过程 在Linux环境中,为了确保能够顺利重启Oracle数据库及其监听器,建议按照如下流程操作[^4]: ```bash su - oracle sqlplus / as sysdba shutdown immediate; startup; exit; lsnrctl stop lsnrctl start ``` 上述脚本首先切换至oracle用户账户,接着利用SQL*Plus工具连接到实例并安全关闭再开启数据库本身,最后通过`lsnrctl`指令集管理监听器的状态——先停用再激活它。 #### AIX平台上的处理方式 AIX作为一个专有的UNIX版本同样支持类似的自动化配置手段用于保障每次开机都能自动加载必要的组件服务[^3]。这通常涉及到编辑特定的初始化文件以加入自定义的服务注册逻辑,从而实现无需人工干预就能完成整个栈(包括WebLogic应用服务器)的一键式部署与恢复功能。 无论在哪种平台上工作,都推荐定期验证监听程序的工作状况以预防潜在故障的发生。可以通过简单的命令检查当前监听进程是否正常运作: ```bash lsnrctl status ``` 此命令适用于大多数类Unix系统以及Windows Server系列的产品线,并能提供关于端口占用情况、已知客户端链接数目等有用的信息片段[^2]。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值