Search Results

Search: Posts Made By: edstevens
23,516
Posted By edstevens
Missing pipe was it. I figured it would be...
Missing pipe was it. I figured it would be something simple where I just needed another set of eyes. Thanks.
23,516
Posted By edstevens
Egrep: conflicting matchers specified
This bit of code works fine:


egrep -i '^rmcat' /etc/oratab |\
awk -F\: '{print $1}'|\
while read ORACLE_SID
do



But when I modified it, thus:


egrep -v '^#' /etc/oratab |egrep -v...
4,185
Posted By edstevens
No joy. strings spfiledwdev.ora |od...
No joy.



strings spfiledwdev.ora |od -tx1c > edslist.lis;view edslist.lis


Then simply searched for every occurrence of 'r'. It only showed up as occurrences of the text 'r' (x'72'). ...
4,185
Posted By edstevens
OK, for the OS: oracle:$ uname -a Linux...
OK, for the OS:


oracle:$ uname -a
Linux <redacted server>.<redacted domain> 3.8.13-118.4.2.el6uek.x86_64 #2 SMP Tue Mar 22 20:47:10 PDT 2016 x86_64 x86_64 x86_64 GNU/Linux



I'm not sure...
4,185
Posted By edstevens
Strange results from 'strings | sort'
Using the 'strings' command and piping the result to 'sort' is producing strange results. I get block of lines that begin with asterisks, then a block that begins with some text, then more lines...
6,388
Posted By edstevens
vgersh99 - that was it. Thanks for the assist.
vgersh99 - that was it. Thanks for the assist.
6,388
Posted By edstevens
Command works at command line but not from cron
Oracle Linux 6.
Trying to set up a simple monitoring of memory usage. This command does exactly what I want at the command line:

echo $(date +%Y-%m-%d" "%H:%M:%S) $(grep PageTables...
3,788
Posted By edstevens
The first example worked for me, even though the...
The first example worked for me, even though the man page for sed on my system does not list the '-i' switch. My system is running Oracle Linux, which is derived from RHEL.

Thanks for the...
3,788
Posted By edstevens
Using sed to edit multiple files
Created a shell script to invoke sed to edit multiple files, but am missing something.
Here's the shell script:
oracle:$ cat edit_scripts.sh
#!/bin/sh...
3,500
Posted By edstevens
Out of desperation, I tried re-typing the entire...
Out of desperation, I tried re-typing the entire script from scratch - no copy and paste. This time it worked. :confused:

---------- Post updated 06-29-18 at 08:25 AM ---------- Previous update...
3,500
Posted By edstevens
I considered non-printing characters, but when I...
I considered non-printing characters, but when I put vi into hex mode to investigate I found nothing amiss. Just EOL (x'0A') where they should be.
0000000: 2321 2f62 696e 2f73 680a 4f52 4145 4e56 ...
3,500
Posted By edstevens
Problem with here-document not seeing delimiter
System is Oracle Linux 6 (derivative of RHEL)
Given this script (copied from vi with line numbering for reference)

1 #!/bin/sh
2 ORAENV_ASK=NO
3 echo...
2,370
Posted By edstevens
Bingo! The code that called the function looked...
Bingo! The code that called the function looked like this:

ORACLE_SID=''
PS3='Select database: '
savcol=$COLUMNS
export COLUMNS=20
#
while [[ $ORACLE_SID = "" ]]; do
select ORACLE_SID in...
2,370
Posted By edstevens
RudiC - I'm sorry, not x0D but x 0A. It's in...
RudiC -
I'm sorry, not x0D but x 0A. It's in the output I posted.

As for the format of /etc/oratab, no it is not created with Windows editor. This is pure linux, and /etc/oratab is a simple...
2,370
Posted By edstevens
Don Cragun - Adding the 'set' commands as...
Don Cragun -
Adding the 'set' commands as requested, here is the output (line numbers added for reference).


1 egrep -i "product/12" /etc/oratab |grep -v "listener"| awk -F\: '{print ...
2,370
Posted By edstevens
Rudic - To show the "raw" value of $ORACLE_SID...
Rudic -
To show the "raw" value of $ORACLE_SID at a command line:

oracle:hr92upg$ echo $ORACLE_SID
hr92upgAnd to show no hidden characters, I'll append an 'x' on each end:

oracle:hr92upg$...
2,370
Posted By edstevens
First, let me point out that I've edited my...
First, let me point out that I've edited my opening post, to add reference line numbers to all 'code' blocks. Herein I use the term 'code block' to refer to any section of my posts that are set off...
2,370
Posted By edstevens
Problem evaluating condition
First, given this bit of code (line numbers included for reference:
59 get_all_db () {
60 #echo getting all db
61 dblist=`egrep -i "product/12" /etc/oratab |grep -v "listener"|\
62 awk...
6,944
Posted By edstevens
Good catch. Of course, in this case a here...
Good catch. Of course, in this case a here document isn't even needed or warranted. A simple command line of

sqlplus -s darwin_ext@SRCDBCA/Da3w1n\#E5t @proc.sql

Would have sufficed, but...
6,944
Posted By edstevens
Valid points, all. But completely off-topic for...
Valid points, all. But completely off-topic for this forum. This is purely a question of how to compile a PL/SQL proc and zero to do with shell scripting. The OP really, really needs to take this...
6,944
Posted By edstevens
I see nothing fundamentally wrong with the...
I see nothing fundamentally wrong with the command you showed, though I would have done it. I'm not a fan of putting the password after the net service name. I showed you how I would have done it. ...
6,944
Posted By edstevens
Like I said, it has nothing to do with your shell...
Like I said, it has nothing to do with your shell script.
You'd be far better off posting this (with the actual contents of proc.sql and any errors it throws) on the appropriate OTN forum: Space:...
6,944
Posted By edstevens
I see nothing here to indicate this is a shell...
I see nothing here to indicate this is a shell scripting issue. If you are connecting to the database with sqlplus, then submitting the script:

SQL> @proc.sqlAnd not getting the results you...
2,307
Posted By edstevens
Confirmed, issue is a background task involved...
Confirmed, issue is a background task involved with Oracle Grid Infrastructure.
2,307
Posted By edstevens
Don - thanks for the reply. Except for the idea...
Don - thanks for the reply. Except for the idea of the links, that what I would have thought. Since this is a vm I build myself, I know there are no links involved, nothing else in the script to...
Showing results 1 to 25 of 100

 
All times are GMT -4. The time now is 07:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy