07-29-2008
oh!
on problem run this in sqlplus locally
however,after logon remote server and run this in sqlplus, also prompt ''PL/SQL procedure successfully completed',but no run actually
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need help . I am not getting anything back from my setup. I have defined an oracle package which I am calling from within my sql call, but is returning no rows. If I run my sql from sqlplus works find, does not work whe I try to run from UNIX shell script
My korn script test.ksh
#!bin/ksh... (6 Replies)
Discussion started by: TimHortons
6 Replies
2. Shell Programming and Scripting
Hi,
Can anyone tell me how to call a oracle package from a Unix shell script? I want to pass some input parameters to package and it will return me the output which I want to use further in my shell script. I want to know the way to capture the output values in my shell script. Please send some... (1 Reply)
Discussion started by: anil029
1 Replies
3. UNIX for Advanced & Expert Users
Friends,
Please let meknow, How we can find the dependancies of .dstream package & .rpm package before installation ?
For AIX, We can use the inutoc . command to create the .toc file for the bff package, What about Solaris & Linux ? (0 Replies)
Discussion started by: yb4779
0 Replies
4. UNIX for Dummies Questions & Answers
Hello,
i have downloaded an rpm package "hadoop-0.20.205.0-1.amd64.rpm"
in /usr/local/ directory.
I'm trying to install the rpm package in a new path/location (/usr/local/hadoop-0.20.205), but i can't.
I did:
1st try: Didn't work
sudo rpm -i --prefix=/usr/local/hadoop-0.20.205... (1 Reply)
Discussion started by: g_p
1 Replies
5. Emergency UNIX and Linux Support
Hello,
i have installed a package by using the command
sudo rpm -i filepackage.rpm
package filepackage is already installed
when i try to remove it, i get an error saying "is not installed":
sudo rpm -e filepackage.rpm
error: package filepackage is not installed
How can... (4 Replies)
Discussion started by: g_p
4 Replies
6. Red Hat
Hey i have a package in oracle to validate file mask. can i call it in through
shell script . if yes , how
Thanks (1 Reply)
Discussion started by: ramsavi
1 Replies
7. Shell Programming and Scripting
How to call oracle package in shell file
in my shell file, I have
Export SQL FILE =$Home_dir select.sql
if I want to add call two function in package
how can I do it :( (2 Replies)
Discussion started by: Hscript
2 Replies
8. UNIX for Dummies Questions & Answers
Version: Oracle Linux 6.6
I am trying to set up DNS for forward and reverse lookups. I am new to BIND package.
I have installed the following packages. bind (includes DNS server, named)
bind-utils (utilities for querying DNS servers about host information)
bind-libs (libraries... (0 Replies)
Discussion started by: kraljic
0 Replies
9. Programming
Hi Guys,
I am having a sql script file which does below operations
ALTER TABLE M1
EXCHANGE PARTITION FOR (TO_DATE('&1','dd-MON-yyyy'))
WITH TABLE &2
INCLUDING INDEXES;
i need to pass variables in such a way that if i pass start date and end date as parameter , something like my... (2 Replies)
Discussion started by: rohit_shinez
2 Replies
LEARN ABOUT SUNOS
delete-instance
asadmin-delete-instance(1AS) User Commands asadmin-delete-instance(1AS)
NAME
delete-instance - deletes the instance that is not running.
SYNOPSIS
delete-instance [--user admin_user] [--password admin_password] [--host localhost] [--port 4848] [--local=false] [--domain domain_name]
[--passwordfile filename] [--secure|-s]instance_name
Use the delete-instance command to delete the instance that you specify. The delete-instance command can be run both locally and remotely.
To delete the instance locally, not requiring the administration server to be up and running, specify the --local option. To delete the
instance remotely, the administration server must be running on the hostname and port number specified. The user authenticates using the
password identified for the administration server. Additionally, the instance must already exist within the domain served by the adminis-
tration server. Use this command with discretion since it is destructive and there is no undo.
OPTIONS
--user administrative user associated for the instance.
--password administrative password corresponding to the administrative user.
--host host name of the machine hosting the administrative instance.
--port administrative port number associated with the administrative host.
--domain name of the domain.
--local determines if the command should delegate the request to administrative instance or run locally.
--passwordfile file containing passwords appropriate for the command (e.g., administrative instance).
--secure if true, SSL/TLS to communicate with the administrative instance.
OPERANDS
instance_name name of the instance to be deleted.
Example 1: Using delete-instance in local mode
asadmin> delete-instance --domain domain1 server1
Deleted Instance server1 successfully
Where: the server1 instance for the domain1 domain is deleted on the local machine.
Example 2: Using delete-instance in remote mode
asadmin> delete-instance --user admin --passwordfile passwords.txt --host localhost --port 4848 server1
Deleted Instance server1 successfully
Where: the server1 instance for the domain associated with the specified user, passwords in the password file, host, and port number is
deleted on the remote machine.
EXIT STATUS
0 command executed successfully
1 error in executing the command
INTERFACE EQUIVALENT
Server Instance page
asadmin-create-instance(1AS), asadmin-start-instance(1AS), asadmin-stop-instance(1AS), asadmin-restart-instance(1AS)
J2EE 1.4 SDK March 2004 asadmin-delete-instance(1AS)