10 More Discussions You Might Find Interesting
1. Solaris
Hi guys, long time no typing :D
I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box.
Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I... (2 Replies)
Discussion started by: solaris_user
2 Replies
2. Shell Programming and Scripting
Hi experts.
I have different database and schema and their passwords in one file.
In Unix : I want to create the script that connect the sqlplus and execute the select query one by one schema with different database.
Ex: password File Format
databse schemaname password
DB1 name1 ... (1 Reply)
Discussion started by: abhigrkist
1 Replies
3. Shell Programming and Scripting
Hi all,
In my concern they gave a task to me do cran job like
To write a shell script for
To connect a database
it should execute a query
it should save the output of the query
after getting the output it should send a mail to you inbox for every one hour
I can able to... (8 Replies)
Discussion started by: thelakbe
8 Replies
4. Shell Programming and Scripting
Hai
i want to connect to oracle database from user input and create a view.
${ECHO} "Debut Creating View"
${ECHO} "Please Enter the User Name:"
read user_name
${ECHO} "Please Enter the Connection String:"
read con_string
${ECHO} "Please Enter the Password:"
read pwd... (3 Replies)
Discussion started by: shenthil76
3 Replies
5. Shell Programming and Scripting
Hi,
My requirement is to generate a single text output which fetches data from two different databases. I have two different sqrs to generate text file1(data from db1) and file2(data from db2). can I execute both the sqrs from a single shell script? If yes, pls let me know how to connect to db2... (1 Reply)
Discussion started by: vimalr
1 Replies
6. Shell Programming and Scripting
Hi,
I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not?
Can anyone help me in this regard?
Appreciate your help and concern.
Thanks,
Dave (1 Reply)
Discussion started by: yoursdavinder
1 Replies
7. UNIX for Advanced & Expert Users
I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies
8. Shell Programming and Scripting
if;
sql="select username from dba_users where username = '$FromUser';"
check_FromUser=`ExecSql "$sql"`
I want to connect to Oracle database & check the users in the database, store the value in check_FromUser.
First how to connect to Oracle database from the shell script ?
Appreciate your... (4 Replies)
Discussion started by: dreams5617
4 Replies
9. Shell Programming and Scripting
Hi,
While i am trying to connect to Oracle database from Perl using DBI module,am getting the error as follows :
Can't load '/usr/local/fuseperl-modules/lib/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libwtc9.so: cannot open shared object file: No such file... (4 Replies)
Discussion started by: DILEEP410
4 Replies
10. UNIX for Advanced & Expert Users
hello -
Is it possible to connect to a database at the command line to an Oracle instance whilst logged in on the unix box i.e. not using a script
Cheers
(Running Solaris)
Also if anyone has any info on how a Citirix ICA client might be helpful here that would be appreciated
Cheers (1 Reply)
Discussion started by: penfold
1 Replies
NETRESTRICT(5) AFS File Reference NETRESTRICT(5)
NAME
NetRestrict - Defines interfaces not to register with AFS servers
DESCRIPTION
There are two NetRestrict files, one for an AFS client and one for an AFS File Server or database server. The AFS client NetRestrict file
specifies the IP addresses that the client should not register with the File Servers it connects to. The server NetRestrict file specifies
what interfaces should not be registered with AFS Database Servers or used to talk to other database servers.
Client NetRestrict
The NetRestrict file, if present in a client machine's /etc/openafs directory, defines the IP addresses of the interfaces that the local
Cache Manager does not register with a File Server when first establishing a connection to it. For an explanation of how the File Server
uses the registered interfaces, see NetInfo(5).
As it initializes, the Cache Manager constructs a list of interfaces to register, from the /etc/openafs/NetInfo file if it exists, or from
the list of interfaces configured with the operating system otherwise. The Cache Manager then removes from the list any addresses that
appear in the NetRestrict file, if it exists. The Cache Manager records the resulting list in kernel memory.
The NetRestrict file is in ASCII format. One IP address appears on each line, in dotted decimal format. The order of the addresses is not
significant. The value 255 is a wildcard that represents all possible addresses in that field. For example, the value 192.12.105.255
indicates that the Cache Manager does not register any of the addresses in the 192.12.105 subnet.
To display the addresses the Cache Manager is currently registering with File Servers, use the fs getclientaddrs command.
Server NetRestrict
The NetRestrict file, if present in the /var/lib/openafs/local directory, defines the following:
o On a file server machine, the local interfaces that the File Server (fileserver process) does not register in the Volume Location
Database (VLDB) at initialization time.
o On a database server machine, the local interfaces that the Ubik synchronization library does not use when communicating with the
database server processes running on other database server machines.
As it initializes, the File Server constructs a list of interfaces to register, from the /var/lib/openafs/local/NetInfo file if it exists,
or from the list of interfaces configured with the operating system otherwise. The File Server then removes from the list any addresses
that appear in the NetRestrict file, if it exists. The File Server records the resulting list in the /var/lib/openafs/local/sysid file and
registers the interfaces in the VLDB. The database server processes use a similar procedure when initializing, to determine which
interfaces to use for communication with the peer processes on other database machines in the cell.
The NetRestrict file is in ASCII format. One IP address appears on each line, in dotted decimal format. The order of the addresses is not
significant.
To display the File Server interface addresses registered in the VLDB, use the vos listaddrs command.
SEE ALSO
NetInfo(5), sysid(5), vldb.DB0(5), fileserver(8), fs_getclientaddrs(1) vos_listaddrs(1)
COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 NETRESTRICT(5)