Missing Pfile

 Missing Pfile or Spfile:

step1:
     vi initxxx.ora
 Go to alert log location, from that
------------------------------------------------------
processes                = 150
  memory_target            = 1584M
  control_files            = "/orau01/app/oracle/oradata/prod/control01.ctl"
  control_files            = "/orau01/app/oracle/flash_recovery_area/prod/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/orau01/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 3882M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=prodXDB)"
  audit_file_dest          = "/orau01/app/oracle/admin/prod/adump"
  audit_trail              = "DB"
  db_name                  = "prod"
  open_cursors             = 300
  diagnostic_dest          = "/orau01/app/oracle"
-----------------------------------------------------------
copy and paste...

step2:
   connect sqlplus
   startup
Error came :ORA-00845: MEMORY_TARGET not supported on this system

SQL> !df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root
                       21G   17G  2.9G  86% /
tmpfs                1000M  420K 1000M   1% /dev/shm   <<<<------------------ increase this value
/dev/sda1             485M   41M  419M   9% /boot


from root
[root@localhost ~]# mount -t tmpfs shmfs -o size=2048m /dev/shm

 /etc/fstab

/dev/mapper/VolGroup-lv_root /                       ext4    defaults        1 1
UUID=9a9b0c22-cacf-491c-ad27-b636c69da3cf /boot                   ext4    defaults        1 2
/dev/mapper/VolGroup-lv_swap swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
shmfs                   /dev/shm                tmpfs   size=2048m      0 0   <<<<<<<<<---- add

following line


SQL> startup ;
ORACLE instance started.

Total System Global Area 1255473152 bytes
Fixed Size                  1344652 bytes
Variable Size             754977652 bytes
Database Buffers          486539264 bytes
Redo Buffers               12611584 bytes
Database mounted.



go to listener. ora and edit like this

SALES =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ssgtrn.com)(PORT = 1521))
      )
    )
  )

SID_LIST_SALES =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = SALES)
      (ORACLE_HOME = /orau01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = SALES)
    )
  )

go to tnsnames.ora and edit like this

SALES
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ssgtrn.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = SALES
    )
  )

check the listener by lsnrctl status sales
                      lsnrctl stop sales
                      lsnrctl start sales



Hope it's useful for u...