It is related to Linux, Oracle 9.2.0. I am new to Oracle.
I am trying to connect to Oracle database say A, but as I am running this command dbstart the error is
“ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor”
I have successfully started lsnrctl. Here... (3 Replies)
Recently I was struggling to resolve ORA-12514 error, after I solved that there is a another error "TNS-12535: TNS: operation timed out". For your information in my machine I have disabled firewall & also added SQLNET.EXPIRE_TIME = 10. But the problem is still persists. Again all your help is... (2 Replies)
Hi all
We connect to 10 Oracle Databases from our UNIX box through the regular TNS file we have on any oracle client installation.
Recently we acquired a new connection. I added the entries as usual to the TNS file. The connection fails with the below error message
ORA-12541: TNS:no... (2 Replies)
Hi all,
Am intermittently getting the following errors on one of my databases.
Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302:... (1 Reply)
Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command?
In following "grep" command I want to exclude "ORA-01653" error
grep -i ORA alert.log >>/tmp/ora_errors.txt
... (7 Replies)
Hi,
I am facing a strange issue when connecting to SQLPLUS via a shell scripts.
I am using Linux 2.6.18-274.18.1 and gbash shell.
When I connect to SQLPLUS through scripts then it throws TNS Time Out error ""sometimes"" and connects successfully other times.This is only happening when... (9 Replies)
Platform: Oracle Linux 6.3
From a log file, I want to grep all lines with the pattern "TNS-" but I want to skip those with the pattern "TNS-12514" . How can I do this ? (3 Replies)
I have requirement to replace old TNS entries with New one in multiple files.
one file may contain more then one occurrence of tns.
Example: Below is the one of occurrence in a current file(s). i am interested to replace only red part.
<connection-pool name="Google_APP_CP"... (4 Replies)
Hi,
User claim that job is running slow from their end.
I DBA found in database the below errors in alert log file.
ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576
ORA-27626: Exadata error: 2201 (IO... (2 Replies)
Discussion started by: Maddy123
2 Replies
LEARN ABOUT DEBIAN
ocf_heartbeat_sapdatabase
OCF_HEARTBEAT_SAPDAT(7) OCF resource agents OCF_HEARTBEAT_SAPDAT(7)NAME
ocf_heartbeat_SAPDatabase - Manages any SAP database (based on Oracle, MaxDB, or DB2)
SYNOPSIS
SAPDatabase [start | stop | status | monitor | meta-data | validate-all]
DESCRIPTION
Resource script for SAP databases. It manages a SAP database of any type as an HA resource.
SUPPORTED PARAMETERS
SID
The unique SAP system identifier. e.g. P01 (unique, required, string, no default)
DIR_EXECUTABLE
The full qualified path where to find sapstartsrv and sapcontrol. (unique, optional, string, no default)
DBTYPE
The name of the database vendor you use. Set either: ORA,DB6,ADA (unique, required, string, no default)
NETSERVICENAME
The Oracle TNS listener name. (unique, optional, string, no default)
DBJ2EE_ONLY
If you do not have a ABAP stack installed in the SAP database, set this to TRUE (unique, optional, boolean, default false)
JAVA_HOME
This is only needed if the DBJ2EE_ONLY parameter is set to true. Enter the path to the Java SDK which is used by the SAP WebAS Java
(unique, optional, string, no default)
STRICT_MONITORING
This controls how the resource agent monitors the database. If set to true, it will use SAP tools to test the connect to the database.
Do not use with Oracle, because it will result in unwanted failovers in case of an archiver stuck (unique, optional, boolean, default
false)
AUTOMATIC_RECOVER
The SAPDatabase resource agent tries to recover a failed start attempt automatically one time. This is done by running a forced abort
of the RDBMS and/or executing recovery commands. (unique, optional, boolean, default false)
DIR_BOOTSTRAP
The full qualified path where to find the J2EE instance bootstrap directory. e.g. /usr/sap/P01/J00/j2ee/cluster/bootstrap (unique,
optional, string, no default)
DIR_SECSTORE
The full qualified path where to find the J2EE security store directory. e.g. /usr/sap/P01/SYS/global/security/lib/tools (unique,
optional, string, no default)
DB_JARS
The full qualified filename of the jdbc driver for the database connection test. It will be automatically read from the
bootstrap.properties file in Java engine 6.40 and 7.00. For Java engine 7.10 and higher the parameter is mandatory. (unique, optional,
string, no default)
PRE_START_USEREXIT
The full qualified path where to find a script or program which should be executed before this resource gets started. (unique,
optional, string, no default)
POST_START_USEREXIT
The full qualified path where to find a script or program which should be executed after this resource got started. (unique, optional,
string, no default)
PRE_STOP_USEREXIT
The full qualified path where to find a script or program which should be executed before this resource gets stopped. (unique,
optional, string, no default)
POST_STOP_USEREXIT
The full qualified path where to find a script or program which should be executed after this resource got stopped. (unique, optional,
string, no default)
SUPPORTED ACTIONS
This resource agent supports the following actions (operations):
start
Starts the resource. Suggested minimum timeout: 1800.
stop
Stops the resource. Suggested minimum timeout: 1800.
status
Performs a status check. Suggested minimum timeout: 60.
monitor
Performs a detailed status check. Suggested minimum timeout: 60. Suggested interval: 120.
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 SAPDatabase resource using the crm(8) shell:
primitive p_SAPDatabase ocf:heartbeat:SAPDatabase
params
SID=string
DBTYPE=string
op monitor depth="0" timeout="60" interval="120"
SEE ALSO
http://www.linux-ha.org/wiki/SAPDatabase_(resource_agent)
AUTHOR
Linux-HA contributors (see the resource agent source for information about individual authors)
resource-agents UNKNOWN 03/09/2014 OCF_HEARTBEAT_SAPDAT(7)