 | | | |  |  | | | Wed, Feb 15, 2006. NEED HELP with Oracle. | | Any uber DBA experts among us?
Read this shit below, and come back with any bright ideas please ) Problem seems pretty fucking standard, but i have been banging my head against it for a few days now, with no result.
Here is the problem:
-----------------------------------------------------------------------
I have been trying to install Oracle on a windows 2000 host in the lab, and installation went successfully. Problem is this:
I am trying to direct a piece of software called DBLoader to it, for Custom Reporting. It basically needs to connect to the database as a particular user, find its tablespace, and create a bunch of tables, based on dbloader's internal mirrors of STSXML files. I get this error:
====================================================================
INFO : Starting database operation at 2006:02:15 11:15:00
Error : Cannot connect to db or Invalid input. See user manual.
====================================================================
INFO : Starting database operation at 2006:02:15 11:15:00
INFO : File Opened :: schema.cfg
INFO : Create Table : CREATE TABLE STS_ACTIVE_ZONESET (SITE VARCHAR2(255),TIMESTAMP DATE,FB_ALIASNAME VARCHAR2(225),FB_ID VARCHAR2(225),FB_WWN VARCHAR2(225),MO_NAME VARCHAR2(225),MO_TYPE VARCHAR2(225),PORT_NUMBER NUMBER,SLOT_NUMBER NUMBER,ZONE_MEMBER VARCHAR2(225),ZONE_NAME VARCHAR2(225),ZONE_TYPE VARCHAR2(225),ZONESET_ID VARCHAR2(225),ZONESET_NAME VARCHAR2(225))
INFO : Connecting to database ...
ERROR : Connection Error: ORA-12154: TNS:could not resolve the connect identifier specified
Error : Connection Error.
ERROR : Unable to create table :STS_ACTIVE_ZONESET
------------
And it perceeds to get this same error for every table it is trying to create. So I can see it cannot connect to DB from message on top, and that it is trying to give specifics from message on bottom. |
| | | |
|
|
 | | |  |  |
 | |
|  |