Tag Archives: Oracle 11g

how to run OS commands in the sqlplus command prompt

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

Leave a comment

Filed under Oracle

oracle 11g- emctl start dbconsole fails on standalone grid

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 11.2.0.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.

Starting Oracle Enterprise Manager 11g Database Control…………….
………………………………………………………………………………… failed.

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.

E.g:

<Targets AGENT_SEED=”259930272″>
<Target TYPE=”oracle_emd” NAME=”oracle.test.com:1158″/>
<Target TYPE=”host” NAME=”oracle.test.com”/>
</Targets>

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

Leave a comment

Filed under Oracle

oracle 11g – Location of SPFILE or PFILE

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.

Leave a comment

Filed under Oracle

how to figure out the issues with flash recovery area in oracle database.

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,
REASON, SUGGESTED_ACTION
FROM DBA_OUTSTANDING_ALERTS;

Leave a comment

Filed under Oracle

How to get port number list of Enterprise manager in Oracle 11g?

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

Leave a comment

Filed under Uncategorized

Oracle 11g: OEM shows:The database target is currently unavailable

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

Solution:
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

Leave a comment

Filed under Oracle