# listener.ora Network Configuration File: /opt/u01/oracle/product/12.2.1/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
LOCAL_LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
    )
  )

# tnsnames.ora Network Configuration File: /opt/u01/oracle/product/12.2.1/grid/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.dbtest)
    )
  )

# ---------------------------------------------------
# .bash_profile
# ---------------------------------------------------
# OS User:      oracle
# Application:  Oracle Database Software Owner
#               Oracle Grid Infrastructure for a
#               Standalone Server
# Version:      Oracle 12c Release 1 (12.1.0.2)
# ---------------------------------------------------

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
      . ~/.bashrc
      fi
      
      alias ls="ls -FA"
      
      # ---------------------------------------------------
      # ORACLE_SID
      # ---------------------------------------------------
      # Specifies the Oracle system identifier (SID) for
      # the Oracle instance running on this node. When
      # using RAC, each node must have a unique ORACLE_SID.
      # (i.e. racdb1, racdb2,...)
      # ---------------------------------------------------
      ORACLE_SID=orcl.dbtest; export ORACLE_SID
      
      # ---------------------------------------------------
      # ORACLE_UNQNAME and ORACLE_HOSTNAME
      # ---------------------------------------------------
      # In previous releases of Oracle Database, you were 
      # required to set environment variables for
      # ORACLE_HOME and ORACLE_SID to start, stop, and
      # check the status of Enterprise Manager. With
      # Oracle Database 11g Release 2 (11.2) and later, you
      # need to set the environment variables ORACLE_HOME, 
      # ORACLE_UNQNAME, and ORACLE_HOSTNAME to use
      # Enterprise Manager. Set ORACLE_UNQNAME equal to
      # the database unique name and ORACLE_HOSTNAME to
      # the hostname of the machine.
      # ---------------------------------------------------
      ORACLE_UNQNAME=orcl.dbtest; export ORACLE_UNQNAME
      ORACLE_HOSTNAME=localhost; export ORACLE_HOSTNAME
      
      # ---------------------------------------------------
      # JAVA_HOME
      # ---------------------------------------------------
      # Specifies the directory of the Java SDK and Runtime
      # Environment.
      # ---------------------------------------------------
      JAVA_HOME=/usr/local/java; export JAVA_HOME
      
      # ---------------------------------------------------
      # ORACLE_BASE
      # ---------------------------------------------------
      # Specifies the base of the Oracle directory structure
      # for Optimal Flexible Architecture (OFA) compliant
      # database software installations.
      # ---------------------------------------------------
      ORACLE_BASE=/opt/u01/oracle; export ORACLE_BASE
      
      # ---------------------------------------------------
      # ORACLE_HOME
      # ---------------------------------------------------
      # Specifies the directory containing the Oracle
      # Database software.
      # ---------------------------------------------------
      ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/dbhome_1; export ORACLE_HOME
      
      # ---------------------------------------------------
      # GRID_HOME
      # ---------------------------------------------------
      # Specifies the directory containing the
      # Oracle Grid Infrastructure for a Standalone Server.
      # ---------------------------------------------------
      GRID_HOME=$ORACLE_BASE/product/12.2.1/grid; export GRID_HOME
      
      # ---------------------------------------------------
      # ORACLE_PATH
      # ---------------------------------------------------
      # Specifies the search path for files used by Oracle
      # applications such as SQL*Plus. If the full path to
      # the file is not specified, or if the file is not
      # in the current directory, the Oracle application
      # uses ORACLE_PATH to locate the file.
      # This variable is used by SQL*Plus, Forms and Menu.
      # ---------------------------------------------------
      ORACLE_PATH=/opt/u01/oracle/dba_scripts/sql:$ORACLE_HOME/rdbms/admin; export ORACLE_PATH
      
      # ---------------------------------------------------
      # SQLPATH
      # ---------------------------------------------------
      # Specifies the directory or list of directories that
      # SQL*Plus searches for a login.sql file.
      # ---------------------------------------------------
      # SQLPATH=/u01/app/oracle/dba_scripts/sql; export SQLPATH
      
      # ---------------------------------------------------
      # ORACLE_TERM
      # ---------------------------------------------------
      # Defines a terminal definition. If not set, it
      # defaults to the value of your TERM environment
      # variable. Used by all character mode products. 
      # ---------------------------------------------------
      ORACLE_TERM=xterm; export ORACLE_TERM
      
      # ---------------------------------------------------
      # NLS_DATE_FORMAT
      # ---------------------------------------------------
      # Specifies the default date format to use with the
      # TO_CHAR and TO_DATE functions. The default value of
      # this parameter is determined by NLS_TERRITORY. The
      # value of this parameter can be any valid date
      # format mask, and the value must be surrounded by 
      # double quotation marks. For example:
      #
      #         NLS_DATE_FORMAT = "MM/DD/YYYY"
      #
      # ---------------------------------------------------
      NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
      
      # ---------------------------------------------------
      # TNS_ADMIN
      # ---------------------------------------------------
      # Specifies the directory containing the Oracle Net
      # Services configuration files like listener.ora, 
      # tnsnames.ora, and sqlnet.ora. When using Oracle
      # ASM, the TNS listener will be run out of
      # GRID_HOME; otherwise the listener will be run out
      # ORACLE_HOME.
      # ---------------------------------------------------
      # TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
      TNS_ADMIN=$GRID_HOME/network/admin; export TNS_ADMIN
      
      # ---------------------------------------------------
      # ORA_NLS11
      # ---------------------------------------------------
      # Specifies the directory where the language,
      # territory, character set, and linguistic definition
      # files are stored.
      # ---------------------------------------------------
      ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11
      
      # ---------------------------------------------------
      # PATH
      # ---------------------------------------------------
      # Used by the shell to locate executable programs;
      # must include the $ORACLE_HOME/bin directory.
      # ---------------------------------------------------
      PATH=.:${JAVA_HOME}/bin:$JAVA_HOME/db/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
      PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
      PATH=${PATH}:/opt/u01/oracle/dba_scripts/bin
      export PATH
      
      # ---------------------------------------------------
      # LD_LIBRARY_PATH
      # ---------------------------------------------------
      # Specifies the list of directories that the shared
      # library loader searches to locate shared object
      # libraries at runtime.
      # ---------------------------------------------------
      LD_LIBRARY_PATH=$ORACLE_HOME/lib
      LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
      LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
      export LD_LIBRARY_PATH
      
      # ---------------------------------------------------
      # CLASSPATH
      # ---------------------------------------------------
      # The class path is the path that the Java runtime
      # environment searches for classes and other resource
      # files. The class search path (more commonly known
      # by the shorter name, "class path") can be set using
      # either the -classpath option when calling a JDK
      # tool (the preferred method) or by setting the
      # CLASSPATH environment variable. The -classpath
      # option is preferred because you can set it
      # individually for each application without affecting
      # other applications and without other applications
      # modifying its value.
      # ---------------------------------------------------
      CLASSPATH=.:$ORACLE_HOME/jdbc/lib/ojdbc6.jar
      CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
      CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
      export CLASSPATH
      
      # ---------------------------------------------------
      # THREADS_FLAG
      # ---------------------------------------------------
      # All the tools in the JDK use green threads as a
      # default. To specify that native threads should be
      # used, set the THREADS_FLAG environment variable to
      # "native". You can revert to the use of green
      # threads by setting THREADS_FLAG to the value
      # "green".
      # ---------------------------------------------------
      THREADS_FLAG=native; export THREADS_FLAG
      
      # ---------------------------------------------------
      # TEMP, TMP, and TMPDIR
      # ---------------------------------------------------
      # Specify the default directories for temporary
      # files; if set, tools that create temporary files
      # create them in one of these directories.
      # ---------------------------------------------------
      export TEMP=/tmp
      export TMPDIR=/tmp
      
      # ---------------------------------------------------
      # UMASK
      # ---------------------------------------------------
      # Set the default file mode creation mask
      # (umask) to 022 to ensure that the user performing
      # the Oracle software installation creates files
      # with 644 permissions.
      # ---------------------------------------------------
      umask 022

# listener.ora Network Configuration File: /opt/u01/oracle/product/12.2.1/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 15.119.202.187)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
    )
  )

# tnsnames.ora Network Configuration File: /opt/u01/oracle/product/12.2.1/grid/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.dbtest)
    )
  )

/opt/u01/oracle/product/12.1.0.2/dbhome_1/dbs/init.ora
/opt/u01/oracle/product/12.2.1/grid/dbs/init.ora

/opt/u01/oracle/product/12.1.0.2/dbhome_1/dbs/initorcl.ora

# 
# $Header: rdbms/admin/init.ora /main/24 2012/02/03 08:24:01 ysarig Exp $ 
# 
# Copyright (c) 1991, 1997, 1998 by Oracle Corporation
# NAME
#   init.ora
# FUNCTION
# NOTES
# MODIFIED
#     ysarig     02/01/12  - Renaming flash_recovery_area to
#                            fast_recovery_area
#     ysarig     05/14/09  - Updating compatible to 11.2
#     ysarig     08/13/07  - Fixing the sample for 11g
#     atsukerm   08/06/98 -  fix for 8.1.
#     hpiao      06/05/97 -  fix for 803
#     glavash    05/12/97 -  add oracle_trace_enable comment
#     hpiao      04/22/97 -  remove ifile=, events=, etc.
#     alingelb   09/19/94 -  remove vms-specific stuff
#     dpawson    07/07/93 -  add more comments regarded archive start
#     maporter   10/29/92 -  Add vms_sga_use_gblpagfile=TRUE 
#     jloaiza    03/07/92 -  change ALPHA to BETA 
#     danderso   02/26/92 -  change db_block_cache_protect to _db_block_cache_p
#     ghallmar   02/03/92 -  db_directory -> db_domain 
#     maporter   01/12/92 -  merge changes from branch 1.8.308.1 
#     maporter   12/21/91 -  bug 76493: Add control_files parameter 
#     wbridge    12/03/91 -  use of %c in archive format is discouraged 
#     ghallmar   12/02/91 -  add global_names=true, db_directory=us.acme.com 
#     thayes     11/27/91 -  Change default for cache_clone 
#     jloaiza    08/13/91 -         merge changes from branch 1.7.100.1 
#     jloaiza    07/31/91 -         add debug stuff 
#     rlim       04/29/91 -         removal of char_is_varchar2 
#   Bridge     03/12/91 - log_allocation no longer exists
#   Wijaya     02/05/91 - remove obsolete parameters
#
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation as a starting point for
# customizing the Oracle Database installation for your site. 	 
#
# NOTE: The values that are used in this file are example values only.
# You may want to adjust those values for your specific requirements. 
# You might also consider using the Database Configuration Assistant	 
# tool (DBCA) to create a server-side initialization parameter file
# and to size your initial set of tablespaces. See the
# Oracle Database 2 Day DBA guide for more information.
###############################################################################

# Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
# install time)

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300 
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'

SPFILE='+FRA/orcl/spfileorcl.ora'

shutdown abort
startup nomount
create pfile=/tmp/init.ora from spfile;
shutdown

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+FRA/orcl/spfileorcl.ora'
ORA-17503: ksfdopn:2 Failed to open file +FRA/orcl/spfileorcl.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +FRA/orcl/spfileorcl.ora
ORA-15173: entry 'spfileorcl.ora' does not exist in directory 'orcl'
ORA-06512: at line 4
SQL> create pfile=/tmp/init.ora from spfile;
create pfile=/tmp/init.ora from spfile
             *
ERROR at line 1:
ORA-02236: invalid file name