After Installation of Ora2pg, didn't get /usr/local/ora2pg was not created. Not able to connect to oracle database. about ora2pg HOT 6 CLOSED

Hi Ravi,

You installation is ok, this is your connection that is failing. Here is the message returned by DBD::Oracle 👍

 ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)

It seems that there is not listener on host ... or at least not on default port 1521.

You must change your ORACLE_DSN setting in your ora2pg.conf configuration file or use the -s option.

After Installation didn't get /usr/local/bin/ora2pg file.

You must be root to install Ora2pg in this place.

from ora2pg.

Hi,

Thanks for the support, now we are able to access.
Able to generate DDL scripts for the objects.

What parameters are need to cconfigured to get DML and other DB Objects like package, procedure, functions, views and all.
Can you let us know on this?

Regards
Ravikiran

from ora2pg.

Please look at the documentation and this presentation for more information: http://ora2pg.darold.net/ora2pg-best-practices.pdf

from ora2pg.

I also facing same problem of ORA-12514 TNS LISTENER, i run the following command when i get the listener error:

E:\ora2pg-23.0>ora2pg -t copy -c ora2pg_employee.dist -l employee.log
WARNING: NO_LOB_LOCATOR is deprecated, use USE_LOB_LOCATOR instead see documentation about the logic change.
WARNING: NO_BLOB_EXPORT is deprecated, use ENABLE_BLOB_EXPORT instead see documentation about the logic change.
[========================>] 1/1 tables (100.0%) end of scanning.
NOTICE: user mapping for "employee" already exists for server "orcl", skipping
[========================>] 1/1 tables (100.0%) end of table export.
NOTICE: drop cascades to foreign table ora2pg_fdw_import.employee_details
DBD::Pg::db do failed: ERROR: connection for foreign table "employee_details" cannot be established
DETAIL: ORA-12541: TNS:no listener at C:/Strawberry/perl/site/lib/Ora2Pg.pm line 9352.
[========================>] 71/71 rows (100.0%) on total estimated data (1 sec., avg: 71 recs/sec)

I tried every solution which is available on internet but not able to resolve this issue. Please let me know if you know the solution.
Thank you in advance.

from ora2pg.

Please look at the documentation and this presentation for more information: http://ora2pg.darold.net/ora2pg-best-practices.pdf
Hi @darold
Document is not available on this link.

from ora2pg.

The link is available at http://ora2pg.darold.net/slides/ora2pg-best-practices.pdf

from ora2pg.