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> 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 <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 <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' <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:
>
>
>
> [image: https://support.oracle.com/epmos/adf/images/t.gif]
>
>
> 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 <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)