Oracle 12cR2 – Problem When Creating Database Using DBCA

OS: Oracle Linux 7.7

Users: root, grid, oracle, userwithmyname

Installed softwares: grid infrastructure with asm in grid user, Oracle 12cR2 in oracle user

I created a database in my grid user. It is running successfully.

But when I want to create database in my oracle user using DBCA, it gives this error:

Installation steps in DBCA:

1-) Create database

2-) Advanced configuration

3-) Oracle single instance database – general purpose or transaction processing

4-) Global database name: orcl, sid: orcl, create as container database (not selected, I don’t want)

5-) Use following for the database storage attributes, database file storage type: ASM, database files location: +DATA/{DB_UNIQUE_NAME}, use oracle-managed files (OMF) (selected, I want)

6-) Specify fast recovery area, recovery files storage type: ASM, fast recovery area: +FRA, fast recovery area size: 9 GB

7-) Listener selection: listeners data is loaded from TNS_ADMIN env: /u01/app/oracle/product/12.2.0/db_home/network/admin, create a new listener (not selected, by the way I tried with selected option)

😎 Use automatic shared memory management, sga size: 2.4 GB, pga size: 0.8 GB

9-) Use the same administrative password for all accounts

10-) Select the database creation options: create database (selected), post db creation scripts (none)

11-) The problem is starting here.

Error-1: Database Configuration Assistant / ORA-12547: TNS: lost contact (options: ignore, abort)

Error-2: Database Configuration Assistant / Error while cataloging RMAN Backups (option: ok)

DBCA Log Location: … I examined log file.

It says:

[Thread-237] [ 2020-02-22 22:31:20.820 EET ] [RMANEngine.initialize:246]  Starting Reader Thread...  [Thread-237] [ 2020-02-22 22:31:20.820 EET ] [RMANEngine.initialize:250]  Started reader thread for RMAN process in initialize... [Thread-250] [ 2020-02-22 22:31:20.820 EET ] [RMANEngine.run:827]  Started reader thread for RMAN process from initialize... [Thread-250] [ 2020-02-22 22:31:20.820 EET ] [RMANEngine.run:831]  Set m_bReaderStarted  to true  in initialize... [Thread-237] [ 2020-02-22 22:31:20.821 EET ] [RMANEngine.initialize:258]  Started error thread for RMAN process from initialize... [Thread-237] [ 2020-02-22 22:31:20.821 EET ] [RMANEngine.initialize:263]  Created output writer for RMAN process from initialize... [Thread-237] [ 2020-02-22 22:31:20.821 EET ] [RMANEngine.initialize:301]  Created Log writer for RMAN process from initialize... [Thread-237] [ 2020-02-22 22:31:20.821 EET ] [RMANEngine.initialize:306]  Value of m_bReaderStarted in initialize=true [Thread-237] [ 2020-02-22 22:31:20.821 EET ] [RMANEngine.initialize:321]  Made sure reader has started for RMAN process from initialize... [Thread-237] [ 2020-02-22 22:31:20.824 EET ] [RMANEngine.connect:797]  NOT using OS auth to connect [Thread-237] [ 2020-02-22 22:31:20.824 EET ] [RMANEngine.executeImpl:1285]  m_bExecQuery=false [Thread-237] [ 2020-02-22 22:31:20.824 EET ] [RMANEngine.executeImpl:1293]  Command being written to rman process=connect target 'SYS/****** [Thread-237] [ 2020-02-22 22:31:20.824 EET ] [RMANEngine.executeImpl:1321]  Notify reader to start reading [Thread-250] [ 2020-02-22 22:31:21.307 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output= [Thread-250] [ 2020-02-22 22:31:21.307 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=Recovery Manager: Release 12.2.0.1.0 - Production on Sat Feb 22 23:31:21 2020 [Thread-250] [ 2020-02-22 22:31:21.308 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output= [Thread-250] [ 2020-02-22 22:31:21.308 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved. [Thread-250] [ 2020-02-22 22:31:21.531 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output= [Thread-250] [ 2020-02-22 22:31:21.531 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=RMAN> [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=RMAN-00571: =========================================================== [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=RMAN-00571: =========================================================== [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=ORA-12547: TNS:lost contact [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output= [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=RMAN> [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=echo set on [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:988]  Log RMAN Output=set echo off; [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:1031]  hasError is true [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:1037]  ERROR TRACE DETECTED [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:1044]  m_errHdlr=null [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:1068]  FATAL ERROR DETECTED [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.readSqlOutput:1132]  Notifying writer to proceed because m_bInterrupted=falsebNotify=truem_bReaderDone=truem_bFatalErrorOccured=true [Thread-250] [ 2020-02-22 22:31:21.563 EET ] [RMANEngine.run:841]  Return Value from readSqlOutput=null [Thread-237] [ 2020-02-22 22:31:21.564 EET ] [RMANEngine.executeImpl:1333]  Completed wait from reader [Thread-237] [ 2020-02-22 22:31:21.564 EET ] [RMANEngine.executeImpl:1348]  Calling done as got exception [Thread-237] [ 2020-02-22 22:31:21.564 EET ] [RMANEngine.done:1654]  Done called [Thread-237] [ 2020-02-22 22:31:21.564 EET ] [RMANEngine.executeImpl:1375]  GOT FATAL Error=Recovery Manager: Release 12.2.0.1.0 - Production on Sat Feb 22 23:31:21 2020 Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved. RMAN> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-12547: TNS:lost contact 

Thank you.

Edit:

When I check “lsnrctl stat” I can see +ASM instance.

When I try to “lsnrctl stop” it says:

“Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

TNS-01190: The user is not authorized to execute the requested listener command”

Are you able to change the appearance of a Steel Defender after creating it?

I’m playing a Battle Smith Artificer currently, and my DM is a very by-the-books kind of guy. When the question came up of whether or not I could change its appearance, he just said “if it’s in the book.”

From the entry for the Steel Defender, it just says that you determine its appearance and whether it has 2 or 4 legs. Given this, we can’t decide if its appearance is static upon creation, or if it can be changed on a whim without creating a new one.

Thanks.

install postgresql without creating instance (for use with repmgr)

I’m trying to get REPMGR setup, and I’m following the steps at https://repmgr.org/docs/current/quickstart-standby-preparation.html to get the standby setup.

I noticed it warns On the standby, do not create a PostgreSQL instance. However I believe this happens automatically with how I installed Postgres

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee  /etc/apt/sources.list.d/pgdg.list sudo apt update sudo apt -y install postgresql-12 postgresql-client-12 

because when I try to clone the primary onto the standby as mentioned in https://repmgr.org/docs/current/quickstart-standby-clone.html
$ repmgr -h node1 -U repmgr -d repmgr -f /etc/repmgr.conf standby clone --dry-run

I get

postgres@empty2:~$   repmgr -h 192.168.1.102 -U repmgr -d repmgr -f /etc/repmgr.conf standby clone --dry-run NOTICE: destination directory "/var/lib/postgresql/12/main" provided ERROR: specified data directory "/var/lib/postgresql/12/main" appears to contain a running PostgreSQL instance HINT: ensure the target data directory does not contain a running PostgreSQL instance 

Now I’m just ASSUMING that this is because the database instance was created when I installed postgres on the standby. and I’m also ASSUMING that I can just delete everything in the data directory on the standby, and everything will work ok…

But (assuming my assumptions are correct….) what is the correct way to install postgres12 without creating an instance and the corresponding data files?

Creating a Fortress that Allows Owner to Scry, but Blocks Others

I’m a GM designing the remote fortress of an ancient-but-still-living archmage (>=20th level?). The archmage lives in society at present, and only returns to his fortress a few times per year, or as needed, via a permanent teleportation circle.

Previously, the archmage hid in this fortress for centuries to escape persecution from…well…pretty much everyone, so the fortress needs to be protected against even high-level divination magic. For this reason, I plan to line the fortress with a layer of lead and have some permanent spells like Mage’s Private Sanctum, Nondetection, and similar, to prevent most/all divination magic.

At the same time, because the archmage has begun living in society again (in disguise), it makes sense that he would place some kind of alarm that would warn him, even at great distances, of intruders. Furthermore, it makes sense that he’d have a sort of permanent scrying system set up so that he alone could observe what’s going on in his fortress.

(Note: The archmage’s INT score is way above my own, so I figured I’d do the best I can by crowdsourcing…)

My Question

  • Is there any rules-as-written avenue for the archmage to simultaneously prevent others from successfully using divination spells on his fortress but also permit divination spells of his own?
    • If so, how could that be done?
    • If not, what might be the closest thing to it?

Is creating a joining/bridging table the most practical and efficient way of normalizing numerous M:M relationships in a database?

Let me start with an example:

Table users:

ID | Name --------- 1, Kirk 2, John 

Table class:

ID | Class ---------- 1, MATH 2, FIN 

Now, based on what I studied so far, in order to properly normalize this database, I’d create another table, a joining/bridging table:

Table class_enrollment:

UID | CID 1     1 1     2 2     1 2     2 

Well, it works fine in these kinds of examples.

But, what if my database has 35 or 50 M:M relationships? Is it really best to create yet another 35/50 joining tables?

Creating a Woocommerce custom shipping method as a select field

I’m working with thw WooCommerce plugin for WordPress. My main goal right now is to create a custom shipping method. So far I’ve managed to create this method and display the same in my billing form. The problem is that this shipping methods are checkbox by default and I want an extra funcionality: Display a select with a series of options as soon a I select this custom shipping method on the billing order form.

This next class handles the custom shipping method:

/**  * WC_Shipping_Pickup class.  *  * @class       WC_Shipping_Pickup  * @version     1.0.0  * @package     Shipping-for-WooCommerce/Classes  * @category    Class  * @author      Pickup Softwares  */ class WC_Shipping_Pickup extends WC_Shipping_Method {     public function __construct($  instance_id = 0)     {         $  this->id                    = 'pickup_method';         $  this->instance_id           = absint($  instance_id);         $  this->method_title          = __('Pickup');         $  this->method_description    = __('Método de envío: punto de pickup');         $  this->supports              = array(             'shipping-zones',             'instance-settings',         );          $  this->instance_form_fields = array(             'enabled' => array(                 'title'         => __('Habilitar/Deshabilitar'),                 'type'          => 'checkbox',                 'label'         => __('Habilitar este método de envío'),                 'default'       => 'yes',             ),             'title' => array(                 'title'         => __('Título'),                 'type'          => 'text',                 'description'   => __('Título que se visualizará en el formulario de facturación'),                 'default'       => __('Pickup'),                 'desc_tip'      => true             )         );          $  this->enabled              = $  this->get_option('enabled');         $  this->title                = $  this->get_option('title');          add_action('woocommerce_update_options_shipping_' . $  this->id, array( $  this, 'process_admin_options' ));     }      public function calculate_shipping($  package = array())     {         $  this->add_rate(array(             'id'    => $  this->id . $  this->instance_id,             'label' => $  this->title,             'cost'  => 0,         ));     }      /**      * Generate Select HTML.      *      * @param string $  key Field key.      * @param array  $  data Field data.      * @since  1.0.0      * @return string      */     public function generate_select_html()     {         $  token = null;         $  expire = null;         $  token = qk_login($  token, $  expire);          $  agencies = qk_agencies($  token);          $  field_key = $  this->get_field_key('_pickups');          $  options = [];         foreach ($  agencies as $  agency) {             $  options[$  agency->id] = $  agency->detalle;         }          $  defaults  = array(             'title'             => 'Pickups',             'disabled'          => false,             'class'             => '',             'css'               => '',             'placeholder'       => 'Seleccionar punto de recogida',             'type'              => 'text',             'desc_tip'          => false,             'description'       => '',             'custom_attributes' => array(),             'options'           => $  options,         );          $  data = wp_parse_args($  data, $  defaults);          ob_start(); ?>         <tr valign="top">             <th scope="row" class="titledesc">                 <label for="<?php echo esc_attr($  field_key); ?>"><?php echo wp_kses_post($  data['title']); ?> <?php echo $  this->get_tooltip_html($  data); // WPCS: XSS ok.?></label>             </th>             <td class="forminp">                 <fieldset>                     <legend class="screen-reader-text"><span><?php echo wp_kses_post($  data['title']); ?></span></legend>                     <select class="select <?php echo esc_attr($  data['class']); ?>" name="<?php echo esc_attr($  field_key); ?>" id="<?php echo esc_attr($  field_key); ?>" style="<?php echo esc_attr($  data['css']); ?>" <?php disabled($  data['disabled'], true); ?> <?php echo $  this->get_custom_attribute_html($  data); // WPCS: XSS ok.?>>                         <?php foreach ((array) $  data['options'] as $  option_key => $  option_value) : ?>                             <option value="<?php echo esc_attr($  option_key); ?>" <?php selected((string) $  option_key, esc_attr($  this->get_option($  key))); ?>><?php echo esc_attr($  option_value); ?></option>                         <?php endforeach; ?>                     </select>                     <?php echo $  this->get_description_html($  data); // WPCS: XSS ok.?>                 </fieldset>             </td>         </tr>         <?php          return ob_get_clean();     } } 

I’ve been trying to use this generate_select_html function to generate this select input but I’m actually running with my eyes closed because I don’t know if this is right way to do things. That piece of code causes an infinite loading page on the billing form so it is wrong (obviusly). Is there a way to adchieve what I want?

Is Google Creating a Facebook Killer?

Rumor is that Google is creating a direct social media competitor to Facebook. This rumor has legs, and an identified source, Adam D’Angelo, former Facebook CTO. D’Angelo, who now runs Quora, stated on that site “This is not a rumor. This is a real project. There are a large number of people working on it. I am completely confident of this”. His comments came shortly after Digg founder Kevin tweeted as much (and then had his tweet removed) and even named names, that is, the product…

Is Google Creating a Facebook Killer?

Creating a Sequence of Sounds using Table

I am trying to play a sequence of sounds in Mathematica using Table, my real example is much more complicated so that is why I got to Table, why doesn’t it work?

frequencies = {{100, 200}, {200, 300}, {400, 600}}; Sound[Table[   Sound[Play[     Total[Sin[#*2 Pi t] & /@ frequencies[[i]]], {t, 0, 0.5}]], {i, 1,     3, 1}]] 

If I run the sounds as a list it works fine, but when using table it does not, I just get the following:

Sound[{Sound[ Sound[SampledSoundFunction[ Function[{PlayTime494}, Block[{t = 0. + 0.000125 PlayTime494}, (Total[(Sin[#1 2 [Pi] t] &) /@ frequencies[[i]]] – 4.44089*10^-16) 0.568158]], 4000, 8000]]], Sound[Sound[ SampledSoundFunction[ Function[{PlayTime495}, Block[{t = 0. + 0.000125 PlayTime495}, (Total[(Sin[#1 2 [Pi] t] &) /@ frequencies[[i]]] + 1.88738*10^-15) 0.525731]], 4000, 8000]]], Sound[Sound[ SampledSoundFunction[ Function[{PlayTime496}, Block[{t = 0. + 0.000125 PlayTime496}, (Total[(Sin[#1 2 [Pi] t] &) /@ frequencies[[i]]] + 8.88178*10^-16) 0.525731]], 4000, 8000]]]}]

Any help appreciated

Thank you