Hi,

What is the input the shell script will take and will all the users need same privilege?

Regards

Let us know at what step in the article, you are getting the error? Also how you created shared disks?

Dear,

If you are using below parameters, then comment them and restart the database.

#use_indirect_data_buffers=TRUE

Regards

Admin

Please paste the complete content of spfile.

strings spfile.ora

Dear,

Please post the content of pfile or spfile u r using .

We will update you on this

Make sure PATH, ORACLE_HOME values are  set properly.

then do which tnsping.

Dear,

We never do tnsping of the ip, we do tnsping of the tns alias defined in tnsnames.ora.

if tnsnames.ora file looks as this.

DBACLASS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 182.20.204.2)(PORT = 1540))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBACLASS)
)
)

Here the alias name is DBACLASS.

tnsping command will be :

tnsping DBACLASS

Regards

Admin

Dear ,

You cant use v$lock view to find blocking sessions. For finding blocking sessions you need to check gv$session only.

The query with the v$lock will always return rows because transactions happen regularly in the database. It doesn’t mean that you have blocking sessions.

Below is the best query to find blocking sessions. If it shows no rows means you dont have blocking sessions present.

SELECT
s.inst_id,
s.blocking_session,
s.sid,
s.serial#,
s.seconds_in_wait,
s.event
FROM
gv$session s
WHERE
blocking_session IS NOT NULL;

Regards

Forum Admin

Dear,

In the query you are using s.seconds_in_wait >10 , means it will reporting the blocking session where waiting time is more than 10 seconds.

Use the below query to find the blocking sessions.

SELECT
s.inst_id,
s.blocking_session,
s.sid,
s.serial#,
s.seconds_in_wait,
s.event
FROM
gv$session s
WHERE
blocking_session IS NOT NULL;

Regards

FORUM ADMIN