answersLogoWhite

0

Create spfile from pfile with the below command:

create spfile from pfile;

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the use of spfile and init.ora in oracle?

init.ora and SPfile both contain information about DB parameters. The database cannot start without an INIT.ORA but can start without an SPfile. An SPfile cannot be edited directly , but one can be configured via the pfile (init.ora) Init.ora is saved in ascii text format whereas the SPfile is saved in a binary format. If both files exist , the database reads the SPfile first before processing the init.ora. Oracle Guru's step in and correct if necessary .......... :) , Lekarshi


Which two interfaces will allow access via the VTY lines to configure the router?

USb or AUX


What must be done before a router can be accessed via telnet?

Configure an IP address on the relevant network interface and bring it up. Configure a password on at least on vty line and give the login command.


Why must you use a console connection to initially configure the switch why not to the switch via telnet or ssh?

If you've got a new switch, all basic settings must be configured using a console cable. SSHing or telnetting to a switch is imposible without an IP address. Therefore you must first configure all the basic settings via console.


Do you need a Gmail for the galaxy phone?

You can install Gmail on a galaxy phone. Gmail can be installed via a Gmail app. This app can easily configure mail in that.


Digital photos onto Macintosh computers?

Connect the camera via USB and the drive will appear on the desktop. You can configure iPhoto to automatically download the images from the camera.


Do you need a PC in order for a laptop to work via a router?

A laptop is a PC. You don't need a desktop PC to configure a router, you can use a laptop to do so, by connecting to the router via a network adaptater - either via wifi or ethernet. Both ways of connecting are included on laptops nowadays.


What is difference between PFile and SPFile?

When an Oracle Instance is started, the characteristics of the Instance are established by parameters specified within the initialization parameter file. These initialization parameters are either stored in a PFILE or SPFILE. SPFILEs are available in Oracle 9i and above. All prior releases of Oracle are using PFILEs. SPFILEs provide the following advantages over PFILEs: * An SPFILE can be backed-up with RMAN (RMAN cannot backup PFILEs) * Reduce human errors. The SPFILE is maintained by the server. Parameters are checked before changes are accepted. * Eliminate configuration problems (no need to have a local PFILE if you want to start Oracle from a remote machine) * Easy to find - stored in a central location What is the difference between a PFILE and SPFILE:A PFILE is a static, client-side text file that must be updated with a standard text editor like "notepad" or "vi". This file normally reside on the server, however, you need a local copy if you want to start Oracle from a remote machine. DBA's commonly refer to this file as the INIT.ORA file. An SPFILE (Server Parameter File), on the other hand, is a persistent server-side binary file that can only be modified with the "ALTER SYSTEM SET" command. This means you no longer need a local copy of the pfile to start the database from a remote machine. Editing an SPFILE will corrupt it, and you will not be able to start your database anymore.


Hihope you are fine in which website can we check gmailyahoo mail and hotmail all in one valuing your response sunil?

Some email servers can be accessed via POP3 (or IMAP4). You can install an email client, and access any of these, as long as they have the option to configure POP3 or IMAP4. Or you can configure a Web-based email system, to get email from other accounts. Once again, this assumes the servers you want to access have the option to access either via POP3 or via IMAP4. I am not entirely sure which servers have this option; GMail does, but I am not sure about the others.


Which situations require that you configure an ip address for a switch?

you plan to use the virtual switch manager you plan to connect to the switch via telnet you plan to use SNMP on the switch


In kingdom hearts on ds how do you configure your shortcuts?

Under the configure menu. Personally, i found it easier to not configure at all


How does user configure vsat?

How does user Configure Vsat on computer?