[simonsun@magic ~]$ sudo /etc/init.d/oracle10g stop
Stopping Oracle10g: iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Stopping iSQL*Plus ...
iSQL*Plus stopped.
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://magic.linux:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-SEP-2009 16:51:37
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
[simonsun@magic ~]$ su oracle
口令:
[oracle@magic simonsun]$ cd ~
[oracle@magic ~]$ export ORACLE_BASE=/home/oracle
[oracle@magic ~]$ export ORACLE_HOME=$ORACLE_BASE/database
[oracle@magic ~]$ export ORACLE_SID=SUNORA
[oracle@magic ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@magic ~]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
[oracle@magic ~]$ export PATH
[oracle@magic ~]$ cd $ORACLE_HOME
(
注,如果已经配置在环境变量里,可以不用这样手动配置
)
[oracle@magic database]$ ./bin/isqlplusctl start
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.
[oracle@magic database]$ ./bin/sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 7 16:54:40 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba;
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 608174080 bytes
Fixed Size 1220820 bytes
Variable Size 184553260 bytes
Database Buffers 415236096 bytes
Redo Buffers 7163904 bytes
Database mounted.
Database opened.
SQL> alter user sys identified by PasSwOrd;
User altered.
SQL> alter user system identified by PasSwOrd;
User altered.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@magic database]$ exit
[simonsun@magic ~]$ sudo /etc/init.d/oracle10g start
Starting Oracle10g:
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-SEP-2009 17:04:34
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/oracle/database/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/database/network/admin/listener.ora
Log messages written to /home/oracle/database/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=magic.linux)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 07-SEP-2009 17:04:34
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/database/network/admin/listener.ora
Listener Log File /home/oracle/database/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=magic.linux)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Processing Database instance "SUNORA": log file /home/oracle/database/startup.log
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
iSQL*Plus instance on port 5560 is already running ...
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://magic.linux:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control .......................... started.
------------------------------------------------------------------
Logs are generated in directory /home/oracle/database/magic.linux_SUNORA/sysman/log
[simonsun@magic ~]$ su oracle
口令:
[oracle@magic simonsun]$ cd
[oracle@magic ~]$ export ORACLE_BASE=/home/oracle
[oracle@magic ~]$ export ORACLE_HOME=$ORACLE_BASE/database
[oracle@magic ~]$ export ORACLE_SID=SUNORA
[oracle@magic ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@magic ~]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
[oracle@magic ~]$ export PATH
[oracle@magic ~]$ export ORACLE_HOME=/home/oracle/database/
[oracle@magic ~]$ cd $ORACLE_HOME
[oracle@magic database]$ ./bin/sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 7 17:10:41 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: sys/PasSwOrd@SUNORA as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
分享到:
相关推荐
oracle10g 默认用户名、密码解锁,适用于由于的用户时间久远忘记用户名、密码!
Oracle相关技术 -解决忘记oracle管理员密码 -oracle 10g 创建只读用户语法 -Oracle连接字符
oracle 11g忘记sys和system用户密码的解决方法 - 数据库 - 道客巴巴.png
oracle的sys和system密码是我们经常忘记的,忘记之后我们可以通过sqlplus来修改重置。 首先打开sqlplus:在运行处可直接输入打开 进入窗口后,首先输入 sqlplus/as sysdba 口令不要输入,直接回车 等...
3、 Oracle 10g 网页控制器 2 4、 关于OracleOrahome91TNSListener无法启动的问题 3 5、 ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE_NAME 错误的解决 3 6、 完全卸载oracle的过程 4 7、 数据库...
安装oracle 11g时,居然把刚刚更改的数据库管理员密码给忘了,google查询,终于找到修改方法。
如何重置oracle 10g SYS 的密码 安装完oracle 10g后,竟然将安装时设置的系统密码忘记。在同事的帮助下通过一下方法解决。 1.oracle的密码文件存在于:oracle_home/database/pwd<sid>.ora 2.使用orapwd 重置SYS密码 ...
1、如果忘记了ASM的dbsnmp、sysman用户的密码,可以重新设置,执行下面的 SQL> alter user dbsnmp account unlock identified by oracle; SQL> alter user sysman account unlock identified by oracle;
包含基本的oracle权限管理笔记,和oracle忘记密码的管理方法,是基于oralce10g和11g的相关资料,以后准备了继续上传,共同学习。
Oracle 中启动 Scott 用户 的方法 , 在 Oracle11gR2, (g 代表‘网络’的意思) 数据库中 Scott 这个用户 安装时是被锁定的, 安装 Oracle的时候 ,你可以直接选择 给该用户 解锁,如果忘记了解锁, 后期可以使用 ...
【忘记密码的解决办法】 1、停止mysql服务 2、mysqld(mysqld-nt) --skip-grant-tables 3、重新打开窗口cmd 4、输入mysql -u root -p 回车 无需密码 5、通过上述密码修改方法3修改密码 6、flush privileges 7...
G GDM:铃声、口哨声和声音板模块格式 GetRight:GetRight未完成的下载文件 GHO:Norton 克隆磁盘映像 GID:Windows 95全局索引文件(包括帮助状态) GIF:CompuServe位图文件 GL:动画格式 GRP:程序管理组 ...
GC是垃圾收集的意思(Gabage Collection),内存处理是编程人员容易出现问题的地方,忘记或者错误的内存回收会导致程序或系统的不稳定甚至崩溃,Java提供的GC功能可以自动监测对象是否超过作用域从而达到自动回收...
GC是垃圾收集的意思(Gabage Collection),内存处理是编程人员容易出现问题的地方,忘记或者错误的内存回收会导致程序或系统的不稳定甚至崩溃,Java提供的GC功能可以自动监测对象是否超过作用域从而达到自动回收...