 I can't start database ORCL in Solaris [message #341874] |
Wed, 20 August 2008 12:05  |
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 #341880 is a reply to message #341879] |
Wed, 20 August 2008 12:31  |
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 #341887 is a reply to message #341881] |
Wed, 20 August 2008 12:50 |
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 #341890 is a reply to message #341889] |
Wed, 20 August 2008 13:01 |
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 #341893 is a reply to message #341891] |
Wed, 20 August 2008 13:17 |
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 #342263 is a reply to message #341907] |
Thu, 21 August 2008 17:19 |
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...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
