Skip to Main Content
Forums

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.

dbms_error

pikuFeb 18 2011 — edited Feb 20 2011
we are getting this error on our db server self check mail. Do you know what is that?

thanks in advance.
                ###  Todays Error Mesages ###       
   
   
Feb 19 00:02:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 00:08:39 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 00:15:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 00:22:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 00:28:39 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 00:35:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 00:42:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 00:48:39 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 00:55:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 01:02:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 01:08:39 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 01:15:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 01:22:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 01:28:39 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 01:35:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 01:42:10 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 01:48:39 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 01:55:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 02:02:09 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
Feb 19 02:08:40 nerpdb01 SC[SUNWscor.oracle_server.monitor]:nerpdb-rg:oraserver-rs: [ID 185465 local7.error] No action on DBMS Error DBMS_ERROR : -28002
This post has been answered by John Spencer on Feb 19 2011
Jump to Answer

Comments

800381
Assuming you're using Studio 12.3, the compile-time options are one of "-xcode=pic13" or "-xcode=pic32".

The deprecated options are "-Kpic" and "-KPIC".
user458823
Thank you, that was indeed the fix. Here is a summary I sent to the mod_perl mailing list:

We could successfully build 64 bit apache with the configuration options so kindly shared by John D. Groenveld, also, in order to build mod_perl on 64 bit perl we had to recompile perl 64 bit, these are the flags we used:
./Configure -ders -Dcc=cc -Ud_sigsetjmp -Uinstallusrbinperl -Ulocincpth= -Uloclibpth= -Duse64bitint -Duse64bitall -Ud_strerror_r -Ud_signbit -Duselargefiles -Dprefix=/usr/perl10/5.18.0 -Accflags="-xcode=pic32"

The noteworthy flags in above ./Configure are -Accflags="-xcode=pic32" in ./Configure the "-Accflags=" passes the flags you want to the C compiler, in our case we wanted the -xcode=x32 flag to be passed to the C compiler(solaris studio compiler) because of the error message we were getting:
"symbol PL_check: relocations based on the ABS44 coding model can not be used in building a shared object"
So to build for "shared object" support, perl 64 bit had to be recompiled with the -xcode=pic32 flag

Building mod_perl was then seamless, perl Makefile.PL (NOTE: the perl is teh perl which was built with above arguments.
make, make install.


It is important to use the SAME COMPILER for everything. We are using Solaris Studio compiler, which, John D. Grovenfeld also used. We needed DBD::mysql to talk to the MYSql database, now Mysql was installed on Solaris 10 via pkgadd and is a 64 bit application. Needless to say it is safe to assume that Oracle built it using the Solaris Studio compiler......

DBD::mysql was built using MCPAN shell.....

Hope this helps someone in the future.......

Thanks to John D. Groenveld, The other resources online, and to my boss...
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2011
Added on Feb 18 2011
#general-database-discussions
14 comments
1,494 views