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> Sent: Wednesday, May 18, 2022 8:58 AM
To: Scott Canaan <srcdco_at_rit.edu>
Cc: 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.

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: 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?

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.

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






(image/gif attachment: image001.gif)