Error - Connection to host as user oracle failed: ERROR: NMO not setuid-root (Unix-only)

Error in Oracle Enterprise Manager:

Error - Connection to host as user oracle failed: ERROR: NMO not setuid-root (Unix-only)

Solution:

Re-implementation of the $ORACLE_HOME/root.sh, the problem is resolved.

Step 1: Login as oracle user and Stop Enterprise manager control using emctl start dbconsole

Step 2: Login as root and execute $ORACLE_HOME/root.sh

Ste3 : Login as oracle user and Start Enterprise Manager Control using emctl stop dbconsole

Setting Count Retrieval for Oracle Discoverer Desktop

Below Sections describes about setting the count for retrieval of records from Oracle Discoverer Desktop.

Log on to Discoverer Desktop

Go to Tools -> Options as shown in the figure below (Image1)



A dialog box is opened and then go to “Query Governor” tab





Then change the value to your requirement under “Limit retrieved data to”
Now the user will be able to retrieve all records without any error.

Query to Find Sessions using Temporary Tablespace (TEMP)

SELECT b.tablespace, ROUND(((b.blocks*p.value)/1024/1024),2)||'M' "SIZE", a.sid||','||a.serial# SID_SERIAL, a.username, a.program
FROM sys.v_$session a, sys.v_$sort_usage b, sys.v_$parameter p
WHERE p.name = 'db_block_size'
AND a.saddr = b.session_addr
ORDER BY b.tablespace, b.blocks;