这篇博客展示了在Oracle数据库环境中进行的一些操作，包括设置环境变量、登录数据库、使用SQL*Plus以及尝试运行AWR报告。在racdb2上，用户设置了ORACLE_BASE和PATH变量，并尝试用'stty kill'^X'退出。接着在racdb1上，他们尝试运行spsql命令但未找到，然后成功使用sqlplus登录并尝试执行AWR报告，但遇到了文件无法打开的问题。
命令：
stty kill '^X'
racdb2:/home/oracle #more .profile
stty kill '^X'
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin; export PATH
NLS_LANG=american_america.ZHS16GBK; export NLS_LANG
umask 022
登录
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> @
SQL> exit;
设置后登录
racdb1#[/home/oracle]stty kill '^X'
racdb1#[/home/oracle]spsql
sh: spsql: not found.
racdb1#[/home/oracle]sqlplus unissss/xxx
SQL*Plus: Release 11.2.0.3.0 Production on Wed May 2 14:06:56 2018
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> @?/rdbms/admin/awrrptl
SP2-0310: unable to open file "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/awrrptl.sql"
SQL> @?/rdbms/admin/awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
扫一扫
1364
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
