Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

Windows autostart problem

Joe

2005-05-25

Replies:
Hi all,

I am having a problem with a 10.1.0.3 database not automatically
starting up when a box is rebooted. The machine is Windows 2003. There
is an old ORACLE_HOME on this box, not sure if that is an issue.

In addition to it not starting, it will not start with the correct
init file. The init file I want to use is
N:\oracle\database\initorcl.ora - but the database doesn't use it
unless I do a "startup pfile=3D" to point to it explicitly.

I also believe I was getting a similar error to Jared's recent post,
where it is referencing a pfile in a completely different directory
(not sure as it was 4:00am last time this box was rebooted, and was an
emergency).

Thanks very much for any help (as I am highly Windows-challenged),

Joe

=3D=3D=3D=3D
More details:

from "set" at cmd prompt:

ORACLE_HOME=3DN:\ORACLE
LD_LIBRARY_PATH=3DN:\ORACLE\LIB
Path=3DN:\oracle\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files=
\Oracle
\jre\1.1.8\bin;N:\oracle\bin;N:\oracle\jre\1.4.2\bin\client;N:\oracle\jre\1=
.4.2\
bin;C:\Program Files\VERITAS\NetBackup\bin\;C:\Program Files\Windows Resour=
ce Ki
ts\Tools\;C:\Program Files\Support Tools\;C:\WINNT\system32;C:\WINNT;C:\WIN=
NT\Sy
stem32\Wbem;C:\cygwin\bin;C:\Program Files\Quest Software\Foglight Client\c=
onfig
\weblogic\Windows2003\bin;;


SQL> show parameter pfile

NAME                      TYPE     VALUE
------------------------------------ ----------- --------------------------=
----
spfile                     string

SQL> show parameter ifile

NAME                      TYPE     VALUE
------------------------------------ ----------- --------------------------=
----
ifile                     file


"OracleServiceorcl" Properties
  Path to executable: n:\oracle\bin\ORACLE.EXE orcl
  Startup type: Automatic
  Log On: Local system account


There is an old installation of Oracle under N:\Oracle9204 that is not
used. However, there are still references to this directory in the
registry. Here are the relevant registry settings under
HKEY_LOCAL_MACHINE\SOFTWARE:

ORACLE
 API =3D N:\oracle9204\dbs
 inst_loc =3D C:\Program Files\Oracle\Inventory
 ORA_CRS_HOME =3D N:\oracle
 ORACLE_GROUP_NAME =3D Oracle - OraDb9204_home2
 ORACLE_HOME =3D N:\oracle9204
 ORACLE_HOME_NAME =3D OraDb9204_home2

ORACLE\ALL_HOMES
 DEFAULT_HOME =3D OraDb9204_home2
 HOME_COUNTER =3D 1
 LAST_HOME =3D 0

ORACLE\ALL_HOMES\ID0
 NAME =3D OraDb9204_home2
 PATH =3D N:\oracle9204

ORACLE\HOME0
 ORA_orcl_AUTOSTART =3D FALSE
 ORA_orcl_SHUTDOWN =3D TRUE
 ORA_orcl_SHUTDOWN_TIMEOUT =3D 30
 ORA_orcl_SHUTDOWNTYPE =3D i
 ORACLE_BASE =3D N:\oracle9204
 ORACLE_GROUP_NAME =3D Oracle - OraDb9204_home2
 ORACLE_HOME =3D N:\oracle9204
 ORACLE_HOME_KEY =3D Software\Oracle\HOME0
 ORACLE_HOME_NAME =3D OraDb9204_home2
 RDBMS_ARCHIVE =3D N:\oracle9204\DATABASE\ARCHIVE
 RDBMS_CONTROL =3D N:\oracle9204\DATABASE
 SQLPATH =3D N:\oracle9204\dbs

Looks like the 10g registry stuff is in here:

ORACLE\Key_OraDb10g_home1
 ORA_orcl_AUTOSTART =3D TRUE
 ORA_orcl_SHUTDOWN =3D TRUE
 ORA_orcl_SHUTDOWN_TIMEOUT =3D 90
 ORA_orcl_SHUTDOWNTYPE =3D immediate
 ORACLE_BASE =3D N:
 ORACLE_GROUP_NAME =3D Oracle - OraDb10g_home1
 ORACLE_HOME =3D N:\oracle
 ORACLE_HOME_KEY =3D SOFTWARE\ORACLE\KEY_OraDb10g_home1
 ORACLE_HOME_NAME =3D OraDb10g_home1
 RDBMS_ARCHIVE =3D N:\oracle\DATABASE\ARCHIVE
 RDBMS_CONTROL =3D N:\oracle\DATABASE
 SQLPATH =3D N:\oracle\dbs
 USE_SHARED_SOCKET =3D true

The pfile is N:\oracle\database\initorcl.ora; contents are:

*._allow_level_without_connect_by=3Dtrue
*.background_dump_dest=3D'N:\oracle\admin\orcl\bdump'
*.compatible=3D'10.1.0.3.0'
*.control_files=3D'N:\oracle\oradata\orcl\control01.ctl'
*.core_dump_dest=3D'N:\oracle\admin\orcl\cdump'
*.db_block_size=3D8192
*.db_cache_size=3D335544320
*.db_domain=3D''
*.db_file_multiblock_read_count=3D16
*.db_name=3D'orcl'
*.db_writer_processes=3D1
*.fast_start_mttr_target=3D900
*.instance_name=3D'orcl'
*.java_pool_size=3D67108864
*.job_queue_processes=3D10
*.large_pool_size=3D8388608
*.max_dump_file_size=3D'UNLIMITED'
*.open_cursors=3D300
*.pga_aggregate_target=3D209715200
*.processes=3D150
*.query_rewrite_enabled=3D'FALSE'
*.remote_login_passwordfile=3D'EXCLUSIVE'
*.shared_pool_size=3D335544320
*.star_transformation_enabled=3D'FALSE'
*.timed_statistics=3DTRUE
*.undo_management=3D'AUTO'
*.undo_retention=3D10800
*.undo_tablespace=3D'undo'
*.user_dump_dest=3D'N:\oracle\admin\orcl\udump'
*.WORKAREA_SIZE_POLICY=3D'AUTO'
--
http://www.freelists.org/webpage/oracle-l