SQL & PL/SQL :: How To Consume Exposed Services Of Sharepoint

Mar 2, 2010

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 Replies


Restarting Oracle Services Through Services.msc Is Faster Than Manual

May 17, 2013

Restarting 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?

View 3 Replies View Related

Buffer Cache Size Consume Full SGA_target

Jun 14, 2013

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 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

View 2 Replies View Related

Forms :: Consume A Webservice And Use In Oracle Form Developer 6i

Dec 26, 2011

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], [], [], [], [], []

View 16 Replies View Related

RAC - CRS Services?

Feb 7, 2011

I have 10g 2 node cluster running on Linux OS (redhat 4). Oracle version is 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 Related

Services On Oracle RAC

Mar 24, 2011

I 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?

View 1 Replies View Related

PL/SQL :: How To Call Web Services

Oct 31, 2012

how to call web services from PL/SQL? Steps, pros and cons, etc....

View 8 Replies View Related

Using Services To Correlate Workloads To Instances In RAC

Jan 17, 2011

We 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!)

View 3 Replies View Related

Disable All The Services For Node D Temporarily?

Dec 28, 2010

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 Related

RAC & Failsafe :: Unable To Communicate With CRS Services

Sep 13, 2010

i 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

View 3 Replies View Related

Create Two Services In One Oracle Client?

Feb 10, 2011

I have to create the two services(SID) in the same orcale 10g home.

View 2 Replies View Related

PL/SQL :: How To Call Web Services From Oracle Database 10g

Nov 11, 2012

How can i call web services from oracle database 10g ?

View 3 Replies View Related

Server Administration :: Few Cluster Services Are Down

Nov 9, 2010

on 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?


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

View 1 Replies View Related

Dbconsole Missing In Startup And Services.msc?

Jun 27, 2013

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

View 4 Replies View Related

Services Not Registered With Static Listener?

Jun 11, 2013

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 = 


View 13 Replies View Related

Listener Does Not Currently Know Of Services Requested In Connect Descriptor

Oct 3, 2012

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 Related

Networking And Gateways :: Oracle Heterogeneous Services

Mar 13, 2010

I 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

# 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.

View 3 Replies View Related

RAC & Failsafe :: Services On Node Automatically Down After Few Minutes?

Jan 4, 2011

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


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


View 1 Replies View Related

RAC & Failsafe :: 5 Node Database - Services Management

Aug 17, 2012

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 Related

Networking And Gateways :: Listener Support No Services

Jan 24, 2012

i 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 - 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)))
Version TNSLSNR for Solaris: Version - 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

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

View 14 Replies View Related

RAC & Failsafe :: CRS-4535 / Cannot Communicate With Cluster Ready Services

Nov 21, 2012

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


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)


View 2 Replies View Related

Windows :: Tool To Monitor Oracle Host And Services?

Jun 29, 2010

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 Related

Networking And Gateways :: Oracle Net Services Configuration Failed

Jul 10, 2008

when 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..

View 2 Replies View Related

Data Guard :: V$DATAGUARD_STATUS - Log Transport Services Warning

Nov 1, 2012

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:


------------------------ ------------- ---------- ----------- ---------- --- --------
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.

View 3 Replies View Related

Application Express :: Defining Proxy Server For Web Services

Dec 5, 2012

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][]

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Dataguard Trigger For Linux Services?

Oct 3, 2012

we are running oracle database 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.

View 2 Replies View Related

Application Express :: Web Services - Replicating Data From One Instance To Other

Jul 3, 2013

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 Related

Clusterware :: CRS-4535 - Cannot Communicate With Cluster Ready Services

May 23, 2013

We 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.

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE Production
TNS for Linux: Version - Production
NLSRTL Version - Production

View 3 Replies View Related

Forms :: Using Java Importer Tool To Invoke Web Services From Oracle?

Feb 1, 2011

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.

View 5 Replies View Related

Client Tools :: Oracle Services For Microsoft Transaction Server?

Apr 2, 2012

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

Copyrights 2005-15 www.BigResource.com, All rights reserved