Oracle Database Discussions

Hi experts,

Please help in log in to my database, which unfortunately was happening an hour before, but now it is not working

In between I only did a change in some permission stuff for my base directory, but later brought it back to original permissions.

Still it is haunting me..

I have set up my SID/HOME/PATH perfectly, tried to check processes at OS level, they are less, still nothing is happening though database is up and running.

I can see it at OS level and through ALert log..

==================


oracle@dap-csw-ora01 /home/oracle > ps -ef|grep pmon
oracle 3145946 1 0 18 feb - 0:44 asm_pmon_+ASM1
oracle 7995430 1 0 18 feb - 0:50 ora_pmon_adobe_2
oracle 13828212 11141232 0 14:59:09 pts/0 0:00 grep pmon
oracle 7471386 1 0 18 feb - 0:57 ora_pmon_fxss_1
oracle@dap-csw-ora01 /home/oracle > sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 21 14:59:12 2013

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

Enter user-name: /as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> select instance_name,status from v$Instance;
select instance_name,status from v$Instance
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0