I have to create a spool file using pl/sql (Oracle 10g/Solaris environment) and then copy the file from solaris environment to sharepoint(windows machine) folder. How to implement this(copy to sharepoint ) in pl/sql.
View 8 RepliesRestarting oracle services through services.msc is faster then manual (In command prompt).
Even If we have heavy transaction on the oracle database But we can restart the database within minutes by using services.msc But It will take more time in command prompt(sql>shu immediate). So shall we assume here that services.msc is using shut abort command while restarting the database?
If sga Buffer Cache Size consume full of SGA_target size, if possible that it will cause performance any issue. I am facing CPU 100% consuming while single query execute, Which query generate monthly report data.
I have two question
1)How to fix the CPU 100% consuming
2)How to find total number user hit oracle specific schema.
Oracle 10.2.0.5 Standard
Sga_target : 14G
Sga_max :20G
Pga :3G
Below SGA details
NAME BYTES/1024/1024
-------------------------------- ---------------
Fixed SGA Size 2.01795197
Redo Buffers 13.9804688
Buffer Cache Size 13632
Shared Pool Size 640
Large Pool Size 16
Java Pool Size 16
Streams Pool Size 16
Granule Size 16
Maximum SGA Size 20480
Startup overhead in Shared Pool 208
Free SGA Memory Available 6144
I write a Function in PL/SQL to consume a webservice and its working fine when i run in TOAD or SQL terminal. But when i try it from oracle form developer 6i , it gives me the following error :
ORA-00600: internal error code, arguments: [26599], [1], [211], [], [], [], [], []
I have 10g 2 node cluster running on Linux OS (redhat 4). Oracle version is 10.2.0.5.0. The problem is when the CRS get start all the services are online but when i try to connect DB, its connecting to idle instance. When I check the details the backgroundprocesses all get started but instance not started. Later i stopped the background processes and start the instance manually using sqlplus, the DB instance started and I can connect. But when i check the crs service status (crs_stat -t), the instance and service status are offline, nodeapps services are online. When i try to restart (crs_start) it throws up error.
View 3 Replies View RelatedI have a 2 node RAC database. I have a service defined as a preferred service for one node and Available for the other node. the service was relocated to the available node. I want to know when it failed over and why. Where would I get this information?
some time After the service failed over to the other node I got connection issues for this service. I relocated the service and the issues went away. Why did it not relocate the service back to the preferred node when these issues were encountered?
how to call web services from PL/SQL? Steps, pros and cons, etc....
View 8 Replies View RelatedWe have a new requirement for a RAC environment. Its workload will comprise both OLTP and batch loads. Am I right in thinking that I can map the appropriate applications to the required node using services, e.g.
Application 1 (OLTP) has node 1 as its preferred service node - so all OLTP trxs run through node 1
Application 2 (Batch) has node 2 as its preferred service node - so all batch trxs run through node 2
Both applications will have the other node for its available service to facilitate HA in an emergency.
Does that sound right? (or have I got it completely wrong!)
There are 4 nodes in a RAC environment A,B,C,D..For instance i want to disable all the services for node D temporarily and hand over the Node D to the system admin guys and after the maintainance is done I want to restart the services again on node D..
View 1 Replies View Relatedi have a problem with DATABASE i have 2 nodes where all application on Node2 are tunning properly
[oracle@node2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora....de1.gsd application ONLINE ONLINE node1
ora....de1.ons application ONLINE ONLINE node1
ora....de1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
[code]....
I have to create the two services(SID) in the same orcale 10g home.
View 2 Replies View RelatedHow can i call web services from oracle database 10g ?
View 3 Replies View Relatedon 6th of August at 02:36 our following cluster services were down,i see the logs and found that ASM is down and disk group are not accessible and ASMb process is terminated and both instances was restarted, i checked the cluster services so five services were down and these are
Quote: ora_ OCR_DG.DG, ora_fedb96.asm2.asm, ora_fedb96.gsd, ora_fedb96.ons and ora_fedb96.oc4j...
I restarted the services and they were successfully up and application become available . What can be the reason of the service failure?
alert.log
ORA-03113: end-of-file on communication channel
Process ID:
Session ID: 157 Serial number: 6655
ASMB (ospid: 23903): terminating the instance due to error 15064
Mon Aug 06 02:36:38 2012
NOTE: Deferred communication with ASM instance
Errors in file /u01/app/oracle/diag/rdbms/grid12/grid91/trace/grid91_ora_25856.trc:
ORA-15055: unable to connect to ASM instance
ORA-01092: ORACLE instance terminated. Disconnection forced
[code]...
I have download and installed the trial version of oracle 11g enterprise on windows 2008 r2 in vmware workstation. I couldn't see the database control in start up as my destination path c:oracleyourdatabaselocationdboc4jj2eeoc4j_DBConsole though I tried to open manually https://<localhost, ipaddress, domainname>:1158/em but its failed to open. I also tried to recreate the db using below commandemca -deconfig dbcontrol db -repos dropemca –config dbcontrol –repos createGot some info from below details:[URL]
NOTE: Moreover dbcontrol services missing in services.msc
what configurations I do the static listener shows no services.Here is my listener.ora
:SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME=ELLISON9) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME=ELLISON9) ) ) LISTENER11G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora1)(PORT = 1522)) )ADR_BASE_LISTENER = /u01/app/oracle My tnsnames.ora:ELLISON9 =
[code]...
I am new to oracle DBA. I have just installed the oracle on centos. when i create the oracle database for the first time then listener created and worked sucessfully. but when i stop the listener and start again. I get message "Listener does not currently know of services requested in connect descriptor.
View 1 Replies View RelatedI have following file setup for Oracle heterogeneous services for MS Access. I also need to add one more dsn for MS Excel.
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = MyConn
HS_FDS_TRACE_LEVEL = 0
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
Note: MyConn is for MS Access that I cretaed.
Can we use like this
HS_FDS_CONNECT_INFO = MyConn1, MyConn2,etc.
I have installed Oracle 10g RAC crs and asm on CentOS release 5.4. When I am rebooting the nodes and starting crs manually All the services on both nodes starting successfully.
---------------------------------------------------------
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
[code].....
But After a Few time/min few services goes down automatically and its show something like
---------------------------------------------------------
[root@rac1 ~]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE UNKNOWN rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
[code].....
We have 5 node RAC database. I want to user 2 node for OLTP and 3 for DSS system. Guide now to create service for the requirement.
View 10 Replies View Relatedi have created a listener for my db and register the service to it some 2 years back now i have checked it and it display as follows
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 13:49:44
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 24-JAN-2012 13:45:44
Uptime 0 days 0 hr. 3 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
[code]....
now i have stop and then restart but same status? so how can i manually register it again or anyother solution as i cant run netmgr
RAC star crs failed
[root@tyan147 crsd]# /orahome/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
cssd.log
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnpm_connect: [at clsgpnpm.c:1100] GIPC gipcretConnectionRefused (29) gipcConnect(ipc-ipc://GPNPD_tyan147)
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnpm_connect: [at clsgpnpm.c:1101] Result: (48) CLSGPNP_COMM_ERR. Failed to connect to call url "ipc://GPNPD_tyan147"
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnp_getProfileEx: [at clsgpnp.c:546] Result: (13) CLSGPNP_NO_DAEMON. Can't get GPnP service profile from local GPnP daemon
2012-11-21 11:12:29.313: [ default][3613030480]Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
2012-11-21 11:12:29.313: [ CSSD][3613030480]clsgpnp_getProfile failed, rc(13)
[code]....
What tool can be used to monitor Oracle host on Windows environment if the database goes down? I know about "Nagios" but like to know is there any other tool available?
View 6 Replies View Relatedwhen iam running netca on oracle llg iam getting the following error..[wstdba@ora11g ~]$ netca
java.io.FileNotFoundException: /oraeng/app/oracle/product/11.1.0/app/oracle11g/cfgtoollogs/netca/netca_OraDb11g_home1-0802284PM3437.log (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
at oracle.net.ca.NetCA.main(Unknown Source)
Oracle Net Services configuration failed. The exit code is -1...All my services are up and running..
OS read hat, oracle enterprise edition 11g release 2, dataguard 2 physical standby's
everything works fine but since 1 day we get following warnings from dataguard on the primary server:
SELECT * FROM V$DATAGUARD_STATUS;
FACILITY SEVERITY DEST_ID MESSAGE_NUM ERROR_CODE CAL TIMESTAM
------------------------ ------------- ---------- ----------- ---------- --- --------
MESSAGE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Log Transport Services Warning 0 309911 0 NO 01.11.12
RTC returned 2, disabling RTC for next 2 I/Os.
in the alert log it looks like this:
RTC returned 2, disabling RTC for next 2 I/Os.
Thu Nov 01 12:09:46 2012
RTC returned 2, disabling RTC for next 2 I/Os.
Re-enabling RTC following backoff interval 2.
Re-enabling RTC following backoff interval 2.
RTC returned 2, disabling RTC for next 2 I/Os.
RTC returned 2, disabling RTC for next 2 I/Os.
Re-enabling RTC following backoff interval 2.
Re-enabling RTC following backoff interval 2.
Thu Nov 01 12:11:16 2012
RTC returned 2, disabling RTC for next 2 I/Os.
Re-enabling RTC following backoff interval 2.
I'm trying to create a web service via the WSDL wizard (Apex 4.0.2). We are behind a firewall and connect to the internet via a proxy server. The proxy server requires authentication with a username and password. How to include the username and password in defining the Proxy Server in the Application Definition page or optionally in the alternate location in the Manual Web Service wizard page?
I assume the base definition for the proxy server is [http://]host[:port][]
we are running oracle database 11.2.0.3 and tomcat on the same machine(SLES 11).
I need to contol tomcat(start/stop) depending to database status. For example, if database stops or become standby then to stop tomcat service.
I'm basically experimenting with the concept of replicating data from one instance to the other. Using this thread as a guide, I was wondering if I could create a service on an Apex 4.0 instance, and have an application apex.oracle.com consume that service?
View 0 Replies View RelatedWe have 3 node RAC. In one of the node clusterware is down and also CSSD process is down. I got to know that we have to clear socket files in that node.what needs to be done instead ofclearing socket files.
database
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
[code]...
I am trying to use the Java Importer tool to invoke web services from Oracle forms.
During my research on Java Importer tool, I found that Quote:"The class browser lists all of the Java classes found on the CLASSPATH. The classes are ordered in the same way that they are represented in the CLASSPATH."
The above quote is from Oracle Documentation.
I want to know where I can find the CLASSPATH so that I can add new Java Classes to it. Our forms builder runs on Unix environment.
I want to use SSIS,when i use oracle 10g as a data source to SQL Server 2008 as Destination, it gives error ora-01017 invalid username/password logon denied, i did normal oracle installation and give full privileges(sysdba or sysoper) to the user(sys,system...),when i check connection it shows test connection succeeded but when click on next it gives above error.
View 3 Replies View Related