I have installed Oracle 11g and ASM libraries.
Also, I have created the database but when I tried to add a tablespace, it just says that database is "Not Open". Whenever I try to open the db, it complains that it is not allowed for this instance type.
GRIDracle:/home/oracle/
/>sqlplus 'sys/xxxx as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 4 22:42:30 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
SQL> select path,mount_status from v$ASM_DISK ;
PATH
--------------------------------------------------------------------------------
MOUNT_S
-------
ORCL:ORADATA1
CACHED
ORCL:ORADATA2
CACHED
ORCL:ORADATA3
CACHED
PATH
--------------------------------------------------------------------------------
MOUNT_S
-------
ORCL:ORADATA4
CACHED
SQL> show parameter_type instace_type ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_type string asm
SQL>
SQL> CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON;
CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON
*
ERROR at line 1:
ORA-01109: database not open
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-15000: command disallowed by current instance type
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
GRIDracle:/home/oracle/
/>sqlplus 'sys/xxxx as sysasm'
SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 4 22:57:16 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-15000: command disallowed by current instance type
SQL> CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON;
CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON
*
ERROR at line 1:
ORA-01109: database not open
SQL>
Any help in me creating the tablespace is appreciated.
Thanks
P
Also, I have created the database but when I tried to add a tablespace, it just says that database is "Not Open". Whenever I try to open the db, it complains that it is not allowed for this instance type.
GRIDracle:/home/oracle/
/>sqlplus 'sys/xxxx as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 4 22:42:30 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
SQL> select path,mount_status from v$ASM_DISK ;
PATH
--------------------------------------------------------------------------------
MOUNT_S
-------
ORCL:ORADATA1
CACHED
ORCL:ORADATA2
CACHED
ORCL:ORADATA3
CACHED
PATH
--------------------------------------------------------------------------------
MOUNT_S
-------
ORCL:ORADATA4
CACHED
SQL> show parameter_type instace_type ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_type string asm
SQL>
SQL> CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON;
CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON
*
ERROR at line 1:
ORA-01109: database not open
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-15000: command disallowed by current instance type
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
GRIDracle:/home/oracle/
/>sqlplus 'sys/xxxx as sysasm'
SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 4 22:57:16 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-15000: command disallowed by current instance type
SQL> CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON;
CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON
*
ERROR at line 1:
ORA-01109: database not open
SQL>
Any help in me creating the tablespace is appreciated.
Thanks
P