RE: Oracle 21c (again)

From: Scott Canaan <srcdco_at_rit.edu>
Date: Wed, 18 May 2022 17:10:04 +0000
Message-ID: <MWHPR16MB155043B75AE2A40ECBEA530AC5D19_at_MWHPR16MB1550.namprd16.prod.outlook.com>

The issue was the redirect that was added to the end of the perl command. That didn’t exist in 19c. When I removed that, it ran as expected.

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

From: Joe H-Grosse <jhg_at_isnordic.dk> Sent: Wednesday, May 18, 2022 12:55 PM
To: tim.evdbt_at_gmail.com; Scott Canaan <srcdco_at_rit.edu>; 'Andre Maasikas' <amaasikas_at_gmail.com> Cc: oracle-l_at_freelists.org
Subject: RE: Oracle 21c (again)

Hi,

I sympathize.

I don’t have 21C in play yet, - however in 19.5 at least, all <${ORACLE_HOME}/rdbms/admin/catcdb.sql> does, is assemble a perl command and execute it.

It will ask for two inputs:-

A Log Directory (must exist)
A Log file name

You provide these and off it should merrily go.

In the example below, I substitute perl -I with echo:- ….
SQL> SQL> host echo &&rdbms_admin &&rdbms_admin_catcdb --logDirectory &&1 --logFilename &&2 Enter value for 1: /tmp/logDIR
Enter value for 2: myLogfile
/ld03/oraex/product/rdbms/19.5.0/rdbms/admin /ld03/oraex/product/rdbms/19.5.0/rdbms/admin/catcdb.pl --logDirectory /tmp/logDIR --logFilename myLogfile

SQL>
….

…So for 19.5 at least, the actual command to run from the O/S ksh prompt would be (as oracle):- perl -I ${ORACLE_HOME}/rdbms/admin ${ORACLE_HOME}/rdbms/admin/catcdb.pl --logDirectory /tmp/logDIR --logFilename myLogfile;

…of course if the perl script is broken (which it can easily be), then it’s into the code… Remember that the perl interpreter that the O/S has may not interoperate with the 21C supplied perl script – if so, then perhaps try the perl binary bundled with the oracle executables themselves.

Hope this helps.

Br,
Joe
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> On Behalf Of Tim Gorman Sent: Wednesday, 18 May 2022 15.57
To: srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>; Andre Maasikas <amaasikas_at_gmail.com<mailto:amaasikas_at_gmail.com>> Cc: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: Re: Oracle 21c (again)

Try not redirecting stdout or stderr at all?

Just run "host perl -I $rdbms_admin $rdbms_admin_catcdb --logDirectory $1 --logFilename $2"? On 5/18/2022 6:54 AM, Scott Canaan wrote: It just sits there, doing nothing. I don’t see it connecting to the database and it isn’t asking me for the sys and system passwords or the temp tablespace.

It looks like I’m going to have to go through the Perl script and manually run all the scripts it is supposed to call. It’s frustrating that it doesn’t work in 21c.

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org><mailto:oracle-l-bounce_at_freelists.org> On Behalf Of Scott Canaan Sent: Wednesday, May 18, 2022 9:39 AM
To: Andre Maasikas <amaasikas_at_gmail.com><mailto:amaasikas_at_gmail.com> Cc: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: RE: Oracle 21c (again)

I changed it to:

host perl -I $rdbms_admin $rdbms_admin_catcdb --logDirectory $1 --logFilename $2 >>$HOME/catcdb_ship_err.log 2>&1

and it appears to be running, although it hasn’t asked me for anything, like it did in 19c.

Scott Canaan ‘88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659 CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

From: Andre Maasikas <amaasikas_at_gmail.com<mailto:amaasikas_at_gmail.com>> Sent: Wednesday, May 18, 2022 8:58 AM
To: Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> Cc: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: Re: Oracle 21c (again)

i think ksh doesnt have the &> redirection shortcut somebody added in catcdb.sql for 21c (Rem kpsyed 11/20/18 - Redirect perl exec errors)

ls >& err.log
ksh: err.log: bad file unit number

use bash or maybe change that to more universal 2>&1 > $error_log_catcdb Andre

On Wed, May 18, 2022 at 2:33 PM Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> wrote: I’m surprised I haven’t heard anything back on this request. Am I the only one playing with 21c?

The SR with Oracle is going nowhere. They asked me for the Oracle document I was using, then sent me the documentation on how to install the software, which I’ve clearly done. This is very frustrating.

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> On Behalf Of Scott Canaan Sent: Thursday, May 12, 2022 8:58 AM
To: 'oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>' <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: Oracle 21c (again)

Now that I understand the new location of the init.ora / spfile, I’ve created the database. I’m trying to run the catcdb.sql script. In 19c, it asked for passwords for sys & system, for the temp tablespace name, and directory and filename for the log file. When I run it in 21c, I get the following error:

SQL> set define $
SQL> host perl -I $rdbms_admin $rdbms_admin_catcdb --logDirectory $1 --logFilename $2 >& $error_log_catcdb Enter value for 2: catcdb.log
/bin/ksh: /tmp/catcdb_ship_err.log: bad file unit number

I’ve opened an SR with Oracle, but that’s going nowhere as all they keep asking for is log files and there aren’t any. I put this exact information in the SR and they asked for the /tmp/catcdb_ship_err.log file, which obviously doesn’t exist based on the error message. Clearly, they haven’t read what I put in the SR.

I’ve tried giving it the log file directory and name when I call it and get the same error.

Any ideas what is going on and how to fix it?

--
http://www.freelists.org/webpage/oracle-l






(image/gif attachment: image001.gif)

Received on Wed May 18 2022 - 19:10:04 CEST

This message: [ Message body ]
Next message: nilesh kumar: "Role of DBA Changing"
Previous message: Tim Gorman: "Re: Oracle 21c (again)"
Maybe in reply to: Scott Canaan: "Oracle 21c (again)"
In reply to Scott Canaan: "Oracle 21c (again)"
Next in thread: Mrunal Mody: "Re: Role of DBA Changing"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message