| Check DB listener and Read Only from DB query [message #460632] |
Sun, 13 June 2010 13:13  |
casttree
Messages: 83
Registered: August 2008
|
Member |
|
|
I need to display the parameter and status of DB for listener and Read Only.
I know those value could be get from command line , but could we get the values of Listener and Read only by SQL/PlSQL? So I can get it through the query of DB.
Thanks,
|
|
|
|
|
|
| Re: Check DB listener and Read Only from DB query [message #460636 is a reply to message #460633] |
Sun, 13 June 2010 14:47  |
casttree
Messages: 83
Registered: August 2008
|
Member |
|
|
I hope to check if the value for listener and read only can be retrieved from table, so I can get it from SQL or PL/SQL through JDBC.
From lsnrctl status, we can show the listener , but it is a little difficult to integrate it in java code. For Read only, I only know Alter Tablespace xxx Read Only, I don't know how we can check if a table space is read only or not by SQL or unix command.
Thanks,
|
|
|
|
|
|
|
|
|
|
| Re: Check DB listener and Read Only from DB query [message #460668 is a reply to message #460638] |
Mon, 14 June 2010 01:02 |
casttree
Messages: 83
Registered: August 2008
|
Member |
|
|
Thanks, but I realized that there are multiple table spaces and could have different status for each table spaces (online, read only) . It is not what I need, sorry for providing the wrong information.
I need the read only status for DB (like through ALTER DATABASE OPEN READ ONLY) , do we have the table for DB read only information ?
Thanks,
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
