OraFAQ Forum: Server Administration » Starting up Database

Home » RDBMS Server » Server Administration » Starting up Database (oracle,11.2.0,Red hat linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Starting up Database [message #512473]

Mon, 20 June 2011 10:10

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

im new to DBA...
i installed oracle on my pc but im not able to startup database
im manually creating database ..CRD files r still not created as im unable to startup nomount
im geeting this error...pls help

SQL> startup nomount
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

pls help guys...i almost worked on this for 10 days but im getting the same error...

Report message to a moderator

Re: Starting up Database [message #512480 is a reply to message #512473]

Mon, 20 June 2011 10:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

24323, 00000, "value not allowed"
// *Cause:  A null value or a bogus value was passed in for a mandatory
//          parameter.
// *Action: Verify that all mandatory parameters are properly initialized.

additional clues should exist within alert_SID.log file

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Starting up Database [message #512481 is a reply to message #512480]

Mon, 20 June 2011 11:11

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

will u please specify the mandatory parameters...
does this solve my problem because there r another two errors...

Report message to a moderator

Re: Starting up Database [message #512482 is a reply to message #512481]

Mon, 20 June 2011 11:15

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Have you looked in the alert log?

Report message to a moderator

Re: Starting up Database [message #512483 is a reply to message #512482]

Mon, 20 June 2011 11:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>will u please specify the mandatory parameters...
u is not a forum member

>does this solve my problem because there r another two errors...
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Starting up Database [message #512489 is a reply to message #512482]

Mon, 20 June 2011 12:32

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

ya i saw the alert log file...this is some part of the file...

/////starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oraeng/app/oracle
Mon Jun 20 22:24:24 2011
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x68747541] [PC:0x25D35E, {empty}] [flags: 0x0, count: 1]
Errors in file /oraeng/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_3224.trc (incident=3753):
ORA-07445: exception encountered: core dump [PC:0x25D35E] [SIGSEGV] [ADDR:0x68747541] [PC:0x25D35E] [Address not mapped to object] []
Incident details in: /oraeng/app/oracle/diag/rdbms/orcl/ORCL/incident/incdir_3753/ORCL_ora_3224_i3753.trc
Trace dumping is performing id=[cdmp_20110620222426]
Mon Jun 20 22:25:26 2011
Sweep [inc][3753]: completed
Sweep [inc2][3753]: completed////

Report message to a moderator

Re: Starting up Database [message #512492 is a reply to message #512489]

Mon, 20 June 2011 12:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

consider using dbca utility to CREATE DATABASE since it appears you are facing significant challenges to complete manual creation.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Starting up Database [message #512493 is a reply to message #512492]

Mon, 20 June 2011 12:45

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

[quote title=BlackSwan wrote on Mon, 20 June 2011 12:40]ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

consider using dbca utility to CREATE DATABASE since it appears you are facing significant challenges to complete manual creation.

is there no other way because im not customer of oracle products
i just dnd nd installed it..
i got the same problem when i installed oracle using dbca
wat could be the reason

Report message to a moderator

Re: Starting up Database [message #512496 is a reply to message #512493]

Mon, 20 June 2011 12:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i got the same problem when i installed oracle using dbca
>wat could be the reason
Problem Exists Between Keyboard And Chair.

http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=
thousands upon thousands of folks have read & followed Installation Guide to successfully install Oracle RDBMS.
I suggest you try doing the same.

Report message to a moderator

Re: Starting up Database [message #512497 is a reply to message #512489]

Mon, 20 June 2011 12:51

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

now im getting this error..

[oracle@host ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 20 22:53:29 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup nomount
ORA-01031: insufficient privileges
SQL>

Report message to a moderator

Re: Starting up Database [message #512498 is a reply to message #512493]

Mon, 20 June 2011 12:53

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

i just dnd nd installed it..
i got the same problem when i installed oracle using dbca
wat could be the reason

Maybe the letters that are missing on your keyboard?

Regards
Michel

Report message to a moderator

Re: Starting up Database [message #512499 is a reply to message #512497]

Mon, 20 June 2011 12:55

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

why everyone is making fun yaar is there anyone to help me..

Report message to a moderator

Re: Starting up Database [message #512500 is a reply to message #512499]

Mon, 20 June 2011 12:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post results from below

env | sort

Report message to a moderator

Re: Starting up Database [message #512501 is a reply to message #512499]

Mon, 20 June 2011 12:58

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe when you start to write correctly.
You write funnily, <e answer funnily...

By the way the answer was given:

Quote:

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.

Regards
Michel

Report message to a moderator

Re: Starting up Database [message #512502 is a reply to message #512496]

Mon, 20 June 2011 12:58

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

BlackSwan wrote on Mon, 20 June 2011 12:49

>i got the same problem when i installed oracle using dbca
>wat could be the reason
Problem Exists Between Keyboard And Chair.

http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=
thousands upon thousands of folks have read & followed Installation Guide to successfully install Oracle RDBMS.
I suggest you try doing the same.

i read many docs...incl this one im really fed up with this
because i followed each nd every step still im facing this problem...

Report message to a moderator

Re: Starting up Database [message #512503 is a reply to message #512502]

Mon, 20 June 2011 13:00

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Still a problem with your keyboard.

Regards
Michel

Report message to a moderator

Re: Starting up Database [message #512504 is a reply to message #512500]

Mon, 20 June 2011 13:23

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

_=/bin/env
COLORTERM=
CVS_RSH=ssh
DESKTOP_SESSION=default
DISPLAY=:0
G_BROKEN_FILENAMES=1
GDMSESSION=default
GDM_XSERVER_LOCATION=local
GS_LIB=/root/.fonts
GTK2_RC_FILES=/etc/gtk-2.0/gtkrc:/root/.gtkrc-2.0:/root/.kde/share/config/gtkrc-
2.0
GTK_RC_FILES=/etc/gtk/gtkrc:/root/.gtkrc:/root/.kde/share/config/gtkrc
HISTSIZE=1000
HOME=/root
HOSTNAME=host.owner
INPUTRC=/etc/inputrc
KDEDIR=/usr
KDE_FULL_SESSION=true
KDE_IS_PRELINKED=1
KDE_MULTIHEAD=false
KDE_NO_IPV6=1
KONSOLE_DCOP=DCOPRef(konsole-2894,konsole)
KONSOLE_DCOP_SESSION=DCOPRef(konsole-2894,session-2)
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=root
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;0
1:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b
tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31: *.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:* .bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;3 5:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/root
PATH=/usr/lib/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/u sr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
PWD=/root
QTDIR=/usr/lib/qt-3.3
QTINC=/usr/lib/qt-3.3/include
QTLIB=/usr/lib/qt-3.3/lib
SESSION_MANAGER=local/host.owner:/tmp/.ICE-unix/2878
SHELL=/bin/bash
SHLVL=3
SSH_AGENT_PID=2782
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_AUTH_SOCK=/tmp/ssh-zqFhtl2749/agent.2749
TERM=xterm
USER=root
WINDOWID=12582919
XAUTHORITY=/tmp/.gdm97QUWV
XCURSOR_THEME=default
XDG_CONFIG_DIRS=/etc/kde/xdg:/etc/xdg

Report message to a moderator

Re: Starting up Database [message #512505 is a reply to message #512504]

Mon, 20 June 2011 13:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails Read The Fine Manual
http://download.oracle.com/docs/cd/E11882_01/install.112/e16766/toc.htm#CEGEGDBA

Report message to a moderator

Re: Starting up Database [message #512506 is a reply to message #512473]

Mon, 20 June 2011 13:33

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

COLORTERM=
CVS_RSH=ssh
DESKTOP_SESSION=default
DISPLAY=:0
G_BROKEN_FILENAMES=1
GDMSESSION=default
GDM_XSERVER_LOCATION=local
GS_LIB=/oraeng/app/oracle/product/11.2.0/.fonts
HISTSIZE=1000
HOME=/oraeng/app/oracle/product/11.2.0
HOSTNAME=host.owner
INPUTRC=/etc/inputrc
KDEDIR=/usr
KDE_FULL_SESSION=true
KDE_IS_PRELINKED=1
KDE_MULTIHEAD=false
KDE_NO_IPV6=1
KONSOLE_DCOP=DCOPRef(konsole-2888,konsole)
KONSOLE_DCOP_SESSION=DCOPRef(konsole-2888,session-1)
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
ORACLE_BASE=/oraeng/app/oracle
ORACLE_HOME=/oraeng/app/oracle/product/11.2.0
ORACLE_SID=ORCL
PATH=/oraeng/app/oracle/product/11.2.0/bin:/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:.
PWD=/oraeng/app/oracle/product/11.2.0
QTDIR=/usr/lib/qt-3.3
QTINC=/usr/lib/qt-3.3/include
QTLIB=/usr/lib/qt-3.3/lib
SESSION_MANAGER=local/host.owner:/tmp/.ICE-unix/2867
SHELL=/bin/bash
SHLVL=3
SSH_AGENT_PID=2770
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_AUTH_SOCK=/tmp/ssh-geMgQX2737/agent.2737
TERM=xterm
USERNAME=oracle
USER=oracle
_=/usr/bin/env
WINDOWID=14680071
XAUTHORITY=/tmp/.gdmA732WV
XDG_CONFIG_DIRS=/etc/kde/xdg:/etc/xdg

Report message to a moderator

Re: Starting up Database [message #512507 is a reply to message #512505]

Mon, 20 June 2011 13:41

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

BlackSwan wrote on Mon, 20 June 2011 13:26

when all else fails Read The Fine Manual
http://download.oracle.com/docs/cd/E11882_01/install.112/e16766/toc.htm#CEGEGDBA

difinetly i wil read..
before that see my above post
thats the o/p of env | sort u said to post..

Report message to a moderator

Re: Starting up Database [message #512508 is a reply to message #512507]

Mon, 20 June 2011 13:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

does xclock work for you?

Report message to a moderator

Re: Starting up Database [message #512509 is a reply to message #512508]

Mon, 20 June 2011 14:02

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

ya it worked for me but wats the use of it...

Report message to a moderator

Re: Starting up Database [message #512510 is a reply to message #512509]

Mon, 20 June 2011 14:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ya it worked for me but wats the use of it...
when xclock works OK, the X-Windows is functional.
X-Windows is required by dbca

now as OS user "oracle" invoke dbca to create DB

Report message to a moderator

Re: Starting up Database [message #512511 is a reply to message #512509]

Mon, 20 June 2011 14:14

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 20 June 2011 20:00

Still a problem with your keyboard.

Regards
Michel

Report message to a moderator

Re: Starting up Database [message #512512 is a reply to message #512510]

Mon, 20 June 2011 14:15

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

i already installed the software...
why i need to install it again..

Report message to a moderator

Re: Starting up Database [message #512513 is a reply to message #512510]

Mon, 20 June 2011 14:35

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

what is X-windows..
wat should i do i already created DB manually..
should i uninstall and install DB using dbca..
wat makes dbca work for me...
dont take it otherwise..i really want to know before i install it again

Report message to a moderator

Re: Starting up Database [message #512514 is a reply to message #512513]

Mon, 20 June 2011 14:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ls -ltr /oraeng/app/oracle/product/11.2.0/dbs
post FORMATTED results like below

bcm@bcm-laptop:~$ ls -ltr $OH/dbs
total 9708
-rw-r--r-- 1 oracle dba    2851 2009-05-15 14:35 init.ora
-rw-r----- 1 oracle dba      24 2010-05-07 11:17 lkV112
-rw-r----- 1 oracle dba 9912320 2010-05-20 18:33 snapcf_v112.f
-rw-rw---- 1 oracle dba    1544 2010-06-09 08:31 hc_DBUA0.dat
-rw-r----- 1 oracle dba    2048 2011-03-12 12:03 orapwv112
-rw-r--r-- 1 oracle dba    1075 2011-04-20 09:35 initv112.ora
-rw-r----- 1 oracle dba    3584 2011-06-20 06:23 spfilev112.ora
-rw-rw---- 1 oracle dba    1544 2011-06-20 06:23 hc_v112.dat
bcm@bcm-laptop:~$

Report message to a moderator

Re: Starting up Database [message #512515 is a reply to message #512514]

Mon, 20 June 2011 14:50

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

[oracle@host ~]$ ls -lrt /oraeng/app/oracle/product/11.2.0/dbs
total 16
-rwxrwxr-x 1 oracle oinstall 2851 May 15 2009 init.ora
drwx------ 2 oracle oinstall 4096 Jun 20 19:09 peshm_ORCL_0
-rw-rw---- 1 oracle oinstall 1544 Jun 20 19:11 hc_ORCL.dat
-rwxrwxr-x 1 oracle oinstall 3128 Jun 20 22:34 initORCL.ora
[oracle@host ~]$

Report message to a moderator

Re: Starting up Database [message #512517 is a reply to message #512515]

Mon, 20 June 2011 14:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

cat /oraeng/app/oracle/product/11.2.0/dbs/initORCL.ora
diff /oraeng/app/oracle/product/11.2.0/dbs/initORCL.ora /oraeng/app/oracle/product/11.2.0/dbs/init.ora

post results from two OS commands above using COPY & PASTE

Report message to a moderator

Re: Starting up Database [message #512519 is a reply to message #512517]

Mon, 20 June 2011 15:10

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

$Header: rdbms/admin/init.ora /main/23 2009/05/15 13:35:38 ysarig Exp $
#
# Copyright (c) 1991, 1997, 1998 by Oracle Corporation
# NAME
# init.ora
# FUNCTION
# NOTES
# MODIFIED
# ysarig 05/14/09 - Updating compatible to 11.2
# ysarig 08/13/07 - Fixing the sample for 11g
# atsukerm 08/06/98 - fix for 8.1.
# hpiao 06/05/97 - fix for 803
# glavash 05/12/97 - add oracle_trace_enable comment
# hpiao 04/22/97 - remove ifile=, events=, etc.
# alingelb 09/19/94 - remove vms-specific stuff
# dpawson 07/07/93 - add more comments regarded archive start
# maporter 10/29/92 - Add vms_sga_use_gblpagfile=TRUE
# jloaiza 03/07/92 - change ALPHA to BETA
# danderso 02/26/92 - change db_block_cache_protect to _db_block_cache_p
# ghallmar 02/03/92 - db_directory -> db_domain
# maporter 01/12/92 - merge changes from branch 1.8.308.1
# maporter 12/21/91 - bug 76493: Add control_files parameter
# wbridge 12/03/91 - use of %c in archive format is discouraged
# ghallmar 12/02/91 - add global_names=true, db_directory=us.acme.com
# thayes 11/27/91 - Change default for cache_clone
# jloaiza 08/13/91 - merge changes from branch 1.7.100.1
# jloaiza 07/31/91 - add debug stuff
# rlim 04/29/91 - removal of char_is_varchar2
# Bridge 03/12/91 - log_allocation no longer exists
# Wijaya 02/05/91 - remove obsolete parameters
#
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you start by providing
# a starting point to customize your RDBMS installation for your site.
#
# NOTE: The values that are used in this file are only intended to be used
# as a starting point. You may want to adjust/tune those values to your
# specific hardware and needs. You may also consider using Database
# Configuration Assistant tool (DBCA) to create INIT file and to size your
# initial set of tablespaces based on the user input.
###############################################################################

# Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
# install time)

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='/oraeng/app/oracle/admin/orcl/adump'
background_dump_dest='/oraeng/app/oracle/admin/orcl/bdump'
core_dump_dest='/oraeng/app/oracle/admin/orcl/cdump'
timed_statistics=TRUE
user_dump_dest='/oraeng/app/oracle/admin/orcl/udump'
audit_trail ='db'
db_block_size=8192
db_domain=''
java_pool_size=335544
large_pool_size=10485
shared_pool_size=335544
db_recovery_file_dest='/oraeng/app/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/oraeng/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = ("/disk1/oradata/ORCL/control.ctl")
compatible ='11.2.0'

Report message to a moderator

Re: Starting up Database [message #512520 is a reply to message #512517]

Mon, 20 June 2011 15:11

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

diff........

/app/oracle/product/11.2.0/dbs/init.ora
52,56c52
< audit_file_dest='/oraeng/app/oracle/admin/orcl/adump'
< background_dump_dest='/oraeng/app/oracle/admin/orcl/bdump'
< core_dump_dest='/oraeng/app/oracle/admin/orcl/cdump'
< timed_statistics=TRUE
< user_dump_dest='/oraeng/app/oracle/admin/orcl/udump'
---
> audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
60,63c56
< java_pool_size=335544
< large_pool_size=10485
< shared_pool_size=335544
< db_recovery_file_dest='/oraeng/app/oracle/flash_recovery_area'
---
> db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'
65c58
< diagnostic_dest='/oraeng/app/oracle'
---
> diagnostic_dest='<ORACLE_BASE>'
72c65
< control_files = ("/disk1/oradata/ORCL/control.ctl")
---
> control_files = (ora_control1, ora_control2)
[oracle@host ~]$

Report message to a moderator

Re: Starting up Database [message #512527 is a reply to message #512520]

Mon, 20 June 2011 17:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> control_files = (ora_control1, ora_control2)
line above is obviously incorrect & needs to be changed/fixed.

Report message to a moderator

Re: Starting up Database [message #512577 is a reply to message #512527]

Tue, 21 June 2011 01:16

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

< control_files = ("/disk1/oradata/ORCL/control.ctl")
---
> control_files = (ora_control1, ora_control2)

1st one is init.ora file and 2nd one is initORCL.ora file...
i think we should not change the init.ora file

sory for late reply i thought u left..

Report message to a moderator

Re: Starting up Database [message #512579 is a reply to message #512577]

Tue, 21 June 2011 01:18

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 20 June 2011 21:14
Michel Cadot wrote on Mon, 20 June 2011 20:00
Still a problem with your keyboard.

Regards
Michel

[Updated on: Tue, 21 June 2011 01:19]

Report message to a moderator

Re: Starting up Database [message #512690 is a reply to message #512527]

Tue, 21 June 2011 09:09

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

what happened please correct my mistakes
what is it to change the control parameters...

Report message to a moderator

Re: Starting up Database [message #512691 is a reply to message #512690]

Tue, 21 June 2011 09:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

where do CONTROL FILES for instance ORCL reside?
we don't know this & only you can answer.

Report message to a moderator

Re: Starting up Database [message #512693 is a reply to message #512691]

Tue, 21 June 2011 09:19

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

/disk1/oradata/ORCL/control.ctl

this is the control file path..

Report message to a moderator

Re: Starting up Database [message #512697 is a reply to message #512693]

Tue, 21 June 2011 09:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>/disk1/oradata/ORCL/control.ctl
>this is the control file path..

then that needs to exist correctly inside initORCL.ora file

is control file not multiplexed?

Report message to a moderator

Re: Starting up Database [message #512698 is a reply to message #512697]

Tue, 21 June 2011 09:37

srihas
Messages: 26
Registered: June 2011
Location: hyderabad

Junior Member

ya i hav given the correct path...i also posted initORCL.ora file in message #512519
wat do u mean by multiplexing...i hav given only 1 control file path..

Report message to a moderator

Re: Starting up Database [message #512703 is a reply to message #512698]

Tue, 21 June 2011 10:06

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Tue, 21 June 2011 08:18

Michel Cadot wrote on Mon, 20 June 2011 21:14
Michel Cadot wrote on Mon, 20 June 2011 20:00
Still a problem with your keyboard.

Regards
Michel

Report message to a moderator

Pages (2): [1 2 › »]

Previous Topic:	Database Server Startup/Shutdown
Next Topic:	kkjcre1p: unable to spawn jobq slave process

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 15:16:09 CST 2025