How To Configure Network Service By Script

Jul 5, 2013

I have created a batch for silent DB Creation through DBCA. I want to add a script to also create the Network Service after. I was told it can be done only with Response File. Is a response file a script also that can be executed after the DBCA scripts?Where can I find a manual with the available commands so I can produce what I need? On the internet I find only examples for Silent DB instalation. EDITOS is Windows 7 Oracle 11.2.0.1 I want to create the Network Service that will add these lines to the tsnames.ora.

DBNAME =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = wsName)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = dbname)
)
)

 on both the client and the server.How can i do it automatically through a batch script, so to add it to DBCA scripts after creation? I was told once in atopic that it could be done through a response file.

View 9 Replies


ADVERTISEMENT

How To Config Network Service By Script

Jul 5, 2013

I have created a batch for silent DB Creation through DBCA. I want to add a script to also create the Network Service after. I was told it can be done only with Response File.

Is a response file a script also that can be executed after the DBCA scripts? Where can I find a manual with the available commands so I can produce what I need? On the internet I find only examples for Silent DB installation.

edit-solution
Complete Solution posted as New article

[URL]..........

View 14 Replies View Related

SQL & PL/SQL :: Java Network Within 10g

Aug 18, 2010

I have a rather hard to trace problem which is keeping me up several days now. We want to implement a package for querying devices via SNMP in our database. There are no packages shipped with Oracle that come handy. UTL_TCP does not work because SNMP works via UDP. After all we came up with the idea to use URL.... Locally on my development machine and on the command line of the Oracle database our first prototype of the SNMP query function works very well, but inserted into the database all I'm getting is a "Request timed out". Firewall mechanisms can not be the problem because the java code runs smoothly on the command line and also a snmpwalk on the command line suceeds, so the database is not blocked by any firewall. First I thought some permission via Java are missing, but I took a look in the USER_JAVA_POLICY view and worked this with SYSDBA out. A java application in Oracle connection via TCP to port 80 and fetching a website works allright, the thing not working seems to be UDP.

View 3 Replies View Related

SQL & PL/SQL :: How To Configure RAC TO RAC Dataguard

Apr 27, 2012

i want to configure rac to rac dataguard 10g( primary is having 2 nodes and standby also 2 nodes).

oracle 10g/os linux5.

View 1 Replies View Related

Performing Expdp On Network Drive?

Jul 23, 2013

while try to expdp on network drive. getting below error.how can we perform the expdp on network drive

Network location: \\tsclient\p\expdp

1.)SQL> show user
USER is "SYS"

SQL> create or replace directory exp as '\\tsclient\p\expdp';Directory created.
SQL>Grant read,write on directory exp to system;

2.)expdp system/xxxxx@orcl directory=exp dumpfile=EXP_orcl_072013.dmp logfile=EXP_72013_1.log schemas=('IIMS','CMMN')

Export: Release 11.2.0.2.0 - Production on Tue Jul 23 13:48:07 2013
Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation

View 2 Replies View Related

Access Database In Network Using Toad

Feb 7, 2007

I'm using Oracle10.0 as database for my project and I have installed Toad as front end tool for the Oracle. Now I want to access the database in the network using the Toad.

My question is, is it compulsory that oracle should be installed in every system to access Toad or any thing can I change in the server system to access the database from other systems in the Network.

View 1 Replies View Related

Replication :: How Much Amount Of Data Over Network

Mar 1, 2011

I have implement multi master replication between two server.

How much amount of data transfer over the network? How to calculate this value?

View 2 Replies View Related

Replication :: Data Between 4 Databases In Network

Nov 22, 2012

We want to replicate the data between the databases.We have 4 databases in a network.If there will be any change in database 1,e.g. updation in any table,it should automatically replicate on other 3 databases.or user will change something in database 2 ,it should replicate on other 3 databases and vice versa. All 4 databases have same schema and same configuration.

View 1 Replies View Related

RAC & Failsafe :: Listener Went Offline During Network?

Aug 29, 2013

Recently we had faced network issue due to which node3 server was inaccessible.After the network issue got resolved , node3 was accessbile.So once the issue got fixed , i did a post validation in database and cluster and found listener , network1.org on node3 went offline.

When i try to start listener on node3,i got following error.
grid@RAC3 ~]$ srvctl start listener
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-2674: Start of 'ora.net1.network' on 'RAC3' failed
[grid@RAC3 ~]$ srvctl status vip -n RAC3
VIP RAC3-vip is enabled
VIP RAC3-vip is not running
[grid@RAC3 ~]$ srvctl status vip -n RAC2
VIP RAC2-vip is enabled
VIP RAC2-vip is running on node: RAC2
[grid@RAC3 ~]$ srvctl start vip -n RAC3
PRKO-2420 : VIP is already started on node(s): RAC2
[grid@RAC3 ~]$ srvctl status vip -n RAC3
VIP RAC3-vip is enabled
VIP RAC3-vip is not running
[grid@RAC3 ~]$ srvctl status nodeapps
VIP RAC1-vip is enabled
VIP RAC1-vip is running on node: RAC1
VIP RAC2-vip is enabled
VIP RAC2-vip is running on node: RAC2
VIP RAC3-vip is enabled
VIP RAC3-vip is running on node: RAC2
Network is enabled
Network is running on node: RAC1
Network is running on node: RAC2
Network is not running on node: RAC3
GSD is disabled
GSD is not running on node: RAC1
GSD is not running on node: RAC2
GSD is not running on node: RAC3
ONS is enabled
ONS daemon is running on node: RAC1
ONS daemon is running on node: RAC2
ONS daemon is not running on node: RAC3

bring up the listener on node3

View 11 Replies View Related

Server Administration :: Set-up Network Encryption

Sep 9, 2010

I am trying to set-up network encryption.I have added following parameters to my server side sqlnet.ora file:

SQLNET.ENCRYPTION_SERVER = REQUIRED
SQLNET.ENCRYPTION_CLIENT = REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER =RC4_256
SQLNET.ENCRYPTION_TYPES_CLIENT =RC4_256
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (MD5)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (MD5)

As per my understanding connections should start to fail from client side after addition of these parameter on server side sqlnet.ora (no changes to client side sqlnet.ora).I am still able to connect to this server without connections getting failed.

I already checked aso is installed on this database.Just to add it is a RAC database with 2 nodes.

View 4 Replies View Related

Clusterware :: Network Socket Files?

Oct 9, 2012

We were facing some issue with crs startup and had to delete network socket files present in "/var/tmp/.oracle/".

what these "/var/tmp/.oracle/*" files do?..What informations are there in these files?

View 2 Replies View Related

Configure Oracle 11g RAC With ASM Setup?

Aug 26, 2013

We wish to configure an Oracle 11g RAC with ASM setup for the internal employee training purpose. The requirement is as follows

1. Operating system Linux, Software Oracle 11g Release 2
2. Need to build total 5 individual clusters.
3. Each cluster with 2 Node
4. Need to configure ASM as a shared storage with real hardware. (No virtualization, Openfiler, NFS)
5. Need to configure RAC database.

provide me the hardware details for configuring Shared storage. Is there any specific Storage which we can use to configure ASM as a storage.

View 2 Replies View Related

How To Configure Charset Unicode

Aug 15, 2012

I need to configure character set for my database. I have 2 options:

AL16UTF16 - require 2 bytes per character (fixed length)
UTF8 - character length - 1 until 4 bytes. (variable length)

until here ok...

The AL16UTF16 certainly will occupy more space than UTF8. So my question is, When would I need use AL16UTF16 character set mode?

I hear one time, when a database write many values with the same length. it does it in the same HD cylinder. So the HD arm could with a single movement read all the fields in cylinder completely. Improving the read/write performance.

View 2 Replies View Related

Forms :: Configure Webutil For Use With 11g?

Jun 14, 2010

have a link to install/configure webutil for use with Forms 11g?

View 2 Replies View Related

Forms :: Configure Webutil In 10g?

Aug 3, 2012

how configure webutil in forms 10g. send me all the doc related to this.

View 2 Replies View Related

RAC & Failsafe :: Unable To Configure SSH For RAC

Dec 30, 2010

I am trying to install oracle 10g RAC on CentOS release 5.4 (Final), But when I am not able to configure SSH between oracle users on both node.

Node 1
--------
[oracle@node1 ~]$ id
uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
[oracle@node1 ~]$ date
Thu Dec 30 05:14:10 IST 2010
[oracle@node1 ~]$
------------
Node2
----------
[oracle@node2 ~]$ id
uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
[oracle@node2 ~]$ date
Thu Dec 30 05:15:32 IST 2010
[oracle@node2 ~]$
---------
OS
----------
[oracle@node2 .ssh]$ cat /etc/redhat-release
CentOS release 5.4 (Final)
[oracle@node2 .ssh]$ date
---------
Host for both node
--------
[oracle@node2 .ssh]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
# Public
10.1.1.10 node1
10.1.1.11 node2
#Private
20.1.1.10 node1-priv
20.1.1.11 node2-priv
#Virtual
10.1.1.21 node1-vip
10.1.1.22 node2-vip
------------------------
I am using the command to configure SSH provide in the link

[URL].......

View 7 Replies View Related

Windows :: Cannot Configure Listener

Aug 31, 2013

I've been trying to rebuild our Oracle 11g server. I started off by wiping Oracle completely and kicked off the install again. The install goes smoothly, but does not create the Listener. I've been trying to use netca to create it myself. The below is the output from netca:

Listner Control complete.
Listener start failed.

Looking in the netca trace file, I see the following error (note I'm only including the error with a few lines before):

[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:91] NativeResult: The String obtained is1|SUCCESSFUL
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:99] The status string is: 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:112] The result string is: SUCCESSFUL 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:787] _WS_: deleting service2 OracleRemExecService on AUSYD5756 ignoreNotExist = true
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:793] _WS_ deleteService2: node AUSYD5756 Service OracleRemExecService result: 0|Access is denied.
[code]....

The OracleRemExecService services does not exist. I've tried re-installing the whole instance a number of times but each time I hit this error.

View 12 Replies View Related

Network Adapter Could Not Establish The Connection In SQL Developer

Aug 25, 2010

I have installed oracle 11g in my personal laptop, when i open the sql developer and try creating the new connection. am getting "The network adapter could not establish the connection".

View 2 Replies View Related

Emulating MS Office NETWORK DAYS Function

Oct 29, 2010

The MS Office 'NETWORK DAYS' function allows you to subtract one date from another and return the number of 'workdays' between them. So it ignores Sat & Sun. There is an additional parameter that allows you to ignore holidays as well.

I'd like to subtract a 'Request Date' from SYSDATE and get just the number of 'workdays'.

View 3 Replies View Related

RMAN Backup To Shared Network Drive?

Feb 20, 2011

I scheduled a RMAN backup job to take FULL database backup to a shared network drive.

RMAN Script used:

RMAN> run
2> {
3> allocate channel ch1 device type disk format '\\BACKUP1635\X$\ARC%U';
4> backup database plus archivelog;
5> release channel ch1;
6> }

Environment: Windows server 2003 OS and Oracle 10.2.0.4.0

Iam facing below error.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 02/20/2011 18:19:46
ORA-19504: failed to create file "\\BACKUP1635\X$\ARC1BM55JL8_1_1"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

I checked shared network drive and found READ/WRITE access for me. I am able to take RMAN backup in local system without any issue.

View 4 Replies View Related

Utl-tcp Connection - Oracle Generic Network Error?

Aug 26, 2010

I have a client program that needs to communicate with another server program. My client program is implemented in PL/SQL using utl_tcp running on Oracle 9 while the server program is a 3rd party software running on Windows server 2003.

Basically my client program needs to send a request to the server, waits for the response (wait for the incoming string which ended /w chr(3) ) and then acknowledge (sending chr(6) ).

My problem is that if I wait for the chr(3) and then acknowledge. My send routine (l_sent := utl_tcp.write_text (g_conn, p_content) will raise a Oracle generic network error. It seems like the connection is closed. I checked /w the vendor and they said it might be I am taking too long to response ( I question timeout is the problem). I have also attempted to change my read routine from read_line to read_raw but it only make things worst. I cannot even read the complete string. At least with read_line, I can read back the entire string.

My current work around is to send out the ack before I receive the chr(3) (which is not recommended by our vendor).

View 5 Replies View Related

Forms :: Run Form Saved On Network Disk?

Dec 2, 2010

we are testing the oracle developer tools 11g and we have the followed issue.

If we run a form saved on the local disk, it's running properly but if we save the form on a local disk we get FRM-40010 Cannot read form XXXX.

Example:

TEST.fmx on C:Temp (Local disk) is running
TEST.fmx on T: (Network disk) FRM-40010

View 4 Replies View Related

Server Utilities :: FTP Dump File Over Network

Apr 19, 2010

I have A Daily hot backup using Expdp Command On oracle 10g R2 installed on the Linux server. And I'm trying to move this Dump File to Another directory on Windows server 2003 over network using Ftp script which will be run after the export process finished Automatically.

View 9 Replies View Related

Networking And Gateways :: Connecting To Database Outside Network?

Feb 14, 2011

i want to connect to a database that is out side my network and my application is running on forms 6i and database version is 10g .

View 2 Replies View Related

Data Guard :: Specifying A Network Path In SQL Query

Apr 18, 2013

I have created 2 PCs (1 for Primary DB (IT_SERVER), 2 for Standby DB (IT_SERVER2) on Oracle VM Virtual Box in order to check my Data Guard configuration.

I have created a Shared Folder on 2nd PC (IT_SERVER2) for Oracle Standby DB. Now when I issue my query from 1st PC (Primary DB) to Create a Parameter file on 2nd PC Shared Oracle Folder, it returns following errors

SQL> CREATE PFILE='\IT_SERVER2E:ORACLEPFILESTLDB2.ORA' FROM SPFILE;
CREATE PFILE='\IT_SERVER2E:ORACLEPFILESTLDB2.ORA' FROM SPFILE
*
ERROR at line 1:
ORA-09210: sftopn: error opening file
OSD-04002: unable to open file
O/S-Error: (OS 67) The network name cannot be found.

Then I try this

SQL> CREATE PFILE=\IT_SERVER2'E:ORACLEPFILESTLDB2.ORA' FROM SPFILE;
CREATE PFILE=\IT_SERVER2'E:ORACLEPFILESTLDB2.ORA' FROM SPFILE
*
ERROR at line 1:
ORA-00911: invalid character

What to do?

View 8 Replies View Related

Oracle Database 11.2.0.3 On RHEL 6.1 - OS Network Configuration

Jul 11, 2012

we are running Oracle database 11.2.0.3 on RHEL 6.1.

Should we join the above machine to an existing Windows 2003 (Active Directory) Domain? or Configure it as a standalone Server?.

View 9 Replies View Related

Oracle Restart / Change Network Interface Name

Oct 18, 2013

Oracle Restart 11.2.0.3 w/ASM. To improve redundancy we're planning to change the network configuration in our Oracle Restart environment from using 1 LAN interface to a bonded interface consisting of 2 interfaces.So the change will be from using "eth0" to using "bond0" consisting of "eth0" and "eth1". Are there any changes that must be done in the Oracle Restart configuration to reflect these changes?

View 7 Replies View Related

Configure RMAN Backup To Disk?

May 27, 2011

Am trying to configure rman to backup to a directory to a linux server on the network. Database is on windows server. Here is the parameter changes

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\\204.47.240.126\bexdisk\backup\%U'
;
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oraback/rman/sde_backups/%U';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

Here is my rman script

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
run
{
crosscheck archivelog all;

[Code]....

instead its backups but to my ORACLE_HOME\database directory..

how to configure rman to backup to this location

View 1 Replies View Related

Configure Failover And Load Balancing?

Jun 28, 2013

configure correctly my application, Oracle is version 11R1

My physical configuration is :

Site 1 (main building)
database on cluster : server1, server2
database : BASE1 available

Site2 (Backup Site)
database on cluster : server3, server4
database : DGBASE1 not available for users (dataguard)

I want to acces BASE1 first in load balancing server1,2 (normal usage) and DGBASE1 in load balancing server3,4 in case of failover after 5 retries of 10 secondes (in case of main buiding out of order, DGBASE1 will be available for users)

This is my actual setup :

(DESCRIPTION_LIST=(FAILOVER=ON)
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1234))

[Code]....

My trouble is that with this configuration, access it randomly BASE1 or DGBASE1 but DGBASE1 is not available for users then I have failure

What could be the right configuration to obtain BASE1 first in load balancing (normal usage) and DGBASE1 in load balancing in case of failover of the BASE1 after 5 retries of 10 secondes ?

View 1 Replies View Related

RAC & Failsafe :: Configure 10G On LINUX 5.0 Machine

Mar 9, 2011

provide me the online material or some links where i can follow the instructions step by step to configure 10G RAC on LINUX 5.0 machine.

I have 3 separate machines having Linux 5.0 . I want to do this for R&D purpose.

View 1 Replies View Related







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