| startup force [message #120671] |
Sun, 22 May 2005 09:12  |
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
|
Senior Member |
|
|
hii
when i open form builder or report builder or sql
i must make force to the database
i write in the console
c:\svrmgrl
connect internal/oracle@orasvr
startup force;
i hope to avoid this problem
i want to connect automatically without forceing the database
thx
|
|
|
|
| Re: startup force [message #120677 is a reply to message #120671] |
Sun, 22 May 2005 13:10  |
KumarD
Messages: 8
Registered: March 2005
Location: india
|
Junior Member |
|
|
Hi,
First tell on which O/S your database is there...
and tell me what error it is displaying exactly when you open form/reports when you startup the database normal...if possible send the error messages...if your intention is only to startup the database automatically when you reboot the system then you can do any of the following steps,if your database is on Windows O/S...
1) Navigate to Oracle_Home folder and locate Network folder in
that open admin folder...you will find SQLNET.ora file,open
the file and comment(#) SQL_AUTHENTICATION_SERVICE entry
and save it,once you done this your database will startup and
shutdown automatically when your shutdow/reboot/start the
system...
2) go to registry locate HKEY_LOCAL_MACHINE_SOFTWARE
find out a regitry key with Oracle_Home,check the entry for
followings
a) ora_<sid>_startup=true
b) ora_<sid>_shutdown=true
if you find this entries with value other then true then
make it has true or if you can't find the value then manually
add the entry in registry...
or
ora_<sid>_pfile is pointing towards your initparameterfile
regards
Dilip
|
|
|
|
| Re: startup force [message #120693 is a reply to message #120677] |
Mon, 23 May 2005 00:33 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
Startup force needs to be used with care.
For carrying out normal startup, simply typing startup will do.
Startup force is being used, when you want to refresh the already running database and facing issues like database showing errors while shutting down before starting up again.
Startup force actually, crashes the instance (just like shutdown abort) and then start your database normally. This do require instance level recovery.
As for starting ur database automatically... do follow the steps given by Kumar in case of windos environment. Not sure with step1, but step2 is definitely true.
If on unix environment follow this procedure:
Make sure the entry for your database SID in the ORATAB file ends in a capital "Y". Eg:
# $ORACLE_SID:$ORACLE_HOME:[N|Y]
#
ORCL:/u01/app/oracle/product/8.0.5:Y
#
The scripts for starting and stopping databases are: $ORACLE_HOME/bin/dbstart and dbshut. SQL*Net (or Net8) is started with the lsnrctl command. Add the following entries to your /etc/rc2.d/S99dbstart (or equivalent) file:
su - oracle -c "/path/to/$ORACLE_HOME/bin/dbstart" # Start DB's
su - oracle -c "/path/to/$ORACLE_HOME/bin/lsnrctl start" # Start listener
su - oracle -c "/path/tp/$ORACLE_HOME/bin/namesctl start" # Start OraNames (optional)
Regds
Girish
|
|
|
|
| Re: startup force [message #121452 is a reply to message #120671] |
Sun, 29 May 2005 16:41 |
mostafaora
Messages: 1
Registered: May 2005
Location: egypt
|
Junior Member |
|
|
| emadbsb wrote on Sun, 22 May 2005 10:12 |
hii
when i open form builder or report builder or sql
i must make force to the database
i write in the console
c:\svrmgrl
connect internal/oracle@orasvr
startup force;
i hope to avoid this problem
i want to connect automatically without forceing the database
thx
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
