Hi,
I have got a problem after installing Oralce 11g Database on Linux 5. Before
this I had configured the Oracle Database 9iR2 on Widows2003, but after
upgrading database and OS as well, my reports are not displaying. Forms connect
with the newly linux Machine and getting query and posting transaction
successully. But when I execute the report it gives me error '
Get a 'REP-501: Unable to connect to the specified database' .
Before this, the AS10R2 was working perfectly with Database 9iR2 Windows-2003.
Application Server 10R2 on Windows 2003.
Database 11g on Linux RedHat 5 Enterprise Edition.
I have done the following.
1. remove the rep_webora_ashome.conf from d:\oracle\as_home\reports\conf
2. TNS_ADMIN = d:\oracle\as_home\NETWORK\ADMIN
3. OS env = d:\oracle\as_home\network\Admin
4. Regitry Edit ORACLE_HOME_KEY add String
TNS_ADMIN=D:\oracle\as_home\Network\Admin
Sqlnet.ora ( Application Server 10gR2)
sqlnet.ora Network Configuration File:
D:\oracle\as_home\NETWORK\ADMIN\sqlnet.ora
Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
#SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, HOSTNAME, ONAMES)
#NAMES.DIRECTORY_PATH= (TNSNAMES)
All Remark and Un-Remark entries have been checked.
Listener.ora ( Application SErver )
listener.ora Network Configuration File:
D:\oracle\as_home\network\admin\listener.ora
Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\as_home)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = webora)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
tnsnames.ora Network Configuration File:
D:\oracle\as_home\NETWORK\ADMIN\tnsnames.ora
Generated by Oracle configuration tools.
V9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.107)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DB11G)
)
)
REP_WEBORA_ASHOME. =
(ADDRESS = (PROTOCOL = tcp)(HOST = webora)(PORT = 1950))
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = webora)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
Listener.ora on Linux
listener.ora Network Configuration File:
/osoft/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = redora.ute)(PORT = 1521))
)
-----------------------------SQLNET.ORA on Linux
sqlnet.ora Network Configuration File:
/osoft/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora
Generated by Oracle configuration tools.
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
KINDLY TELL ME WHERE I AM WRONG AND WHAT FURTHER STEPS NEED TO BE TAKEN.
THANKS AND REGARDS.
Get rid of Add-Ons in your email ID get [EMAIL PROTECTED] Sign up now!
http://in.promos.yahoo.com/address
[Non-text portions of this message have been removed]
------------------------------------
To unsubscribe from this list, please email [EMAIL PROTECTED] & you will be
removed.Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/LINUX_Newbies/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/LINUX_Newbies/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
