1. What is pmon and smon? Difference between them? If either or both process fail then how can we monitor them?
2. Is lsnrctl same as tnslsnr? if i want to check for listener status then how would i do that?
will give me the status
but is grepping tnslsnr same as the above?
Hi All,
I have a 2 questions; 1 is oracle and another is korn shell
say TIME=20060928
desired output: 20060927
say TIME=20061001
DESIRED output: 20060930
If i substract one day from 'TIME' i am looking for previous day.
can anyone please suggest me how do i do this is SQL.
i... (4 Replies)
Perhaps someone here has some experience with this.
machine os RHE 4 6
oracle 10g RAC
disk is SAN attached clariion.
I have presented new disks to the host, so the machine sees all needed LUNS. powermt shows them, they are labeled and i have fdisk'd them.
They are visible across all RAC... (5 Replies)
Hi
All,
I have issued ps -ef | grep oracle command and i got these result
oracle 356394 1 0 09:32:06 - 0:03 oracleCMS (LOCAL=NO)
Now I can see user from here but I can not from which machine they are running this process. How can I see that?
Thanks,
Vishal (5 Replies)
Dear Sir/Madam,
I use the following way to call the oracle stored procedure in a perl script, but I do not know how to call a oracle function by the following way ?
# ARGV is the oracle stored procedure name with parameters
$str = "sqlplus -s <<-eof \n" .
"$db_login... (0 Replies)
I wanted to ask how do i assign the control files and archive log to be stored in different volume? I didn't come through any selection for that during the GUI installation. :)
Thanks in advance for any reply.
p/s:
I will appreciate it also if anyone can provide me a link for me to go... (1 Reply)
Hi,
we have PERL 64-bit build with Oracle 10g DBD . PERL database connection are working fine. Database upgraded to 11.2 and in PERL documents it says still use 10g DBD to connect to 11.2. when I try some test connections, I am getting this error . Did anyone see this error before .
I set the... (2 Replies)
I have an M5K with disk issues I'm trying to troubleshoot, and it's causing me some confusion. I know the host has four on-board HDDs, but the format command's output shows c0t0d0, c0t1d0, c3t0d0, and c3t1d0. cfgadm -al shows c0t3d0 as the DVD-ROM drive, and c1 and c2 as SAN disks. Confused yet?
... (2 Replies)
HI ,
Please guide to get the PL/SQL logic to retrieve parameter VALUES passed IN variable seperated with comma(,)
Say items =(MTH,WKL,DLY,QTR)
It should send above parameters seperatly USING LOOP condition IN the below IN clause
SELECT * FROM tb_data_storage
WHERE items IN... (4 Replies)
HI Guys ,
Below are the two columns ITEMS and STATE of table .
ITEMS STATE
'2345','ggdh','k5tg','dgyt','hFF' DF
'1234','ghyt','DDD','GHTD','ABF' PQ
Can we get output in PL/SQL in below way ?... (7 Replies)
I have one application server, which is Solaris non global zone (dsapid02-dt3d02 - 10.63.76.96) and a database server, which is Linux (db1-serv26 - 10.63.36.117 & 10.63.36.118).
Whenever database admin is starting listener, it starts filling listener log file. Within minutes, it will make file in... (6 Replies)
Discussion started by: solaris_1977
6 Replies
LEARN ABOUT DEBIAN
ocf_heartbeat_oralsnr
OCF_HEARTBEAT_ORALSN(7) OCF resource agents OCF_HEARTBEAT_ORALSN(7)NAME
ocf_heartbeat_oralsnr - Manages an Oracle TNS listener
SYNOPSIS
oralsnr [start | stop | status | monitor | meta-data | validate-all]
DESCRIPTION
Resource script for Oracle Listener. It manages an Oracle Listener instance as an HA resource.
SUPPORTED PARAMETERS
sid
The Oracle SID (aka ORACLE_SID). Necessary for the monitor op, i.e. to do tnsping SID. (unique, required, string, no default)
home
The Oracle home directory (aka ORACLE_HOME). If not specified, then the SID should be listed in /etc/oratab. (optional, string, no
default)
user
Run the listener as this user. (optional, string, no default)
listener
Listener instance to be started (as defined in listener.ora). Defaults to LISTENER. (unique, optional, string, no default)
SUPPORTED ACTIONS
This resource agent supports the following actions (operations):
start
Starts the resource. Suggested minimum timeout: 120.
stop
Stops the resource. Suggested minimum timeout: 120.
status
Performs a status check. Suggested minimum timeout: 60.
monitor
Performs a detailed status check. Suggested minimum timeout: 30. Suggested interval: 10.
validate-all
Performs a validation of the resource configuration. Suggested minimum timeout: 5.
meta-data
Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5.
methods
Suggested minimum timeout: 5.
EXAMPLE
The following is an example configuration for a oralsnr resource using the crm(8) shell:
primitive p_oralsnr ocf:heartbeat:oralsnr
params
sid=string
op monitor depth="0" timeout="30" interval="10"
SEE ALSO
http://www.linux-ha.org/wiki/oralsnr_(resource_agent)
AUTHOR
Linux-HA contributors (see the resource agent source for information about individual authors)
resource-agents UNKNOWN 03/09/2014 OCF_HEARTBEAT_ORALSN(7)