Database Administration (MOSC)

MOSC Banner

How to quickly kill database Process for Could backup

edited Jun 15, 2018 2:41PM in Database Administration (MOSC) 5 commentsAnswered
 Hi all, I have problem with my Ebs database when i try to stop db in the dbTier the actives session prevent the normale  shutdown of database,
this active session is represented by database process having NO LOCALE :
ps -eaf | grep oraclePROD
 oraprod 16134     1  0 09:39:51 ?         0:14 oraclePROD (LOCAL=NO)
    root 22751 22221  1 11:01:02 pts/ta    0:00 grep oraclePROD
 oraprod  7911     1  0 07:48:10 ?         0:00 oraclePROD (LOCAL=NO)
 oraprod  8031     1  0 07:48:13 ?         0:00 oraclePROD (LOCAL=NO)
 oraprod  8023     1  0 07:48:13 ?         0:02 oraclePROD (LOCAL=NO)
 oraprod  8037     1  0 07:48:13 ?         0:00 oraclePROD (LOCAL=NO)
 oraprod  9781     1  0 08:12:18 ?         0:15 oraclePROD (LOCAL=NO)
 oraprod 20474     1  0 10:12:27 ?         0:03 oraclePROD (LOCAL=NO)
 oraprod 20507     1 37 10:13:08 ?         0:33 oraclePROD (LOCAL=NO)
 oraprod  7857     1  0 07:48:04 ?         0:00 oraclePROD (LOCAL=NO)
 oraprod  7730     1  0 07:47:28 ?         0:00 oraclePROD (LOCAL=NO)
 oraprod  8296     1  0 07:48:41 ?         0:22 oraclePROD (LOCAL=NO)
 oraprod  8516     1  0 07:49:44 ?         0:18 oraclePROD (LOCAL=NO)
can i kill this process for a normale shutdown

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center