Home » Infrastructure » Unix » I can't start database ORCL in Solaris (Solaris)
icon9.gif  I can't start database ORCL in Solaris [message #341874] Wed, 20 August 2008 12:05 Go to next message
Santti
Messages: 8
Registered: August 2008
Location: Mexico
Junior Member
Hi,
I Have Installed oracle 10g database (Enterprise Edition)
On Sun Solaris (5.10) machine
(in oracle User)
installation was successful
But database is not getting started

I think the problem is with the PFILE because in my:

/export/home/oracle/dbs/

I don't have:

spfile.ora
init$ORACLE_SID.ora
spfile$ORACLE_SID.ora

only I have:

init.ora
spfileorcl.ora

but my $ORACLE_SID it was ORA10GR2 and I change to $ORACLE_SID=ORCL

and i have two questions:
First, how affect that change??

and second, how start the database??

please guide me... thnks...

Santti...

Re: I can't start database ORCL in Solaris [message #341875 is a reply to message #341874] Wed, 20 August 2008 12:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

>but my $ORACLE_SID it was ORA10GR2 and I change to $ORACLE_SID=ORCL
Why did you do this?

Is the database up or down now?
Re: I can't start database ORCL in Solaris [message #341876 is a reply to message #341875] Wed, 20 August 2008 12:20 Go to previous messageGo to next message
Santti
Messages: 8
Registered: August 2008
Location: Mexico
Junior Member

the change in ORACLE_SID I did because I don't have the file spfile.ora and i think that I did declare bad the ORACLE_SID....

and the database is down now...
Re: I can't start database ORCL in Solaris [message #341877 is a reply to message #341876] Wed, 20 August 2008 12:23 Go to previous messageGo to next message
Santti
Messages: 8
Registered: August 2008
Location: Mexico
Junior Member
the error is:

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/export/home/oracle/dbs/initORA10GR2.ora'
Re: I can't start database ORCL in Solaris [message #341879 is a reply to message #341874] Wed, 20 August 2008 12:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
do the following:
su -
updatedb
locate spfile
locate init | grep ora$

Use CUT & PASTE & post the results back here
Re: I can't start database ORCL in Solaris [message #341880 is a reply to message #341879] Wed, 20 August 2008 12:31 Go to previous messageGo to next message
Santti
Messages: 8
Registered: August 2008
Location: Mexico
Junior Member
bash-3.00$ su -
Password:
Aug 20 12:28:30 unknown su: 'su root' succeeded for root on /dev/pts/5
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
You have new mail.
# updatedb
updatedb: not found
# locate spfile
locate: not found
# locate init | grep ora$
locate: not found
Re: I can't start database ORCL in Solaris [message #341881 is a reply to message #341874] Wed, 20 August 2008 12:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Those commands work on Linux.
I don't have a Solaris system to test against.
You need to find the functional equivalent for them on Solaris.

Simply put are the any 'spfile' files or init<SID>.ora files anywhere else on this system?
If so, what are their timestamps & contents?
Re: I can't start database ORCL in Solaris [message #341887 is a reply to message #341881] Wed, 20 August 2008 12:50 Go to previous messageGo to next message
Santti
Messages: 8
Registered: August 2008
Location: Mexico
Junior Member

ok, the files found are:
/export/home/oracle/dbs/initdw.ora
/export/home/oracle/dbs/init.ora
/export/home/oracle/dbs/spfileorcl.ora
/export/home/oracle/hs/admin/inithsodbc.ora
/export/home/oracle/mgw/admin/sample_mgw.ora
/export/home/oracle/network/admin/samples/listener.ora
/export/home/oracle/network/admin/samples/sqlnet.ora
/export/home/oracle/network/admin/samples/tnsnames.ora
/export/home/oracle/network/admin/sqlnet.ora
/export/home/oracle/network/admin/listener.ora
/export/home/oracle/network/admin/tnsnames.ora
/export/home/oracle/rdbms/admin/externaljob.ora
/export/home/oracle/rdbms/install/filemap.ora
/export/home/oracle/srvm/admin/init.ora
/opt/ORCLfmap/prot1_32/etc/filemap.ora



Re: I can't start database ORCL in Solaris [message #341889 is a reply to message #341874] Wed, 20 August 2008 12:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ls -l /export/home/oracle/dbs/spfileorcl.ora
strings /export/home/oracle/dbs/spfileorcl.ora | grep db

do above & post CUT & PASTE results from above
Re: I can't start database ORCL in Solaris [message #341890 is a reply to message #341889] Wed, 20 August 2008 13:01 Go to previous messageGo to next message
Santti
Messages: 8
Registered: August 2008
Location: Mexico
Junior Member
ok,

bash-3.00# ls -l /export/home/oracle/dbs/spfileorcl.ora
-rw-r-----   1 oracle   other       2560 ago 18 19:01 /export/home/oracle/dbs/spfileorcl.ora
bash-3.00# strings /export/home/oracle/dbs/spfileorcl.ora | grep db
orcl.__db_cache_size=67108864
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/opt/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
bash-3.00# 

Re: I can't start database ORCL in Solaris [message #341891 is a reply to message #341874] Wed, 20 August 2008 13:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please realize that *nix (Including Solaris) is a case sensitive OS

as user "oracle" or who ever own the $ORACLE_HOME software directory tree do:

ORACLE_SID=orcl
export ORACLE_SID
sqlplus
/ as sysdba
startup
exit
Re: I can't start database ORCL in Solaris [message #341893 is a reply to message #341891] Wed, 20 August 2008 13:17 Go to previous messageGo to next message
Santti
Messages: 8
Registered: August 2008
Location: Mexico
Junior Member
ok,

bash-3.00# su - oracle
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
You have new mail.
-bash-3.00$ ORACLE_SID=orcl
-bash-3.00$ export ORACLE_SID
-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Aug 20 13:13:47 2008

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORA-09925: Unable to create audit trail file
Intel SVR4 UNIX Error: 2: No such file or directory
Additional information: 9925
SQL> exit
Disconnected
-bash-3.00$ 
Re: I can't start database ORCL in Solaris [message #341894 is a reply to message #341874] Wed, 20 August 2008 13:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Either stay with MS Access or learn how to RTFM & follow installation procedures

http://download.oracle.com/docs/cd/B19306_01/relnotes.102/b15689/toc.htm
Re: I can't start database ORCL in Solaris [message #341907 is a reply to message #341893] Wed, 20 August 2008 13:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
ORA-09925: Unable to create audit trail file
Cause: ORACLE was not able to create the file being used to hold audit trail records.
Action: Check the UNIX error number for a possible operating system error. If there is no error, contact ORACLE customer support.

Regards
Michel
Re: I can't start database ORCL in Solaris [message #342263 is a reply to message #341907] Thu, 21 August 2008 17:19 Go to previous message
Santti
Messages: 8
Registered: August 2008
Location: Mexico
Junior Member
My problem was in the installation (basic installation) because I wanted startup a database but I had not created a database.... and now I install with advanced Installation and specify database configuration options.....

anyway thank you very much...
Previous Topic: Run report in a background
Next Topic: Oracle performance running on Sun Niagara Processors
Goto Forum:
  


Current Time: Wed Nov 13 00:01:09 CST 2024