11-03-2007
Need Info
Hi,
I'm a oracle DBA with little knowledge of Unix.
I wanted to write some shell scripts which will be helpful for DBA's regular activity.
As i'm a new to oracle with unix can any plese tell me what are all the activities can be done throgh Unix Shell Scripts also suggest me how to learn unix shell scripts quickly.
Thanks in Advance
Gobinathan
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
from the man page of su:
EXAMPLES
Example 1: Becoming User bin While Retaining Your Previously
Exported Environment
To become user bin while retaining your previously exported
environment, execute:
example% su bin
Example 2: Becoming User bin and ... (4 Replies)
Discussion started by: afflack
4 Replies
2. Shell Programming and Scripting
i know this is a stupid question but...can awk do more than print? can i have it assign a value from a file list to a variable in the script? (1 Reply)
Discussion started by: MadHatter
1 Replies
3. UNIX for Dummies Questions & Answers
i have a file that contain lines like this
9.4.7.8.5.7.9.0.5.7.1.2.msisdn.sub.cs. 1 IN CNAME SDP01.cs.
there are about 50,000 lines like this in the files i want to the extract the digits from the above line like:-
947857905712
OS Solaris9 (3 Replies)
Discussion started by: muneebr
3 Replies
4. Shell Programming and Scripting
Hi, pls advise how could we merge contents of lines from 2 different files into 1 file but shares common label continously as in the following example:
Thanks in advance...rgds.
File1:
// line: 0
abc
def
// line: 1
ghi
jkl
File2:
// line: 0
mno
pqr
// line: 1
stu
vwx
End... (3 Replies)
Discussion started by: Manan
3 Replies
5. Solaris
Hi,,,,,
My question is :
i have to backup a file system of size 92 GB
/dev/dsk/c1t1d0s2 135G 92G 41G 70% /data
i use the command :
ufsdump 0cfu /backup/c1t1d0s2 /dev/rdsk/c1t1d0s2 ......
the output file of the backup is only 2 GB it's normal ?? or i have do a... (0 Replies)
Discussion started by: tt155
0 Replies
6. Shell Programming and Scripting
Hi
how can I know the details of when valid system users last logged on?
thanks (1 Reply)
Discussion started by: nokia1100
1 Replies
7. Forum Support Area for Unregistered Users & Account Problems
I hadn't logged on here in several months. I want to update my info, such as the email address that I can be contacted at, but I don't see any links to do that. (1 Reply)
Discussion started by: cleopard
1 Replies
8. UNIX for Dummies Questions & Answers
Hiya all ... i am a newbie to UNIX,
Just want to knwo what this command does:
/sbin/ifconfig eth0 | grep 'inet addr:' | cut -d: -f2 | awk '{ print $1}'
I think, 'grep shows the line with 'inet addr' (which is the 2nd line, displaying the IP Address, Broadcast Address and Subnet Mask) ... Is... (8 Replies)
Discussion started by: ad4m88
8 Replies
9. Shell Programming and Scripting
I have this working ksh, and it returns like below:
LOGICAL VOLUME: prod_2048_005 VOLUME GROUP: prod1vg
TYPE: raw WRITE VERIFY: off
PHYSICAL VOLUME: hdisk108 VOLUME GROUP: prod1vg
TOTAL PPs: 1023 (130944 megabytes) VG DESCRIPTORS: 1
USED PPs: 904 (115712 megabytes) MAX REQUEST: 1 megabyte... (1 Reply)
Discussion started by: Daniel Gate
1 Replies
10. UNIX for Advanced & Expert Users
I need to find a way to query the OS (on Linux or Unix) to get details about the host machines processor type and the primary hard drive serial number. Is this possible?
Thank you for any Guru help you can provide! (2 Replies)
Discussion started by: Pug
2 Replies
LEARN ABOUT CENTOS
radsqlrelay
RADSQLRELAY(8) FreeRADIUS helper program RADSQLRELAY(8)
NAME
radsqlrelay - relay SQL queries to a central database server
SYNOPSIS
radsqlrelay [-?] [-d sql_driver] [-b database] [-f file] [-h host] [-u user] [-P port] [-p password] [-1] [-x] file_path
DESCRIPTION
radsqlrelay tails a SQL logfile and forwards the queries to a database server. Used to replicate accounting records to one (central) data-
base, even if the database has extended downtime.
The SQL logfile is created by the rlm_sql_log module. The module must be configured in the radiusd server before you can use radsqlrelay.
OPTIONS
-? Print usage help information.
-d sql_driver
Driver to use: mysql, pg, oracle.
-b database
Name of the database to use.
-f file
Read password from file, instead of command line.
-h host
Connect to host.
-u user
User for login.
-P port
Port number to use for connection.
-p password
Password to use when connecting to server.
-1 One-shot mode: push the file to database and exit.
-x Turn on debugging.
file_path
The pathname of the SQL logfile to use.
NOTES
Oracle driver
The command "radsqlrelay -d oracle -b db.domain.tld sql-relay" reads the database description stored in $TNS_ADMIN/tnsnames.ora:
db.domain.tld =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = <DB SID>)
)
)
SEE ALSO
rlm_sql_log(5)
AUTHOR
Nicolas Baradakis <nicolas.baradakis@cegetel.net>
19 June 2005 RADSQLRELAY(8)