| Unable to start oracle 10g instance on solaris [message #279096] |
Tue, 06 November 2007 22:15  |
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 #279101 is a reply to message #279098] |
Tue, 06 November 2007 22:47  |
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???
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
