Last weeks have been a little busy, and from several tasks I had to do, there was an Oracle Database installation.
There was a funny discussion about the version to install, where people recommended installing 10g only because was the version they worked with or because the how to they use it’s only for 10g.
At the end, we decided to install last version, 11.2, as the main use for this database would be a huge quantity of data in a data warehouse like use, and I had to install it.
I thought that it would be easy, as you have the possibility of doing remote X from the server (yes, it was a server so we only had remote access), and you know the most “boring” part of installing Oracle Database it’s the steps previous to installation, you know, kernel parameters, directories, users, permissions..
But when I talked to my colleague and he told me that the server was installed without any X server package, and that they don’t install it as a policy, I had to deal with a silent installation using only command line, so after some look on the internet, I found the process really straight forward, and in a few hours I had the software installed, the database created, and both the listener and enterprise manager console configured. And most important thing: the team waiting for the database happy for having it ready! 🙂
Ok, you maybe like to know which are the steps or how difficult is an Oracle Database silent installation using response files? You have some examples and templates of response files in the directory response, where you have extracted the database software, so you only need to copy it and modify it to fit your needs.
Here you are some examples on how my installation went:
./runInstaller -silent \
-responseFile /home/oracle/install/database/response/db_install.rsp \
When you have your response files ready, you only have to input the previous command, specifying the Oracle BASE and Oracle Home environment variables, and other options as groups or type of Database Installation, from the path when you have the oracle software extracted.
When it finish the installation, the next step would be configuring the listener for the database. In this case, I used a almost default listener configuration, using the following command.
netca /silent /responsefile /oracle/netca.rsp
When your listener is ready, you can create your database with a command like this, when you specify the DB name, in this case TESTDB, the template or model for the new database and other data as the type of storage (Filesystem or ASM) and passwords.
dbca -silent -createDatabase -gdbName TESTDB -templateName Data_Warehouse.dbc \
-datafileDestination /oracle/oradata -sysPassword myPWD -systemPassword myPWD
-storageType FS \
The most tricky part from the installation was Enterprise Manager or DB console configuration, as it was needed by the team who is going to use the database created.
It’s important to have all Oracle environment variables like ORACLE_HOME, ORACLE_UNQ_NAME or ORACLE_BASE set to ensure that dbconsole configuration would be executed successfully:
emca dbcontrol db -repos recreate -ORACLE_HOSTNAME gsc-analitics -SID TESTDB -PORT 1521 -ORACLE_HOME $ORACLE_HOME -DBDNMP_PWD sys
STARTED EMCA at May 17, 2012 12:48:46 PM
EM Configuration Assistant, Version 22.214.171.124.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Listener ORACLE_HOME [ /oracle/product/11.2.0/db ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
You have specified the following settings
Database ORACLE_HOME ……………. /oracle/product/11.2.0/db
Local hostname ……………. gsc-analitics
Listener ORACLE_HOME ……………. /oracle/product/11.2.0/db
Listener port number ……………. 1521
Database SID ……………. TESTDB
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
Do you wish to continue? [yes(Y)/no(N)]: Y
With this simple steps, you have installed your Oracle Database software, created a new database, configured a listener and also Enterprise Manager for the new database.
And all without using X forwarding, only by command line. In fact, I’ll have to think which way yo go for my next Oracle Database installation, as the response files method seems pretty fast, and very useful in case of many or similar database creation / installation.
I hope this steps would be useful to someone and please feel free to post any comment or improvement! 🙂