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.
>
> *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_| 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:* Wednesday, May 18, 2022 9:39 AM
> *To:* Andre Maasikas <amaasikas_at_gmail.com>
> *Cc:* 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_| 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> 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_| 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:
>
> 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_ | 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