IMP - 00058

[fbarros300472]

Environment information:
* Oracle version: 10 g
* Operating system: Red Hat 4

Good evening guys! I created a database and when I try to import a .dmp file gives the following message:

Select all

IMP - 00058 : ORACLE error 12170 encountered 
ORA - 12170 : TNS: Connect timeout occurred

Thanks in advance.

[ruevers]

If you try to connect using SQLPLUS works?

[fbarros300472]

Yes, with SQLPlus is normal, I even access through the PLSQL, from another machine. This bank is installed in a VM.

[ruevers]

Then the table should be large is not even ....

tries to increase this parenter SQLNET.INBOUND_CONNECT_TIMEOUT
in sqlnet.ora

99] and increase buffer in import ...

[fbarros300472]

I increased, but it continues with the same error .....

[fbarros300472]

I managed to solve the error. What happens now is that when I call on all tables the log goes out like this:

Select all

"CREATE UNIQUE INDEX "PKAJORHOR" ON "AJORHOR" ("CODCOLIGADA" , "CODHORARIO" " 
 ", "INDINICIO" , "BATINICIO" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(I" 
 "NITIAL 131072 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE" 
 " "RM_INDICES" LOGGING" 
 "ALTER TABLE "AJORHOR" ADD CHECK (CODCOLIGADA >= 0) ENABLE" 
 "ALTER TABLE "AJORHOR" ADD  CONSTRAINT "PKAJORHOR" PRIMARY KEY ("CODCOLIGADA" 
 "", "CODHORARIO", "INDINICIO", "BATINICIO") USING INDEX PCTFREE 10 INITRANS " 
 "2 MAXTRANS 255 STORAGE(INITIAL 131072 FREELISTS 1 FREELIST GROUPS 1 BUFFER_" 
 "POOL DEFAULT) TABLESPACE "RM_INDICES" LOGGING ENABLE " 
 "CREATE TABLE "AJORNADAFUN" ("CODCOLIGADA" NUMBER(5, 0) NOT NULL ENABLE, "CH" 
 "APA" VARCHAR2(16) NOT NULL ENABLE, "DATAMUDANCA" DATE NOT NULL ENABLE, "JOR" 
 "NADA" NUMBER(10, 0), "INTREFEICAO" NUMBER(10, 0), "NUMPARBAT" NUMBER(5, 0))" 
 "  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREEL" 
 "ISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "RM_DADOS" LOGGING" 
 " NOCOMPRESS" 
. . skipping table "AJORNADAFUN"         

Would anyone tell me how to solve this?

Thanks.