(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.rmohan.com)(PORT=1521))) The listener supports no services The command completed successfully [oracle@db ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 20 00:42:10 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> select name from v$datafile; select name from v$datafile * ERROR at line 1: ORA-01034: ORACLE […]

[oracle@localhost ~]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 18-JAN-2012 22:45:15

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Welcome to LSNRCTL, type “help” for information.

LSNRCTL> reload Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused LSNRCTL> service Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))) TNS-12541: […]

A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes.

$ sqlplus /nolog

SQL> connect / as sysdba […]

Starting oracle listener

$ lsnrctl start

Start the database

$ dbstart

Starting oracle Enterprise manager $ emctl start dbconsole

Shutting down the database $ dbshut

Stopping the listener $ lsnrctl stop

Stopping oracle Enterprise manager $ emctl stop dbconsole

Starts sqlplus without logging in to a database # su ­ oracle $ sqlplus /nolog

Logging […]

To recover a password in Oracle, simply connect under command line mode on the server:

#sqlplus /nolog SQL>conn / as sysdba SQL>alter user Username identified by PASSWORD;

To reset your Orable database password:

Your password file should be under <orahome>\database\PWD<SID>.ora.

Delete it and run the Oracle password utility from the command prompt:

c\:Oracle\ora92\database>ORAPWD file=PWD<SID>.ora password={password} […]