Home » RDBMS Server » Networking and Gateways » ORA-12545 problem and the Database Configuration Assistant? (10.2.0.1.0, Windows 2k3 Server)
ORA-12545 problem and the Database Configuration Assistant? [message #410218] Thu, 25 June 2009 13:28 Go to next message
fgmetz
Messages: 3
Registered: June 2009
Junior Member
hello everyone

I am an oracle newbie running into a problem with starting my oracle databases. I am running Oracle 10 on a Windows 2k3 server. When the machine first boots up, if I try to connect to the database (either locally or on a remote machine) via sqlplus, I get the error message ORA-12545: Connect failed because target host or object does not exist, and am then prompted to enter my user name. However, if I merely go to the Database Configuration Assistant -> Configure database options, then select a database, once the first screen of options are displayed within the wizard, I am able to sqlplus in as expected.

The windows service for the TNS listener and the database service itself are both started before I first try to connect. Also, if I have multiple databases on this server, and I connect via the Database Configuration Assistant to one of them, that database is functional, but the other databases are not. It almost seems like the assistant is starting the databases

Does anyone have any recommendation as to what I can look into? Or what commands might be executed at this point for the database configuration assistant to enable connectivity?

As an additional piece of information, I am running the Windows 2k3 server on a VMWare image, using a bridged connection

thanks
Re: ORA-12545 problem and the Database Configuration Assistant? [message #410219 is a reply to message #410218] Thu, 25 June 2009 13:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> via sqlplus
Which flavor of sqlplus; windows interface which requires SQL*Net or command line which does not?

12545, 00000, "Connect failed because target host or object does not exist"
// *Cause: The address specified is not valid, or the program being 
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly; the
// most likely incorrect parameter is the node name.  Ensure that the 
// executable for the server exists (perhaps "oracle" is missing.)
// If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
// host name to a numeric IP address and try again.


Do you have simply a race condition?
Are you attempting to login before all the necessary s/w has been properly started?

After reboot, if you just wait 3 - 5 minutes is everything OK?
Re: ORA-12545 problem and the Database Configuration Assistant? [message #410228 is a reply to message #410219] Thu, 25 June 2009 14:30 Go to previous messageGo to next message
fgmetz
Messages: 3
Registered: June 2009
Junior Member
I see similar behavior both via the command line utility and the windos utility (although I get a different message when running sqlplusw.exe I get 'ORA-12170 - connection timeout'

I have tried rebooting the machine and waiting 10 minutes before attempting to connect, and get the same behavior. I also can, if accessed through the DCA, connect to the dB quite quickly.

In terms of what else can be started, the oracle database services OracleService<SID>, along with the listener, are set to automatic and started. Is there anything else I can look for?
Re: ORA-12545 problem and the Database Configuration Assistant? [message #410232 is a reply to message #410218] Thu, 25 June 2009 14:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What clues exist with alertSID.log & listener.log files?
Try to create an overall timeline between what happens when at the OS level & with the various Oracle components.

What changes & when that make everything work OK?
Re: ORA-12545 problem and the Database Configuration Assistant? [message #410243 is a reply to message #410218] Thu, 25 June 2009 15:41 Go to previous messageGo to next message
fgmetz
Messages: 3
Registered: June 2009
Junior Member
I think these logs (and your most gracious assistance) are leading me down the correct path

* I stopped all services, and deleted the two logs (alert-SID.log and listener.log)

* I restarted the machine and verify that the services for the SID and the listener are running
-alert-SID.log is not created, listener.log is created with nothing looking interesting

* I attempt to connect via SQLplus
- I get the error message from above, and the following is inserted into listener.log. alert-SID.log is not yet created
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
25-JUN-2009 15:33:37 * (CONNECT_DATA=(SERVICE_NAME=dpn22)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=FGMETZ-OR10)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.192.1)(PORT=1028)) * establish * dpn22 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
25-JUN-2009 15:33:37 * (CONNECT_DATA=(SERVICE_NAME=dpn22)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=FGMETZ-OR10)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.109)(PORT=1029)) * establish * dpn22 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor


* I launch the DCA wizard
- no entries to listener.log, alert-SID.log is not yet created

* I select the SID of interest to configure database options, and wait (a lengthy time, a minute or so) while information is retrieved, until the first page of options are available
- the following updates are made to listener.log
25-JUN-2009 15:39:53 * service_register * dpn22 * 0
25-JUN-2009 15:39:59 * service_update * dpn22 * 0
25-JUN-2009 15:40:02 * service_update * dpn22 * 0
25-JUN-2009 15:40:11 * service_update * dpn22 * 0
25-JUN-2009 15:40:38 * service_update * dpn22 * 0


- alert-SID.log is created. The following entries are added
Dump file c:\oracle/admin/dpn22/bdump\alert_dpn22.log
Thu Jun 25 15:39:46 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 1
CPU                 : 1 - type 586, 1 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:527M/767M, Ph+PgF:1300M/1498M, VA:1940M/2047M
Thu Jun 25 15:39:46 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\oracle\product\10.2.0\db_1\RDBMS
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 79691776
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 167772160
  control_files            = C:\ORACLE\ORADATA\DPN22\CONTROL01.CTL
  db_block_size            = 8192
  __db_cache_size          = 75497472
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  job_queue_processes      = 10
  cursor_sharing           = SIMILAR
  audit_file_dest          = C:\ORACLE\ADMIN\DPN22\ADUMP
  background_dump_dest     = C:\ORACLE\ADMIN\DPN22\BDUMP
  user_dump_dest           = C:\ORACLE\ADMIN\DPN22\UDUMP
  core_dump_dest           = C:\ORACLE\ADMIN\DPN22\CDUMP
  db_name                  = dpn22
  open_cursors             = 300
  optimizer_mode           = FIRST_ROWS_100
  pga_aggregate_target     = 33554432
PMON started with pid=2, OS id=1492
MMAN started with pid=4, OS id=668
PSP0 started with pid=3, OS id=180
DBW0 started with pid=5, OS id=944
LGWR started with pid=6, OS id=2056
CKPT started with pid=7, OS id=656
SMON started with pid=8, OS id=628
RECO started with pid=9, OS id=976
CJQ0 started with pid=10, OS id=660
MMON started with pid=11, OS id=1452
MMNL started with pid=12, OS id=1572
Thu Jun 25 15:39:51 2009
Oracle Data Guard is not available in this edition of Oracle.
Thu Jun 25 15:39:52 2009
ALTER DATABASE   MOUNT
Thu Jun 25 15:39:57 2009
Setting recovery target incarnation to 1
Thu Jun 25 15:39:57 2009
Successful mount of redo thread 1, with mount id 3280217672
Thu Jun 25 15:39:57 2009
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Thu Jun 25 15:39:57 2009
ALTER DATABASE OPEN
Thu Jun 25 15:39:58 2009
Thread 1 opened at log sequence 15
  Current log# 3 seq# 15 mem# 0: C:\ORACLE\ORADATA\DPN22\REDO03_A.LOG
Successful open of redo thread 1
Thu Jun 25 15:39:58 2009
SMON: enabling cache recovery
Thu Jun 25 15:40:00 2009
Successfully onlined Undo Tablespace 1.
Thu Jun 25 15:40:00 2009
SMON: enabling tx recovery
Thu Jun 25 15:40:01 2009
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=14, OS id=1652
Thu Jun 25 15:40:08 2009
Completed: ALTER DATABASE OPEN


At this point, my database is functional.

I have noticed that the ALTER DATABASE MOUNT and ALTER DATABASE OPEN commands are being applied here. I would think that would happen when the service starts up, no? Might this be improperly configured? I am an extreme novice when it comes to any oracle administration, so I may have done something foolish in the installation. However, the database creation scripts for this database are known to work properly, so it is something local here

Any ideas what might be going on?

Oh, and thank you very much for taking time out to help
Re: ORA-12545 problem and the Database Configuration Assistant? [message #410244 is a reply to message #410218] Thu, 25 June 2009 16:59 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Any ideas what might be going on?
I plead ignorance.
I have steadfastly avoided running Oracle on Windoze.
I don't really know the details how to get Oracle DB going after boot on Windoze.
One possibility is that you search the whole disk for a file by the name of "oratab".
If one exists, post the contents back here.

Hopefully, somebody who knows Windows can solve this riddle for you
Previous Topic: Listener Doubts
Next Topic: ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Thu Mar 28 08:54:39 CDT 2024