# tnsnames. Ora Network Configuration File: d: \ \ Administrator \ product \ app 11.1.0 \ client_1 \ Network \ ADMIN \ tnsnames ora
# Generated by Oracle configuration tools.

NBBF=
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(TCP) PROTOCOL=(HOST=10.123.1.90) (1521) PORT=)
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SERVICE_NAME=hy.beifa.com)
)
)


==================================
NBBF in PLSQL can be connected in a
PB database configuration
Profile Name: NBBF_ORACLE
Server:hy.beifa.com
The Login ID: SCM
Password: * * * * *
Connect the as: Default

After configured connection tip: ORA - 12170: TNS: connection timeout

CodePudding user response:

If your PB program blocked by a firewall?

CodePudding user response:

No shielding ah,,,,, now is not a PB program, is not even development tools, the description of the PB files are not built, test the connection is wrong,

CodePudding user response:

In PB development database prifile as follows:
//Profile NBBF
The SQLCA. DBMS="O90 Oracle9i (9.0.1)"
The SQLCA. LogPass=& lt; * * * * * * & gt;
The SQLCA. ServerName="NBBF"
The SQLCA. LogId="SCM"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="PBCatalogOwner='SCM, TableCriteria=', SCM '"
In the PB database first painter in the database connection, the rest is right,

CodePudding user response:

reference fm20027 reply: 3/f

PB development database prifile of are as follows:
//Profile NBBF
The SQLCA. DBMS="O90 Oracle9i (9.0.1)"
The SQLCA. LogPass=& lt; * * * * * * & gt;
The SQLCA. ServerName="NBBF"
The SQLCA. LogId="SCM"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="P...

SQLCA. LogPass='users

CodePudding user response:

Tnsping NBBF see

CodePudding user response:

The server name you write wrong, the server name should be the machine set up the service name is NBBF isn't you of the name of the server,

CodePudding user response:

Profile Name: NBBF
Server: NBBF
The Login ID: SCM
Password: * * * * *
Connect the as: Default