Home > Oracle > Howto use SPFILE instead of init.ora

Howto use SPFILE instead of init.ora

Here is a great article on the subject

But basical you can check to see if your instance is using a spfile on startup by issueing the following command


SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string

In the above example there is no spfile attached to the instance at startup, so let’s create one.
This can be done by using the following command:


SQL> create spfile from pfile;

File created.

CREATE SPFILE [='spfile_name'] FROM PFILE [='pfile_name'];

You must restart your instance afterwards…
That’all,folks!

About these ads
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: