Hi All,
i need you help while accessing the value from anonymous PL/SQL block.
Initially our requirement was to get the value from SQL statement. I was doing like...
But now i need to use dbms_application_info.set_module in it. So i have planned to use anonymous block instead of SQL... (2 Replies)
Hi :),
I have installed CA Autosys in my Unix system. It contains 3 ( .pm ) files namely AutoSys.pm, Job.pm, Status.pm ....... in a directory CA.
Am trying to work with autosys for first time. Please guide in how do i connect autosys to oracle DB in my system. My oracle db name is XE..
Thank... (0 Replies)
Hi :),
Am new to work with Autosys. I have Oracle installed in my computer. Please guide me how to configure and connect autosys with oracle database.
thank you..!:) (0 Replies)
Hi,
I am trying to connect to oracle database (9.2.0.7.0) through Sun solaris.
But I am unable to do so.
The content of my script is as follows:
Shell Sript:
RESULT=`$ORACLE_HOME/bin/sqlplus schema/'pwd'@db << EOF
set echo on;
set feedback on;
@/home/count/qry.sql`
echo... (10 Replies)
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (1 Reply)
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (26 Replies)
I have a table called CLARIFICATION in one of my schema in Oracle Data Base. I have to connect to oracle Data Base from Unix and compare the one of the column(Exec_Date) in CLARIFICATION table with Sysdate.If Exec_Date = Sysdate go head and run rest of the script otherwise exit out with out... (2 Replies)
I am working in production support in an leading bank and more of my job is more in oracle/plsql. I am learning unix shell scripting and have started development in the same.I would like to know regarding the scope of these two in the industry.Also would like to know about other scripting... (2 Replies)
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)
I previously worked for the L1 support on DNS/Apache servers in solaris10......
Now our team lead wants me to work on Oracle/plsql server for our new client....
I've to work without training...
How can we know that Oracle/plsql server running in our machine ??
How to Administrate... (1 Reply)
Discussion started by: vamshigvk475
1 Replies
LEARN ABOUT ULTRIX
rcp
rcp(1c)rcp(1c)Name
rcp - remote file copy
Syntax
rcp [ -p ] file1 file2
rcp [-r] [-p] file... directory
Description
The command copies files between machines. Each file or directory argument is either a remote file name of the form rhost:path, or a local
file name. Local file names do not contain colons (:) or backslashes () before colons.
Note that the command refuses to copy a file onto itself.
If path is not a full path name, it is interpreted relative to your login directory on rhost. To ensure that the metacharacters are inter-
preted remotely, a remote host's path can be quoted by either using a backslash () before a single character, or enclosing character
strings in double (") or single (') quotes.
The command does not prompt for passwords; your current local user name must exist on rhost and allow remote command execution via
The command handles third party copies, where neither source nor target files are on the current machine. Hostnames may also take the form
rname@rhost to use rname rather than the current user name on the remote host. The following example shows how to copy the file foo from
user1@mach1 to user2@mach2:
$ rcp user1@mach1:foo user2@mach2:foo
Note that the file .rhosts on mach2 in user2's account must include an entry for mach1 user1. Also note that it may be necessary for the
person implementing the command to be listed in the .rhosts file for mach1 user1.
By default, the mode and owner of file2 are preserved if file2 already exists. Otherwise, the mode of the source file modified by on the
destination host is used.
Options-p Preserves the modification times and modes of the source files in its copies, ignoring the
-r Copies files in all subdirectories recursively, if the file to be copied is a directory. In this case the destination must be a
directory.
Restrictions
The command is confused by output generated by commands in a .cshrc file on the remote host. In particular, `where are you?' and `stty:
Can't assign requested address' are messages which can result if output is generated by the startup file.
See Alsoftp(1c), rlogin(1c), rsh(1c)rcp(1c)