trouble shooting

ORA-28000: The account is lockedORA-28000: The account is locked
Another wild guess, did you create your user with a case-sensitive name?
SQL> create user "dbFan" identified by dbfan account lock;
User created.
SQL> select username, account_status from dba_users where username='dbFan';
USERNAME ACCOUNT_STATUS
------------- --------------------------------
dbFan LOCKED
SQL> alter user dbFan account unlock;
alter user dbFan account unlock*ERROR at line 1:
ORA-01918: user 'DBFAN' does not exist
SQL> alter user "dbFan" account unlock;
User altered.
SQL>
See what SQL users are running on the systemOnce we figure out who is on the system, we will probably want to know what they are doing. In this case, we will join the v$session view we just queried with another view, the V$SQL view. The V$SQL view will provide us with the SQL that is being executed on our system. Let’s see GRUMPY’s session details:
SQL> select a.sid, a.serial#, b.sql_text
2 from v$session a, v$sqlarea b
3 where a.sql_address=b.address
4 and a.username='GRUMPY';
SID SERIAL# SQL_TEXT
---- --------- -------------------------------------
122 61521 select count(*) from gen_person where gen_person_id=95000

FINDING WHICH INDEX BELONGS TO WHICH TABLE AND OWNER OF THE INDEX...
Select index_owner, table_name, index_name, column_nameFROM dba_ind_columns;
SQL> column table_owner format a15
SQL> column table_name format a20
SQL> column index_name format a20
SQL> column column_name format a20
SQL> Select owner, table_name, index_name, column_name
2 FROM dba_ind_columns
3 Order by owner, table_name, column_position
4 Where owner=’SCOTT’
5 AND table_name=’EMP’;
TABLE_OWNER TABLE_NAME INDEX_NAME COLUMN_NAME
------------------ --------------- ------ --------- ----------
SCOTT EMP

Monitoring Temporary Tablespaces and Sorting:
Unlike datafiles, tempfiles are not listed in V$DATAFILE and DBA_DATA_FILES. Use V$TEMPFILE and DBA_TEMP_FILES instead.
One can monitor temporary segments from V$SORT_SEGMENT and V$SORT_USAGE
DBA_FREE_SPACE does not record free space for temporary tablespaces. Use V$TEMP_SPACE_HEADER instead:

SQL> select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER;
TABLESPACE_NAME BYTES_USED BYTES_FREE
------------------------------ ---------- ----------
TEMP 52428800 52428800

SQL> startup
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-01991: invalid password file 'C:\oracle\ora92\DATABASE\PWDjay.ORA'
to overcome this error
step one:
first delete the password file in the above destination
step two:
create a new password file using this query
orapwd file= orapwd file= (desination of pwdfile)\PWD(sid).ora password=oracleexampleC:\>orapwd file=c:\oracle\ora92\database\PWDjay.ora password=oracle;