For example, you want to list all the directories from /home/oracle directory. To do that run the below command in sql prompt:
SQL> host ls /home/oracle
a Documents links.txt Pictures Templates afiedt.buf Downloads Music psit test Desktop labs oradiag_oracle Public Videos Continue reading
When trying to start dbconsole, I got below error on my linux server
bash-3.00$emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 18.104.22.168
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Starting Oracle Enterprise Manager 11g Database Control…………….
Please verify the targets.xml file and notice all the information are correct. If no values in it, then copy the information”agentseed”, EMD_URL and host from your emd.properties file(located under $ORACLE_HOME/<instance name>/sysman/config directory) and add in the targets.xml.
<Target TYPE=”oracle_emd” NAME=”oracle.test.com:1158″/>
<Target TYPE=”host” NAME=”oracle.test.com”/>
Then, please ensure that database and listener is up and running and run the below commands from oracle Grid home bin directory (e.g in my case /u01/app/oracle/product/11.2.0/grid/bin
emctl stop dbconsole
emca -repos drop
emca -repos create
emca -config dbcontrol db
Default location of spfile or pfile is $ORACLE_HOME/dbs, however if you are not sure, then run the below command using sqlplus:
SQL> show parameter spfile;
Name Type Value
————– —————— —————————–
spfile string /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora
With ASM, the spfile is often located into an ASM disk group.
Space usage in the flash recovery area is automatically monitored by Oracle database. Warning messages are written to the alert logs when the space usage has reached 85% and a critical warning is issued when the space usage nears 97%. Oracle also removes files that are on the obsolete file list when there is less than 10 percent free space available. Alternatively dba_outstanding_alerts view can be queried to get the details about the warnings and suggested actions:
SQL> SELECT OBJECT_TYPE, MESSAGE_TYPE, MESSAGE_LEVEL,
To determine the port number, check the portlist.ini file. Ports for some oracle database applications are listed in the portlist.ini file, it can be located in the $ORACLE_HOME/install directory
On oracle 11g, the homepage for a Database gives the error:
‘The database target is currently unavailable. The state of the components are listed below.’
Database Instance: Status Open
Listener: Status Up
Agent Connection to Instance: Status Unavailable Details
Please make sure that status of the dbsnmp database user is NOT locked.
Then run “emctl clearstate agent” and “emctl upload agent” to resolve the issue