Home » RDBMS Server » Server Administration » Unable to start oracle 10g instance on solaris (Oracle 10g on Solaris x86)
Unable to start oracle 10g instance on solaris [message #279096] Tue, 06 November 2007 22:15 Go to next message
panchpan
Messages: 34
Registered: October 2007
Member
Hello.
I have newly installed oracle on solaris OS. I had also created a db using dbca successfully and all was working fine. But after few days, when I was trying to create a db manually. I logged into the machine and did below step just to see the old created db ...How is it working and I got few errors:

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1279120 bytes
Variable Size 100666224 bytes
Database Buffers 62914560 bytes
Redo Buffers 2912256 bytes
SQL> select * from tabs;
select * from tabs
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted


SQL> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>

Could you please advice - What is going wrong here?

Thank you!
Re: Unable to start oracle 10g instance on solaris [message #279097 is a reply to message #279096] Tue, 06 November 2007 22:18 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

alter database mount;
alter database open;
Re: Unable to start oracle 10g instance on solaris [message #279098 is a reply to message #279096] Tue, 06 November 2007 22:21 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

By the way why you issued startup nomount as your objective is to open the database!
Re: Unable to start oracle 10g instance on solaris [message #279101 is a reply to message #279098] Tue, 06 November 2007 22:47 Go to previous messageGo to next message
panchpan
Messages: 34
Registered: October 2007
Member
Thank ya - It helped.

Actually, I want to create a database manually. I already have one db 'dev102ee' and it works fine created by DBCA.

To create another DB on Solaris now , I did as below:
SQL> shutdown normal;
then from unix prompt:
$export ORACLE_SID=dev102ee

then coming to oracle:
connect / as sysdba - Here again I see SQL> shutdown normal
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
$ export ORACLE_SID=dev103ee
$ sqlplus

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 7 15:42:23 2007

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

Enter user-name: connect as sysdba
Enter password:
Connected to an idle instance.

SQL>

Is it normal???
Re: Unable to start oracle 10g instance on solaris [message #279105 is a reply to message #279096] Tue, 06 November 2007 23:04 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

YEs, normal.
Previous Topic: License high water mark
Next Topic: Database shutdown in the midnight
Goto Forum:
  


Current Time: Fri Dec 09 05:43:28 CST 2016

Total time taken to generate the page: 0.05285 seconds