sql_servers oracle changelog.txt -- : open source web directory

return to: http:/www.sirfsup.com /sql_servers /oracle
Permalink: changelog.txt
Title: add
article options : please login | raw source view

Mon Jan 6 04:48:14 CST 2003

first: double-checked all memory parameters from /etc/rc.d/rc.local

ran dbca as the 'oracle' user

instance successfully created and initialized

new database created: db2
global database name=db2
ORA_SID=db2
sys password=sys
system password=system
serverparameters data file=/home/u01/dbs/spfiledb2.ora
anticipated, data in $ORACLE_hOME/oradata
anticipated, directory in $ORACLE_HOME/admin/db2
:r /etc/oratab

ps -aux

oracle    1890  0.0  0.7 333872 7576 ?       S    04:47   0:00 ora_pmon_db2
oracle    1892  0.0  0.7 335116 8036 ?       S    04:47   0:00 ora_dbw0_db2
oracle    1894  0.0  0.7 338240 7796 ?       S    04:47   0:00 ora_lgwr_db2
oracle    1896  0.0  0.6 333296 7152 ?       S    04:47   0:00 ora_ckpt_db2
oracle    1898  0.0  2.0 333300 21316 ?      S    04:47   0:00 ora_smon_db2
oracle    1900  0.0  0.9 333280 9740 ?       S    04:47   0:00 ora_reco_db2
oracle    1902  0.0  0.9 333284 9940 ?       S    04:47   0:00 ora_cjq0_db2
oracle    1904  0.4  1.5 333376 16108 ?      S    04:47   0:01 ora_qmn0_db2
oracle    1906  0.0  0.6 333860 6212 ?       S    04:47   0:00 ora_s000_db2
oracle    1908  0.0  0.6 333732 6576 ?       S    04:47   0:00 ora_d000_db2

database instance created upon install by dbca

need do export ORACLE_SID=db2
ORACLE_HOME already properly set

[joe@www oracle]$ sqlplus sys/sys

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Jan 6 04:59:11 2003

ERROR: ORA-28009: connection to sys should be as sysdba or sysoper

??????????
remember there are locked accounts after dbca is done, but scott/tiger will
work

sqlplus

Enter user-name: scott
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning and OLAP options
JServer Release 9.2.0.1.0 - Production

SQL> connect sys/sys as sysdba
Connected.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>
SQL> desc dba_col_privs;
Name Null? Type

 GRANTEE                                   NOT NULL VARCHAR2(30)
 OWNER                                     NOT NULL VARCHAR2(30)
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 COLUMN_NAME                               NOT NULL VARCHAR2(30)
 GRANTOR                                   NOT NULL VARCHAR2(30)
 PRIVILEGE                                 NOT NULL VARCHAR2(40)
 GRANTABLE                                          VARCHAR2(3)

SQL>shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 235999352 bytes

Fixed Size                   450680 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes

Database mounted.

Database opened.
SQL>

tail -2 /etc/oratab
#db2:/home/u01:N
db2:/home/u01:Y

[oracle@www oracle]$ dbstart
Database "db2" already started.

Database "db2" possibly left running when system went down (system crash?).
Notify Database Administrator.

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Jan 6 05:26:30 2003

SQL> Connected.
SQL> ORACLE instance shut down.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
With the Partitioning and OLAP options
JServer Release 9.2.0.1.0 - Production

Can't find init file for Database "db2".
Database "db2" NOT started.
[oracle@www oracle]$

[oracle@www oracle]$ dbshut

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Jan 6 05:28:23 2003

SQL> Connected to an idle instance.
SQL> ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> Disconnected
Database "db2" shut down.
[oracle@www oracle]$
-----------------------back to window running sqlplus-------------------
SQL> desc v$parameter;
ERROR:
ORA-12571: TNS:packet writer failure
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
??????????????????????????????//
----------------------back to command prompt window-----------------
[oracle@www oracle]$ dbstart

Can't find init file for Database "db2".
Database "db2" NOT started.
[oracle@www dbs]$ cat ../bin/dbstart | grep PFILE

            PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora
                if [ -f $PFILE ] ; then

[oracle@www dbs]$
[oracle@www dbs]$ ls
initdw.ora lkDB lkNEWDB lkSMALL orapwdb2 spfiledb2.ora
spfilesmall.ora
init.ora lkDB2 lkORCL orapwdb orapwsmall spfiledb.ora
[oracle@www dbs]$ cp init.ora initdb2.ora
[oracle@www dbs]$ cat initdb2.ora | grep DEFAULT
# replace DEFAULT with your database name
db_name=DEFAULT
[oracle@www dbs]$ vi initdb2.ora
[oracle@www dbs]$ cat initdb2.ora | grep DEFAULT
# replace DEFAULT with your database name
[oracle@www dbs]$ dbstart

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Jan 6 05:37:57 2003

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area	235999352 bytes
Fixed Size	450680 bytes
Variable Size	201326592 bytes
Database Buffers	33554432 bytes
Redo Buffers	667648 bytes

Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
With the Partitioning and OLAP options
JServer Release 9.2.0.1.0 - Production

Database "db2" warm started.
[oracle@www dbs]$
[oracle@www dbs]$ cat /etc/oratab | grep db2
#db2:/home/u01:N
db2:/home/u01:Y
[oracle@www dbs]$ ps -aux
<snip>

oracle    2518  0.0  0.7 333876 7580 ?       S    05:37   0:00 ora_pmon_db2
oracle    2520  0.0  0.8 335192 9024 ?       S    05:37   0:00 ora_dbw0_db2
oracle    2522  0.0  0.7 338240 7832 ?       S    05:37   0:00 ora_lgwr_db2
oracle    2524  0.0  0.6 333296 7156 ?       S    05:37   0:00 ora_ckpt_db2
oracle    2526  0.2  2.0 333304 21188 ?      S    05:37   0:00 ora_smon_db2
oracle    2528  0.0  0.9 333284 9796 ?       S    05:37   0:00 ora_reco_db2
oracle    2530  0.0  0.9 333284 9996 ?       S    05:37   0:00 ora_cjq0_db2
oracle    2532  0.8  1.5 333376 15848 ?      S    05:37   0:00 ora_qmn0_db2
oracle    2534  0.0  0.6 333864 6212 ?       S    05:37   0:00 ora_s000_db2
oracle    2536  0.0  0.6 333740 6588 ?       S    05:37   0:00 ora_d000_db2

oracle 2541 0.0 0.0 2860 872 pts/3 R 05:39 0:00 ps -aux

that's enough for today. Tomorrow, it's installing (first attempt) forms

Note: because I elected to create a spfile when I created my database, init.ora did not exist. an alternative method of creating it is exeecuting from inside sqlplus SQL> create pfile='path/filename' from spfile='path/filename' SQL> connect / as sysdba SQL> startup pfile='path/filename'

Leave a Reply

Comments:

The author will be notified of your reply.

return to top