tomvv
asked on
invalid input
[oracle@mac dbs]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 18 16:56:14 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 128 found in the input file
SQL>
What is the reason for the input..
SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 18 16:56:14 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 128 found in the input file
SQL>
What is the reason for the input..
ASKER
I did not edit spfile..
From the below output it is clear that there is no spfile only initorcl.ora
[oracle@mac dbs]$ ls -ltr
total 9636
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
drwx------ 2 oracle oinstall 4096 Aug 27 05:07 peshm_orcl_0
-rw-rw---- 1 oracle oinstall 1544 Aug 27 05:07 hc_orcl.dat
-rw-r----- 1 oracle oinstall 24 Aug 27 05:09 lkORCL
-rw-r----- 1 oracle oinstall 1536 Aug 27 05:18 orapworcl
drwx------ 2 oracle oinstall 4096 Aug 27 05:29 peshm_DBUA0_0
-rw-rw---- 1 oracle oinstall 1544 Aug 27 05:29 hc_DBUA0.dat
drwx------ 2 oracle oinstall 4096 Aug 27 05:43 peshm_bank_0
-rw-rw---- 1 oracle oinstall 1544 Aug 27 05:44 hc_bank.dat
-rw-r----- 1 oracle oinstall 1536 Aug 27 12:11 orapwbank
drwx------ 2 oracle oinstall 4096 Aug 27 23:09 peshm_sbi_0
-rw-rw---- 1 oracle oinstall 1544 Aug 27 23:10 hc_sbi.dat
-rw-r----- 1 oracle oinstall 24 Aug 27 23:11 lkSBI
-rw-r--r-- 1 oracle oinstall 919 Aug 28 02:21 Desktop
-rw-r--r-- 1 oracle oinstall 905 Aug 28 10:04 initsat.ora
drwx------ 2 oracle oinstall 4096 Aug 28 10:06 peshm_sat_0
-rw-rw---- 1 oracle oinstall 1544 Aug 28 10:07 hc_sat.dat
-rw-r--r-- 1 oracle oinstall 0 Aug 28 10:31 startup
-rw-r--r-- 1 oracle oinstall 0 Aug 28 10:31 shutdown
-rw-r--r-- 1 oracle oinstall 0 Aug 28 10:31 conn
-rw-r--r-- 1 oracle oinstall 0 Aug 28 10:31 exit
drwx------ 2 oracle oinstall 4096 Aug 28 10:42 peshm_dat_0
-rw-rw---- 1 oracle oinstall 1544 Aug 28 10:48 hc_dat.dat
-rw-r----- 1 oracle oinstall 24 Aug 28 13:58 lkDAT
-rw-r--r-- 1 oracle oinstall 878 Aug 28 14:43 initdat.ora
-rw-r----- 1 oracle oinstall 2560 Sep 12 00:18 spfiledat.ora
-rw-r--r-- 1 oracle oinstall 942 Sep 13 13:55 initorcl.ora
-rw-r----- 1 oracle oinstall 9748480 Sep 16 14:07 snapcf_sbi.f
-rw-r----- 1 oracle oinstall 2560 Sep 18 08:10 spfilesbi.ora
-rw-r----- 1 oracle oinstall 1536 Sep 18 08:14 orapwsbi
[oracle@mac dbs]$ ls
Also I tried to create like this too..
It did not work out....
From the below output it is clear that there is no spfile only initorcl.ora
[oracle@mac dbs]$ ls -ltr
total 9636
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
drwx------ 2 oracle oinstall 4096 Aug 27 05:07 peshm_orcl_0
-rw-rw---- 1 oracle oinstall 1544 Aug 27 05:07 hc_orcl.dat
-rw-r----- 1 oracle oinstall 24 Aug 27 05:09 lkORCL
-rw-r----- 1 oracle oinstall 1536 Aug 27 05:18 orapworcl
drwx------ 2 oracle oinstall 4096 Aug 27 05:29 peshm_DBUA0_0
-rw-rw---- 1 oracle oinstall 1544 Aug 27 05:29 hc_DBUA0.dat
drwx------ 2 oracle oinstall 4096 Aug 27 05:43 peshm_bank_0
-rw-rw---- 1 oracle oinstall 1544 Aug 27 05:44 hc_bank.dat
-rw-r----- 1 oracle oinstall 1536 Aug 27 12:11 orapwbank
drwx------ 2 oracle oinstall 4096 Aug 27 23:09 peshm_sbi_0
-rw-rw---- 1 oracle oinstall 1544 Aug 27 23:10 hc_sbi.dat
-rw-r----- 1 oracle oinstall 24 Aug 27 23:11 lkSBI
-rw-r--r-- 1 oracle oinstall 919 Aug 28 02:21 Desktop
-rw-r--r-- 1 oracle oinstall 905 Aug 28 10:04 initsat.ora
drwx------ 2 oracle oinstall 4096 Aug 28 10:06 peshm_sat_0
-rw-rw---- 1 oracle oinstall 1544 Aug 28 10:07 hc_sat.dat
-rw-r--r-- 1 oracle oinstall 0 Aug 28 10:31 startup
-rw-r--r-- 1 oracle oinstall 0 Aug 28 10:31 shutdown
-rw-r--r-- 1 oracle oinstall 0 Aug 28 10:31 conn
-rw-r--r-- 1 oracle oinstall 0 Aug 28 10:31 exit
drwx------ 2 oracle oinstall 4096 Aug 28 10:42 peshm_dat_0
-rw-rw---- 1 oracle oinstall 1544 Aug 28 10:48 hc_dat.dat
-rw-r----- 1 oracle oinstall 24 Aug 28 13:58 lkDAT
-rw-r--r-- 1 oracle oinstall 878 Aug 28 14:43 initdat.ora
-rw-r----- 1 oracle oinstall 2560 Sep 12 00:18 spfiledat.ora
-rw-r--r-- 1 oracle oinstall 942 Sep 13 13:55 initorcl.ora
-rw-r----- 1 oracle oinstall 9748480 Sep 16 14:07 snapcf_sbi.f
-rw-r----- 1 oracle oinstall 2560 Sep 18 08:10 spfilesbi.ora
-rw-r----- 1 oracle oinstall 1536 Sep 18 08:14 orapwsbi
[oracle@mac dbs]$ ls
Also I tried to create like this too..
It did not work out....
>>From the below output it is clear that there is no spfile only initorcl.ora
Based on your other questions, what is the database/instance you are working with?
ORCL is the 'default' that Oracle uses. It looks like you have a 'dat' and an 'sbi' instance or did have at one time.
>>Also I tried to create like this too..
Did you forget to post something?
Based on your other questions, what is the database/instance you are working with?
ORCL is the 'default' that Oracle uses. It looks like you have a 'dat' and an 'sbi' instance or did have at one time.
>>Also I tried to create like this too..
Did you forget to post something?
ASKER
ya I forgot
here is that..
the output is blank..
for this
SQL> create spfile from pfile='/u01/app/oracle/pro duct/11.2. 0/db_1/dbs /initorcl. ora'
here is that..
the output is blank..
for this
SQL> create spfile from pfile='/u01/app/oracle/pro
Assuming your database is ORCL: What was the problem with that command?
That also doesn't answer the question of what is the database you are trying to work with?
What is the value of ORACLE_SID? From a command prompt: echo $ORACLE_SID
That also doesn't answer the question of what is the database you are trying to work with?
What is the value of ORACLE_SID? From a command prompt: echo $ORACLE_SID
ASKER
orcl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you did, copy it to a known location and use it as a pfile.
cp myoldspfile.ora /tmp/mynewpfile.ora
then try:
startup pfile='/tmp/mynewpfile.ora
if it starts:
create spfile from pfile='/tmp/mynewpfile.ora