Server Administration :: Remote External Jobs On Windows?

Jun 14, 2011

I cannot run a Scheduler remote external job on Windows. Here's what I'm doing:

--Check that XDB isinstalled:
desc resource_view
--Check that MTS is running
sho parameters dispatcher
sho parameters shared_Server
--Setup an http listening port:
exec dbms_xdb.sethttpport(8080)

[code].....

This is the error:

orcl> select job_name, status, error#, actual_start_date, additional_info
2 from user_scheduler_job_run_details where job_name='TRYIT';
TRYIT
FAILED -1.074E+09
15-JUN-11 02.16.54.583000 EUROPE/LISBON

[code].....

I am certain that the communications and the credentials are correct, I've tried variants and get different errors. I think the problem is the job action. I've tried running batch files as well as OS commands, same result. THere is nothing useful in the core dump. Is there perhaps a Windows specific technique for running external jobs? Some way of nominating the batch file, or specifying a command interpreter?

View 1 Replies


ADVERTISEMENT

Server Administration :: Migration Of Oracle Jobs

Nov 22, 2010

Recently we are planning to migrate oracle 10g to 11g. We are migrating PHASE WISE (Schema wise) as this is a 50TB of Production instance. We are using Oracle Golden gate for this purpose.

Is there is any way that we can migrate oracle jobs from 10g to 11g?

View 6 Replies View Related

Windows :: Connecting Oracle To Remote Access Server?

Mar 2, 2011

Is it possible to connect Oracle to MS Access database sitting on remote server? I need to join the tables in Oracle and MS Access.

View 5 Replies View Related

Server Administration :: DBMS Scheduler Jobs Are Not Running

Jan 12, 2011

I have scheduled few jobs (scheduled for each day) which has not run today, which was running successfully till yesterday. When I query dba_scheduler_jobs, i could see last_run_date as yesterday's date 6am and next_run_date is still showing today's date and time (it should show tomorrow's date/time).

View 3 Replies View Related

Server Administration :: Disabling All DBMS-SCHEDULER Jobs?

Jul 13, 2010

When performing test recoveries of a database we often wish to prevent database jobs from running application processes such as (a) sending emails; or (b) logging events to a central logging database. In order to accomplish this, we set the job_queue_processes to zero before opening the database.

This means that no dbms_jobs run on the open instance, but it does not prevent dbms_scheduler jobs from running.How can we prevent any dbms_scheduler jobs from running?

I have looked at setting the MAX_JOB_SLAVE_PROCESSES attribute using DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE, but this cannot be set to zero.

View 3 Replies View Related

Server Administration :: Task To Reschedule Database Jobs To A Different Date

Jun 21, 2010

I had a task to reschedule database jobs to a different date as they were Running Statistics job running during business hours..

I used dbms_job.change procedure for the same
On Thursday i.e. 17th June i changed a job as follows
exec dbms_job.change(11, NULL, TRUNC(SYSDATE+2), 'TRUNC(SYSDATE+7)');

When i checked the status today querying user_jobsi found that the job was started today at 00:57 hrs.

I checked the alert logs as well but couldn't find any errors. How to proceed with the troubleshooting for this issue.

View 3 Replies View Related

Server Administration :: Creating / Running Jobs In Oracle 9i For Solaris

Sep 5, 2005

How to

1) to define a job in oracle9i for solaris
2) to schedule this job

Remember i have prior experience deploying jobs at windows platform but when i try it on (9i for ) solaris, the script does not work as it does not accept a submit job request.

View 4 Replies View Related

Server Administration :: Jobs Created When Upgrade To Oracle 11.1 Version?

Feb 8, 2012

what jobs will be created when we upgrade to oracle 11.1 version ?

View 4 Replies View Related

Windows :: Copy A File To DB Server From A Remote Machine Using Plsql / Java

Oct 2, 2013

We want to copy a file from a remote machine to the DB server. copy \<IP_ADRESS>SHARED_FOLDERsome_file.sql d:copied_file.sql

I've used Java and a wrapped it into a PL/SQL procedure so I can do :

exec run_os_command(p_command => 'copy \<IP_ADRESS>SHARED_FOLDERsome_file.sql d:copied_file.sql');

The file was not copied.

I have mapped \<IP_ADRESS>SHARED_FOLDER to x: for example and issued : exec run_os_command(p_command => 'copy x:some_file.sql d:copied_file.sql');

The file was not copied.

But when I issued from the OS prompt copy x:some_file.sql d:copied_file.sql then the file is copied.

What can I add to the PL/SQL procedure so it wil work ?

View 19 Replies View Related

Server Administration :: How To Connect Oracle Client To Remote Server DB

Jun 29, 2013

I'm trying to connect a oracle client application on the client machine to a remote oracle server on the server machine but i get a connection fail.

On the server machine I configured oracle server in the following way:

Installed oracle server. Created a database "DB_Test" with the database configuration assistant Created a LISTNER with the Oracle NET Manager with the following parameter:

Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521 Created "dbtest" service with the Oracle NET Manager with with the following parameter:
Service Name: "dbtest" Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521

All services on the server machine are running and I opened port number (1521) in the router. On the client machine I installed SQL PLUS and SQL Developer.

With SQL Plus as by the official documentation I have entered the following command:

CONNECT username/password@[//]host[:port][/service_name]. In my case is:
CONNECT SYSTEM/oracledb@//ENZOVAIO:1521/testdb.

With SQL Developer I have entered the same parameter.

But with both SQLPlus and SQL Developer the connection fails.

View 14 Replies View Related

Server Administration :: Connect 500+ Client To Remote Oracle Server?

Aug 10, 2010

we have oracle server. we have to connect 500+ client machine to oracle server.

is it i need to install client version to all 500+ or any other shortcut way?

View 6 Replies View Related

Server Administration :: Setup Remote DB?

Jan 27, 2011

setup REMOTE DATABASE (or provide me a good link, which tells step by step procedures).

View 4 Replies View Related

Server Administration :: Unable To Access Remote Database Using DBLink

May 21, 2010

We have created a new db link. But we are not able access the remote database. When we are trying to access any table using db link system is getting hanged.

We would like to know what are the parameters/permissions which affect the db link access either at data base level or at server level.

One observation we made is that that particular db link is not getting dropped when we tried to drop it.

View 2 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

Apr 8, 2010

My manager is asking to create a SQL scrip, which will provide following information.

Our database is 9.2.0.7.0 on Windows 2000 Server

-How many records Insert / Update or Delete daily in my Oracle database?

- Check Archive log / Redo Log switching information?

-Check database growth ?

View 10 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

Jun 27, 2012

I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).

All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.

View 3 Replies View Related

Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .

View 22 Replies View Related

Server Administration :: Oracle 11g R2 Installation On Windows 2008 64 Bit Server

Apr 19, 2011

I want to install Oracle 11g R2 in windows 2008 64 bit server. How can I know whether my server is ready to install Oracle ie is all components are available in server or any patch is to be applied etc.

View 3 Replies View Related

Windows / .NET :: Call External Dll From Stored Procedure

Jun 6, 2013

I have function in stored procedure which call function from another .net dll, is a first step. And this dll call function from unmanaged dll, is a second step.I do not have any problem in the first step, but when i do second step i have error:

ORA-20100: System.Security.SecurityException
System.Security.Permission.SecurityPermission
at ...
at ...
ORA-06512: at "SYS.DBMS_CLR", line 243
ORA-06512: ...
ORA-06512: ...

when i am deploying proceduse i set security levels "external".

View 0 Replies View Related

Backup & Recovery :: Automating RMAN Backup Jobs In Windows

Jun 26, 2012

My automated RMAN backup plan.

ShutdownDB1.bat
set oracle_sid = pldg
C:oracleproduct10.2.0insqlplus.exe /nolog @c:oraclebackupshutdowndb2.sql

ShutdownDB2.sql (called by the previous batch file)
set echo on
spool C:oraclebackupShutdownDB.log
connect /@pledgemaker as sysdba
shutdown immediate
spool off
exit

<Here there will be a thirty minute window or so while I XCOPY the Oracle Inventory and Oracle Home directories.>

RMANBackup1.bat
set oracle_sid=pldg
C:oracleproduct10.2.0BIN
man.exe target / cmdfile = 'c:oraclebackup
manbackup2.scr'
log = 'c:oraclebackupRMANBackup.log'

RMANBackup2.scr (called by the previous batch file)
startup mount
backup database
alter database open
exit

View 15 Replies View Related

Server Administration :: Oracle XE On Windows XP

Apr 26, 2012

I have oracle XE installed on my machine and it was working absolutely fine for the last year or so. Today there was an trojan intrusion which caused some issues with my windows xp OS like hiding some files, desktop etc. After everything was cleaned up and things back to normal. I am having issues with XE.

1. I can start and stop XE with out any issues
2. When I use the run sql command line, I can connect using - connect sys/sys as sydba.
3. I can also run a query to see all the users and see the HR user also.

However,
1. When I connect to my hr user using connect hr/password@xe, it just hangs
2. I tried the- go to Oracle XE admin page but it just hangs for a long time and returns page cannot be found.
3. I can tnsping the xe instance.

Is a fresh install the only option? or is there any way to correct this using the sys/sys user?

View 9 Replies View Related

Server Administration :: Installing Oracle 10G On Windows 7?

May 21, 2010

I already succeded to setyup Oracle 10 G on my machine , when trying to connect by system/system it does not connect.The listener is OK and instance ok.

View 10 Replies View Related

Server Administration :: Transferring Database From 11.1.0 Windows 32 Bit To 11.2.0 64 Bit

Mar 30, 2011

I wanted to transfer my database from Oracle 11.1.0. on windows 2003 server 32 bit to Oracle 11.2.0. windows server 2008 64 bit

i have done following

1)On new server of 11.2.0 windows 2008 64 bit use rman backup from Oracle 11.1.0. on windows 2003 server 32 bit to restore the database and recover the database when i try to open the database Alter database open it gave me message that i should start my database as upgrade I start the database with upgrade

STARTUP UPGRADE and then run following

@?/rdbms/admin/utlirp.sql

and then run following

@?/rdbms/admin/utlu112i.sql

and then run

@?/rdbms/admin/catupgrd.sql

during run of catupgrd.sql after around 30 minutes of run, i got error
ORA-03113: end-of-file on communication channel

but i reconnected myself with database again and shutdown the database and open it in normal mode and it has opened there were thousands of uncompiled objects and i recompiled them.

Only uncompiled objects left 60 are 'OLAPSYS' (Locked user) USER and 30 of PUBLIC user (all Synonyms)

Have i taken correct steps?

What should i do now to check that everything will be alright in future

View 6 Replies View Related

Server Administration :: Installation Of 11g On Windows 7 32bit

Feb 10, 2012

I have installed 11g R2 on windows 7 32bit then I uninstall it through deinstall but now again i am installing it it says

Cause - The chosen installation conflicted with software already installed in the given Oracle home.

Action - Install into a different Oracle home.

How can I remove that Oracle Home.

View 8 Replies View Related

Server Administration :: Whether Oracle 9i Works In Windows 2012

May 14, 2013

know whether Oracle 9i works in Windows 2012? As we are planning to upgrade.

View 1 Replies View Related

Server Administration :: Getting Error While Applying PSU Patch On Windows

Apr 7, 2011

We are applying PSU JAN 2011 patch 10349197 on windows server 2007. While applying the patch we are getting the below error.

Following files are active :

E:oracleproduct10.2.0inoraclient10.dll
E:oracleproduct10.2.0inorapls10.dll
E:oracleproduct10.2.0inoracommon10.dll
E:oracleproduct10.2.0inorageneric10.dll
E:oracleproduct10.2.0inoraplp10.dll
[code]........
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:

1) OUI-67620:Interim patch 10349197 is a superset of the patch(es) [ 8559466 ]
in the Oracle Home
--------------------------------------------------------------------------------
Its not an rac. We stopped all the services running on this server.

OPatch failed with error code = 74

View 4 Replies View Related

Server Administration :: Install Oracle 11g On Windows 7 - Just IP Address Available

Jan 17, 2013

With just the ip address available, how to install the oracle 11g software on windows 7? What are the access I will need in order to Install the oracle 11g software and create the oracle 11g database on windows 7?

View 7 Replies View Related

Server Administration :: Install Oracle 10g In Windows 7 Home Premium

Feb 20, 2010

I need to install Oracle 10g in windows 7 home premium which version of oracle 10g will work better with Windows 7 home premium. I need to download «& install.

View 5 Replies View Related

Server Administration :: Unable To Use More Than 2GB Memory For Oracle In Windows 2003

Jun 17, 2011

I have a 11g database installed on a windows 2003 server. When I created the database I could not assign more than 2GB for SGA_TARGET where as I have 16GB of RAM available on the server. I created the database with SGA_TARGET as 1.5 GB and Memory_TARGET as 2GB. I could create the database successfully. Later when I again tried to increase SGA_TARGET to 6GB and MEMORY_TARGET to 8GB, I could not start the database. I got below error;

ORA-27102: out of memory

OSD-00022: additional error information

O/S-Error: (OS 8) Not enough storage is available to process this command

Quote:I added /pae in the boot.ini
Added AWE_WINDOW_SIZE key to registry as 2000000000
Set use_indirect_data_buffers=true
added db_block_buffer=131072 (ie. 2GB DB_BLOCK_SIZE=16kb)
java_pool_size= 1000M
large_pool_size=1000M
shared_pool_size=2000M

I got again the same error

I could not use SGA_TARGET. So is AMM not allowed with AWE?

View 21 Replies View Related

Server Administration :: Oracle EE 11gR2 On Windows 7 Pro - Oradmin.exe Missing?

Oct 10, 2012

My problem is when trying to use oradmin.exe. It doesn't exists apparently. I have Database Creation Assistant and Net Creation Assistant, I can open and run sqlplux.exe and run sql commands, but oradmin.exe seems to be missing.

This is a new install of Oracle EE 11gR2 on Windows 7 Pro.

View 2 Replies View Related







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