This content has been marked as final. Show 9 replies
885862 wrote:It's an OS question, not a VirtualBox question. You didn't state your os, so I'll assume Oracle Linux.
How to check my hostname?? Sorry I am new to VirtualBox
Google 'set hostname in linux'. There are about a bazillion hits on it.
I didn't see /etc/hostsWhere were you looking?
How to set the ORACLE_HOSTNAME enviroment variable?in your /home/.bash_profile, put this line:
export ORACLE_HOSTNAME=<whatever value is appropriate' Edited by: EdStevens on Nov 19, 2012 2:54 PM
I can never quite figure it out, but I think using emctl to start dbconsole puts together oracle_hostname and oracle_unqname to create the directory name appended to oc4j_dbconsole. This is very confusing, and the error messages tend to only mention oracle_unqname, so when people are flopping around trying to make this stuff work, you'll find directories with and without oracle_hostname. In other words, doing things from the installer and from the command line aren't exactly the same because of this variable. If I understand it, which is certainly debatable.
ORACLE_HOSTNAME is optional, but takes precedence over the configured OS hostname
for example hostnames with underscore characters ('_') are not supported
but emctl/emca will pick them from OS, and dbconsole wont start
*Why EMCA Fails When Hostname Has An Underscore '_' And How To Workaround This? [ID 393430.1]*
in that case you could set ORACLE_HOSTNAME to an alias or even the actual IP address
ORACLE_UNQNAME is required for example when you have a RAC database, where the SID != db_unique_name
now back to original topic:
this is an OS configuration issue which should be resolved
ORACLE_HOSTNAME is just a workaround
I have corrected by myself.
I typed in
$ export ORACLE_BASE=/home/oracle/app/oracle
$ export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
$ export ORACLE_SID=orcl
$ mkdir -p $ORACLE_BASE/admin/$ORACLE_BASE/wallet
$ sqlplus / as sysdba
SQL> alter system set encryption key identified by "ora11g";
The system operates.
Thanks, guys. Thanks for your help.