On my previous post (Part 2 of 3) we have seen how to install Oracle Database 11g Release 2 on Solaris 10, so now we are going to verify that the installation has been done successfully. How?
First, we need to set up the environment for the oracle user by defining the variables ORACLE_HOME, ORACLE_SID, PATH and ORACLE_BASE… The easier way is maybe to use the oraenv script :
oracle@oracleserver:~> . /usr/local/bin/oraenv ORACLE_SID = [oracle] ? orcl bash: dbhome: command not found ORACLE_HOME = [] ? /u01/app/oracle/product/11.2.0/dbhome_1 The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle oracle@oracleserver:~> oracle@oracleserver:~> echo $PATH /usr/bin:/usr/sfw/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin oracle@oracleserver:~> echo $ORACLE_HOME /u01/app/oracle/product/11.2.0/dbhome_1 oracle@oracleserver:~> echo $ORACLE_BASE /u01/app/oracle oracle@oracleserver:~> echo $ORACLE_SID orcl oracle@oracleserver:~>
Having done so, we can try to open in a web browser the Oracle Enterprise Manager (OEM).
The url is https://hostname-or-ip-of-the-oracle-server:1158/em
By default the port is 1158. You can verify the port used looking to the file portlist.ini :
oracle@oracleserver:~> grep HTTP /u01/app/oracle/product/11.2.0/dbhome_1/install/portlist.ini Enterprise Manager Console HTTP Port (orcl) = 1158 oracle@oracleserver:~>
We can also verify before that the OEM is running :
oracle@oracleserver:~> emctl status dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved. https://oracleserver:1158/em/console/aboutApplication Oracle Enterprise Manager 11g is running. ------------------------------------------------------------------ Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/oracleserver_orcl/sysman/log oracle@oracleserver:~>
As the previous command, the Oracle Enterprise Manager is running and if we open the URL in a web browser we can see the login page :
And we can connect with :
- Username : SYSTEM
- Password : the password you have set during the installation
We can do a lot of things with the OEM, but we can also use the SQL*Plus program.
We just need to use the same user & password as for the OEM, and that’s it !
oracle@oracleserver:~> sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 10 18:52:56 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter user-name: SYSTEM AS SYSDBA Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SQL> select TABLESPACE_NAME from user_tablespaces; TABLESPACE_NAME ------------------------------ SYSTEM SYSAUX UNDOTBS1 TEMP USERS EXAMPLE 6 rows selected. SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options oracle@oracleserver:~> oracle@oracleserver:~> ls -l /u01/app/oracle/oradata/orcl/*.dbf -rw-r----- 1 oracle oinstall 104865792 Dec 14 18:33 /u01/app/oracle/oradata/orcl/example01.dbf -rw-r----- 1 oracle oinstall 566239232 Dec 14 18:33 /u01/app/oracle/oradata/orcl/sysaux01.dbf -rw-r----- 1 oracle oinstall 723525632 Dec 14 18:33 /u01/app/oracle/oradata/orcl/system01.dbf -rw-r----- 1 oracle oinstall 30416896 Dec 14 18:12 /u01/app/oracle/oradata/orcl/temp01.dbf -rw-r----- 1 oracle oinstall 104865792 Dec 14 18:33 /u01/app/oracle/oradata/orcl/undotbs01.dbf -rw-r----- 1 oracle oinstall 5251072 Dec 14 18:33 /u01/app/oracle/oradata/orcl/users01.dbf oracle@oracleserver:~>
And nothing more for testing our installation… We can now start working with Oracle Database !!
NOTE : with this installation Oracle will not start automatically when rebooting the server, so if you want to know how to stop and start Oracle Database, have a look to the documentation Oracle® Database Administrator’s Reference 11g Release 2 (11.2) for Linux and UNIX-Based Operating Systems
Nothing more…. enjoy your new Oracle Database 
Arnaud
Sphere: Related Content
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
Core Networks homepage
Oracle University
#1 by Andrzej on April 17, 2010 - 09:23
Good description – thenks !
It worked on OpenSolaris for me
#2 by vivekananda on September 7, 2011 - 10:34
Thx a Lot it work for me ..
#3 by vivek on September 7, 2011 - 13:09
Hi …i just want to know how to install patches to Oracle….
#4 by Kristyan on September 9, 2011 - 00:30
Gracias!!
Excelente guia, funciono perfecto para mí..
#5 by ahmed on September 14, 2011 - 13:58
Hello, i have a question if i want to connect Database 11g Release 2 (11.2) with Oracle sql developer, i test before but always failed with me still now didn’t know the reason.
By the way u test database on my local computer the URL that after finish setup database give me to connect and is work fine username and password and login every thing okay.
thanks,