Check that Oracle DB 11.2.0.2 test db is receiving connections

Logged in as oracle user this works :

Make sure ORACLE_HOME, ORACLE_SID and PATH are all set :
# echo $ORACLE_HOME
/export/home/database/11g/app/oracle/product/11.2.0/dbhome_1
# echo $ORACLE_SID
orcl
# echo $PATH
/usr/bin:/export/home/database/11g/app/oracle/product/11.2.0/dbhome_1/bin:

# $ORACLE_HOME/bin/sqlplus -s "/ as sysdba"<<! > /tmp/check_$ORACLE_SID.tom.ora
> select * from v\$database;
> exit
> !

# cat /tmp/check_$ORACLE_SID.tom.ora

     DBID NAME      CREATED   RESETLOGS_CHANGE# RESETLOGS
---------- --------- --------- ----------------- ---------
PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE     CHECKPOINT_CHANGE#
----------------------- --------- ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
--------------- ------- --------- --------------------- -------------------
CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE            PR


Command :

/bin/su - oracle -c "ORACLE_HOME=/export/home/database/11g/app/oracle/product/11.2.0/dbhome_1;export ORACLE_HOME;ORACLE_SID=orcl;export ORACLE_SID;$ORACLE_HOME/bin/sqlplus -s '/ as sysdba'<<! > /tmp/check_$ORACLE_SID.ora
select * from dual;
exit
!"

Solaris 11 AI server : client profile issue

I recently came across this issue when setting up a Solaris 11 AI server.  For each client I had a manifest file and a profile.  I added both to the client I wanted to install.  The problem was that since I did not specify a criteria for the profile it meant that the profiles for each client where being run on every install.  Here is the solution :

"By default when you add a profile via "installadm create-profile", it will get assigned to all clients for this service.

To assign profiles to specific clients/hosts you have to provide criteria that will identify it.

In your scenario I'm presuming you just have the one install service created from which you'd like to install two machines from but apply a specific profile to each machine.

Assuming the install services is called my_ai. The default means of creating a profile which will apply to all client machines that get installed via this service would be :

   $ installadm create-profile -n my_ai -f machine1.profile.xml

To ensure a specific client machine uses a specific profile you'd have to add some criteria to the create-profile sub-command :

  $ installadm create-profile -n my_ai -f machine1.profile.xml -c ipv4=192.19.82.7


This will ensure that machine with ip 192.19.82.7 will get this profile and not any other machine. Where as without the criteria all machines would get it.

List of valid Criteria are under "CRITERIA" section of installadm(1M)."

Thanks for reading,
Tom

HOWTO : Change the nodename on Solaris 11

echo 'setprop config/nodename = <nodename>' | svccfg -s svc:/system/identity:node 

svcadm refresh system/identity:node 

svcadm restart system/identity:node 

and then reboot.

Avatars and Nanodetectors

This blog is a bit of a mind spill and offers mostly questions and very little in the way of answers.  It will touch on topics such as avatars, voice recognition, nanodetectors, health and how mankind may develop a one point interaction with the Internet.

Avatars have interested me for a while. When I talk about an avatar I'm not referring to those cartoon avatars you can create for free online or James Cameron's Avatar.  I'm interested in 3D photo realistic avatars that exhibit your behaviors, your current "status", learn as you learn and respond to your voice.  By "status"  I mean detailed health status, mood, location etc.  A 100% online representation of yourself.  Our current QWERTY interaction with the Internet is cold and in personal. In the future when you need to search online, book flights, contact a family member, read the news or whatever else you do online you may leave that up to someone else, your avatar.  Avatars will interact online in the same way humans interact in real life.  They will learn from each other, negotiate with each other and even have relationships with each other.

Currently when you feel the need to tell your friends about your mood, health, location your first reaction is to update your online status in twitter, facebook, blog etc.  Maybe in the future your avatar will communicate all of this information not just because you have told your avatar how you are feeling but because your avatar will be feeling the same??  When you have the flu will you need to tell your avatar about the phlegm or will your avatar have a greater insight into how your feeling than you do?  Your avatar may have advanced knowledge of what is happening inside your body through nanodetection and will be able to advise you on the best course of action.  An interesting aside is that as genome mapping becomes faster and may become available to Joe Bloggs, your avatar may have access to your genetic code and can look for changes in your genome.  Your avatar will be your own PA, health care physician and digital being.  So in essence your avatar could be your one point interaction to the Internet.  Will Avatars ever be able to go to work for us?

Does the technology already exist to make this a reality?  Yeah I think the majority of it does.  The problem is how we can combine existing technology, deal with storage of vast amounts of information in the cloud so that it can be accessed in real time, security of this information through genetic encryption of data and there are surely lots of ethical issues to address.

Thanks for reading.
Tom