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 |
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 #410228 is a reply to message #410219] |
Thu, 25 June 2009 14:30 |
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 #410243 is a reply to message #410218] |
Thu, 25 June 2009 15:41 |
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 |
|
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
|
|
|
Goto Forum:
Current Time: Wed Nov 13 06:02:33 CST 2024
|