Shutdown/Startup vs. Alter Statement – 12c Edition

And most of these new commands are available via a simple right-click in the current release of Oracle’s SQLDeveloper (DBA Menu).

When everyone finally moves to Oracle pluggable databases, one thing to remember is that stopping and starting a database is not going to be as simple as it use to be.  Shutting down and starting up a database is done simply with the following commands:

shutdown normal
shutdown immediate
shutdown abort
startup
startup nomount
startup mount

If we use one of these traditional shutdown methods at the container database (CDB) layer, we will bring down the CDB and the associated PDBs under it. This is something to be aware of when looking to reboot a container databases.  Lets take a look at bringing down a CDB.

[oracle@oel ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Jul 21 21:42:53 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real…

View original post 687 more words

Advertisements

Oracle R12 (and others) OA Framework Dislikes IE 8/9/10 Compatibility View

In our environment we try to have a newer/fresher set of web applications, but

Tools -> Compatibility View Settings
Tools -> Compatibility View Settings

some are simply too old to upgrade.  They like running in the pre-Microsoft Silverlight days of old Active-X controls and scripted Java. But Internet Explorer needed to move forward, and with version 8 was introduced a feature called “Compatibility View” which reverts back to older IE6/7 style page handling.

So what’s the big deal here? Well, in mixed-legacy environments some standard Windows administrators set the following as a default – Display Intranet sites in Compatibility View.  That makes older Sharepoint sites happy. Makes old web software happy.

Makes new software go from this:

Internet Explorer Browser 10 Compatibility View Oracle R12
Looks fine at first. (IE10 w/Compatibility View)
Internet Explorer Browser 10 Compatibility View Oracle R12 - Broken
Refreshed…cleared cache…I have a broken R12 page.

to this:

 

 

 

 

 

 

 

 

So, the fix is as simple as unchecking that box for [ ] Display Intranet sites in Compatibility View, and specifically adding only those URI’s (web addresses/URLs) that actually require the original browser “old” security model.

Otherwise, you’ll see more pages like this:

PasswordsMax JavaScript error in IE10 with Compatibility View
It’s all because of that same Compatibility View checkbox setting.

 

Changing ORACLE_BASE in Oracle 11gR2 (11.2.0.3.4) Database

During a routine installation, I managed to mis-type the filesystem path for the ORACLE_BASE during execution of the Oracle Universal Installer (./runInstaller).

[nb: ORACLE_BASE by normal definition should be a standard starting filesystem mountpoint under which all other instance-specific data/files for this ORACLE_HOME would be found. Typically contains your diagnostic logs, Fast Recovery Area files, all configuration tool logs, and any Flashback checkpoint saves.

$ORACLE_BASE/diag/.

./asm
./clients
./crs
./diagtool
./lsnrctl
./netcman
./ofm
./rdbms
./tnslsnr

$ORACLE_BASE/admin/<SID>/.

./adump          # Audit data./dpdump       # Data Pump related
./pfile               # init.ora files generated by config tools

–end of note]

Since the service account (oracle) had filesystem permissions to do so, it went ahead and put all of the flashback recovery, diagnostics, and audit trail files (and my backup controlfiles) into the incorrectly named directory.  The database itself was running, but how to correct this without starting all over again?

Start with backing up your init.ora configuration from spfile to pfile format:

SQL> create pfile from spfile;

File created.

(this defaults to $ORACLE_HOME/dbs/init.ora)

Then shutdown services:

SQL> shutdown immediate;

Database closed.

SQL> exit;

#oracle> lsnrctl stop

Now go find all the places you’ll need to modify/correct the ORACLE_BASE filepath declarations:

$ORACLE_HOME/dbs/init<SID>.ora

$ORACLE_HOME/network/admin (or $TNS_ADMIN)

  • listener.ora: ADR_BASE_LISTENER
  • sqlnet.ora: ADR_BASE
    (Note: these two are auto-generated using netca – the Oracle Net Configuration Assistant, if you execute that after making the database and environment-side changes.

$ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml : ORACLE_BASE

All finished editing? Start everything back up:

#oracle> lsnrctl start

SQL> startup pfile=?/dbs/init<SID>.ora  — to use revised settings

SQL> create spfile from pfile;       — copy new settings to spfile

SQL> shutdown immediate;

SQL> startup;                                — uses spfile instead

Now future installs using dbca, dbua and netca should recognize your defined/modified/corrected ORACLE_BASE.

2013-07 Shinnyo-en Buddhism Podcast – Sa

2013-07 Shinnyo-en Buddhism Podcast – Sacred Images – The Travels of the Shinnyo Masters Making a Connection to the Past Master Shinjo on Why Do We Have Buddha Images? 2013-July Shinnyo-en Buddhism Podcast – Sacred Images Subscribe to this Podcast (RSS) or iTunes The busts of the Shinnyo … Continue reading → http://ow.ly/2yc78F

2013-07 Shinnyo-en Buddhism Podcast – Sacred Images

The Travels of the Shinnyo Masters
Making a Connection to the Past
Master Shinjo on Why Do We Have Buddha Images?

2013-July Shinnyo-en Buddhism Podcast – Sacred Images

Subscribe to this Podcast (RSS) or iTunes

Bronze sculptures of the founders of Shinnyo-en Buddhism

The busts of the Shinnyo Parents and the Two Dojis that had been placed at Shinchoji (a Shinnyo-en main temple in Japan) and which had long been exposed to the smoke of the homa fires and incense (causing unique variations in color from their original bright golden bronze appearance when first cast) have been temporarily enshrined during their world tour at our temples in Singapore, Taiwan, six locations in Europe, and Hawaii before making their way to other temples on the mainland United States.

Here in Los Angeles, we supported their visit for a brief 3 weeks while many visitors experienced their first opportunity to make contact with these sacred images from afar. The exhibit included many educational exhibits about buddhist practices and what the purposes and meanings were for the images, sculptures and artwork represented in Shinnyo temples. Some religions forbid creating images of their deities or missionaries, possibly to prevent idolatry or misguided worship of the image itself. In buddhism, we are taught that images represent figures to assist connection with the human senses, but the philosophy is to respect those who walked the sacred path before us, not to worship them nor endow them with supernatural attributes. So, perhaps no differently than one would treasure ones old photographs of departed family members, we at Shinnyo-en are fortunate to have images which remind us in our minds and hearts to bring alive the memories and thoughts of both our founders and the originators of the Shinnyo Dharma Stream before them.

Through this tour of the Shinnyo busts, many practitioners have been able to form a spiritual connection to something infinite yet personal through the experience of touching the vajra cords attached to the busts. By spending time in front of the busts, many have reported feeling a sense of peace and calm. Others said they felt some kind of inner transformation had occurred, which helped them become more open. Some practitioners felt something warm and immediate, as if their hands were enveloped by the hands of our spiritual masters.

One practitioner said that it was a moment she would never forget, when she felt as if the Shinnyo Parents and the Two Dojis were telling her that her efforts were on track and that she was headed in the right direction.

As the busts travel to more of our centers, more people in the world can feel the atmosphere of Oyasono, a sacred site of pilgrimage where people can get closer to the core of Shinnyo Buddhism to recreate that warm atmosphere in their own surroundings.

The intention behind sending the busts to different places outside Japan is to help more people to feel spiritually connected to a sacred place that welcomes all. This international tour started in the centennial year of Shojushinin’s birth. and is due to last until the spring of 2014. It, too, is part of the enhancement of Oyasono as an eternal site, a spiritual “home” that welcomes, rejuvenates, and inspires people to truly strive toward buddhahood.

So what about the person who feels “nothing” when sitting before an image? Similar to the self-reflection that happens during meditation, one could say that the person who brings nothing to prayer, will receive exactly that — nothing. Personally, it takes a LOT of continued practice to become sensitive to all the chatter that is going on in one’s mind at any time. And closing one’s eyes only temporarily mutes one of those five major senses. Your brain is still hard-at-work bringing in smell, taste, touch, and sound sensory input, so to be able to identify and focus upon one quiet and tiny communication that may not be triggered by any of the external senses is the key to expanded listening (to yourself.) Even in a sensory deprivation chamber, you would still feel the pressure from the salt water, the sounds of your heartbeat, breathing and digestion, and taste whatever enzymes or substances are in your mouth – a continual cacophony of sensory stimulation.

This concept is perhaps the important psychological factor in religion. A person who believes there is no spirit or external force that can influence their life, often is quite correct for themselves. The human mind is capable of transcending its own environment – such as a person who is in an extremely hot/cold temperature place, yet feels nothing special (the “it’s not THAT hot/cold”-type of person.) Similarly, someone who can ignore spiritual or metaphysical influences, could similarly ignore their own sub-conscious or intuition, as well. “Mind over matter” is not just a proverbial notion.

Master Shinjo Ito during a lecture in 1965 told his students,

“When you have one good dharma teacher, many others can be educated and nurtured. Since our path is one of being a “greater vehicle,” our aim is to raise each person to be a good role model who can guide many others. Put simply, the Shinnyo Path is one that aims to nurture bodhisattvas and buddhas. That’s why I make Buddhist sculptures. By giving form to a buddha figure, I hope to encourage people to give form to a buddha in their heart and soul.”