Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

error creating oracle database 19c in linux

Tony007Sep 13 2020 — edited Sep 13 2020

hi am geting this error when creating database in 19c

vretingdatabase.JPG

this the log

Parsing command line arguments:

Parameter "silent" = true

Parameter "local" = true

Parameter "inscomp" = server

Parameter "insprtcl" = TCP

Parameter "orahome" = /u1/app/oracle/product/19.0.0/dbhome\_1

Parameter "instype" = custom

Parameter "listener" = listener

Parameter "lisport" = 1421

Parameter "cfg" = local

Parameter "responsefile" = /u1/app/oracle/product/19.0.0/dbhome\_1/network/install/netca\_typ.rsp

Done parsing command line arguments.

Oracle Net Services Configuration:

LISTENER:The information provided for this listener is currently in use by other software on this computer.

Profile configuration complete.

Check the trace file for details: /u1/app/oracle/cfgtoollogs/netca/trace_OraDB19Home1-2009137AM2251.log

Oracle Net Services configuration failed. The exit code is 1

Comments

Answer

rqEval can accept non-numeric types as input.

In your example, 'select 1 "Industry" forces a returned numeric value.  It fails because the data returned contains 1 non-numeric column. The output doesn't match the specification in the SQL provided, and an error is returned.

Instead, use cast to return as varchar as follows:

SQL> select * from table(rqEval(

        NULL,

        'select cast(''Industry'' as varchar2(8)) "Industry" from dual',

       'Test'));

Returns:

1 Text

Marked as Answer by 3631507 · Sep 27 2020
1 - 1

Post Details

Added on Sep 13 2020
1 comment
1,214 views