Tizag.com Webmaster Tutorials - A collection of webmaster tutorials from HTML to PHP.

Saturday, September 1, 2007

How to start an Oracle Server

Procedure to start SSM, all the text in RED is a command that you have to type.

Login as root and do the following (password root: ora786)
[root@ssm root]# ./start_apache

You will get the messages
Oracle Home: /u/oracle/product/9.2.0
Oracle SID: SAHINLER
Starting Apache....
/usr/local/apache/bin/apachectl start: Apache started

Next step will be, start Oracle
[root@ssm root]# su - oracle
password: ora123

Now start the AGENT SQL as below

[oracle@ssm oracle]$ agentctl start
you will get the message
DBSNMP for Linux: Version 9.2.0.4.0 - Production on 22-OCT-2004 14:22:35

Copyright (c) 2003 Oracle Corporation. All rights reserved.

Starting Oracle Intelligent Agent....
Agent started

Start the Listerner as below

[oracle@ssm oracle]$ lsnrctl start

Start the Oracle DB

[oracle@ssm oracle]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Oct 22 14:22:56 2004

SQL> connect /as sysdba
SQL> startup

you will get the follwoing message

ORACLE instance started.

Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.

No comments: