connect to Oracle using bequeth protocol
connect to Oracle using bequeth protocol
Hello,
I need to connect to Oracle using bequeth protocol urgently for testing purposes , how I can do that using unidac ?
thanks
I need to connect to Oracle using bequeth protocol urgently for testing purposes , how I can do that using unidac ?
thanks
Hello
Protocol for connecting to Oracle is defined in the "tnsnames.ora" file. You should add the following entry for connecting using Bequeath protocol to this file:
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = ORACLE_HOME/bin/oracle)
(ARGV0 = oracleORACLE_SID)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
(ENVS = 'ORACLE_HOME=ORACLE_HOME,ORACLE_SID=ORACLE_SID')
)
After adding this entry you can connect to Oracle using the Bequeath protocol protocol by ODAC or UniDAC components.
You can find more detailed information about the "tnsnames.ora" file in the Oracle documentation.
Protocol for connecting to Oracle is defined in the "tnsnames.ora" file. You should add the following entry for connecting using Bequeath protocol to this file:
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = ORACLE_HOME/bin/oracle)
(ARGV0 = oracleORACLE_SID)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
(ENVS = 'ORACLE_HOME=ORACLE_HOME,ORACLE_SID=ORACLE_SID')
)
After adding this entry you can connect to Oracle using the Bequeath protocol protocol by ODAC or UniDAC components.
You can find more detailed information about the "tnsnames.ora" file in the Oracle documentation.
Hi
I added the protocol and still got this error
I can log in using BEQ protocol from oracle navigator but I wish to do the same from the ODACDemo
please advice
thanks
I added the protocol and still got this error
I tried with the ODAC demo application, I type user po8, pass po8 and server: localhost---------------------------
Oracle Data Access Components demos
---------------------------
ORA-12224: TNS:no listener
---------------------------
OK
---------------------------
I can log in using BEQ protocol from oracle navigator but I wish to do the same from the ODACDemo
please advice
thanks
Hi,
this is the content of TNSNAMES.ORA
Thanks
this is the content of TNSNAMES.ORA
about the parameters I use user po8, pass po8 and server: localhost nothing more but please tell me the correct ones and I will use them in the ORA Demo application# TNSNAMES.ORA Configuration file: d:\ORANT\NET80\ADMIN\tnsnames.ora
# Generated by Oracle Net8 Assistant
NmpExample.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
(CONNECT_DATA = (SID = ORCL)
)
)
CMExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = tcp)
(PORT = 1610)
(HOST = CM_SERVER)
)
(ADDRESS =
(PROTOCOL = tcp)
(PORT = 1521)
(HOST = LSNR_SERVER)
)
)
(CONNECT_DATA = (SID = ORCL)
)
(SOURCE_ROUTE = yes)
)
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = ORCL)
)
(CONNECT_DATA = (SID = extproc)
)
)
Beq-local.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = ORACLE_HOME/bin/oracle)
(ARGV0 = oracleORACLE_SID)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
(ENVS = 'ORACLE_HOME=ORACLE_HOME,ORACLE_SID=ORACLE_SID')
)
(CONNECT_DATA = (SID = ORCL)
)
)
TcpExample.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80SID1)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
(CONNECT_DATA = (SID = SID1)
)
)
SpxExample.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = localhost)
(PORT = 1521)
)
(CONNECT_DATA = (SID = ORCL)
)
)
ORCL.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = localhost)
(PORT = 1521)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Thanks
Try to set the Server property to an empty value. Maybe this is what you need.
If it doesn't help you then try to set the Server property to "Beq-local.world", "TcpExample.world", or "SpxExample.world". You should also check these entries in the "tnsnames.ora" file. The entry you are going to use should contain correct params ORACLE_HOME, ORACLE_SID, PROGRAM, ARGV0, ARGS etc. I cannot help you to setup your "tnsnames.ora" file because only you know the folder where Oracle is installed, the version of Oracle, and SID that was defined during installation. If you cannot setup the "tnsnames.ora" file on your own then ask an Oracle administrator to help you.
If it doesn't help you then try to set the Server property to "Beq-local.world", "TcpExample.world", or "SpxExample.world". You should also check these entries in the "tnsnames.ora" file. The entry you are going to use should contain correct params ORACLE_HOME, ORACLE_SID, PROGRAM, ARGV0, ARGS etc. I cannot help you to setup your "tnsnames.ora" file because only you know the folder where Oracle is installed, the version of Oracle, and SID that was defined during installation. If you cannot setup the "tnsnames.ora" file on your own then ask an Oracle administrator to help you.
Hello
At first make sure that user po8 has permission to perform select from your table. You should keep in mind that permission to create tables and permission to select from tables are different permissions.
Try to quote table name in your query and execute the query again.
If you get the "This table or view does not exists" error and then try to execute the following query:
select table_name
from user_tables
It will return a list of tables in you schema. Make sure that your table exists.
If the table exists then, please, send us the text of your query, a DDL script to create tables for this query and the result of the "select table_name from user_tables" query.
At first make sure that user po8 has permission to perform select from your table. You should keep in mind that permission to create tables and permission to select from tables are different permissions.
Try to quote table name in your query and execute the query again.
If you get the "This table or view does not exists" error and then try to execute the following query:
select table_name
from user_tables
It will return a list of tables in you schema. Make sure that your table exists.
If the table exists then, please, send us the text of your query, a DDL script to create tables for this query and the result of the "select table_name from user_tables" query.