Visit Our UNIX and Linux User Community


SHELL KBASH with Oracle Edition-Based Redefinition


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting SHELL KBASH with Oracle Edition-Based Redefinition
# 1  
Old 11-08-2012
Oracle SHELL KBASH with Oracle Edition-Based Redefinition

hi everyone, i'm learning on Oracle 11g and my team have asked me for edition-based redifinition, have you the script? or another idea?

Thanks
# 2  
Old 11-08-2012
Seems that there's plenty of information available about this (i.e. like here) if you're willing to Google it.

Did you have a specific question about it, or something you don't understand?
# 3  
Old 11-08-2012
thanks for reply, i've visited this link and i'll want to know that i can to have the possibility for use script with this edition based? i've tried with this script like sample:
Code:
#!/bin/bash
UTENTE="$1"
PASSW="$2"
RETVAL='sqlplus "$UTENTE"/"$PASSW"<<EOF
BEGIN
  DBMS_SERVICE.modify_service(
    service_name   => 'oc11g.local',
    edition        => null,
    modify_edition => TRUE);
END;
/
EXIT;
EOF'

$RETVAL

but work only to connect, not on change edition....

Previous Thread | Next Thread
Test Your Knowledge in Computers #898
Difficulty: Medium
The Toybox project was started in 2012 and became a BSD-licensed BusyBox alternative.
True or False?

4 More Discussions You Might Find Interesting

1. Solaris

Can we configure link based IPMP in private connectivity in Oracle RAC

Hi I would like to know whether we can configure link based IPMP in private connectivity in Oracle RAC Regarsd ---------- Post updated at 04:35 PM ---------- Previous update was at 04:27 PM ---------- Here I am taking about in case of private connectivity through cross cable (6 Replies)
Discussion started by: sb200
6 Replies

2. Shell Programming and Scripting

calling 'n' number of shell scripts based on dependency in one shell script.

Hello gurus, I have three korn shell script 3.1, 3.2, 3.3. I would like to call three shell script in one shell script. i m looking for something like this call 3.1; If 3.1 = "complete" then call 3.2; if 3.2 = ''COMPlete" then call 3.3; else exit The... (1 Reply)
Discussion started by: shashi369
1 Replies

3. Shell Programming and Scripting

Need to Write Shell Script based off of this shell command

I'm trying to read a bunch of log files and output the lines that contain particular strings. To accomplish this, I've been running the following from the command line: find . -name "*" | xargs grep " " | grep " " > output.txt Two grep statements are needed in case I'm looking for a... (3 Replies)
Discussion started by: Rally_Point
3 Replies

4. Shell Programming and Scripting

how to schedule no of jobs based on the value from the oracle table

Hi all, Please help me with the issue im facing. my client has a recquirement that unix script has to schedule the no.of jobs based on the value from the oracle table.for example if the table has a value of 20 the unix script has to schedule 20 jobs.im able to write the script to get the value... (1 Reply)
Discussion started by: srikanths2s
1 Replies

Featured Tech Videos