- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Dba studio connection
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2001 08:19 AM
тАО11-01-2001 08:19 AM
Oracle Dba studio connection
I am on a windows 2000 (iv) Personal Oracle 8i 8.1.7.
I get ORA - 12154 TNS: Could not resolve service name - help????
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2001 12:25 PM
тАО11-01-2001 12:25 PM
Re: Oracle Dba studio connection
What you have to check is wheter you have sqlplus and DBA studio installed in separate ORACLE_HOMEs, which in effect means that you have 2 separate tnsnames.ora (or 2 ../network/admin folders)
An Oracle client installation makes a /ora8i/network/admin and an Enterprise Manager/DBA studio installation makes an /oracle/ora81/network/admin folder. (or was it the other way around.?)
Check if this is the case and copy your valid tnsnames.ora to the adminfolder where it is missing or incomplete.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2001 04:25 AM
тАО11-02-2001 04:25 AM
Re: Oracle Dba studio connection
You should should set the environment variable TNS_ADMIN directing to the correct directory for the tnsnames.ora ( sample export TNS_ADMIN=c:\ora81\network\admin ) on your workstation.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2001 08:14 AM
тАО11-02-2001 08:14 AM
Re: Oracle Dba studio connection
I have oracle\ora81\network\admin and
oracle\ora81\admin
I copied over a tnsnames but it made no difference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2001 08:48 AM
тАО11-02-2001 08:48 AM
Re: Oracle Dba studio connection
I am on win 2000 service pack 2. Start control panel system advanced enviromental variables click new ??? Or in regedit somewhere???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2001 01:56 PM
тАО11-02-2001 01:56 PM
Re: Oracle Dba studio connection
Hmmm.. Its the ..\network\admin that is the correct one.
Do you have an suffix / domain name added to your service name; something like your_db.world = in the tnsnames.ora?
Have sometimes found that some applications need the full service specified while others don't. So sqlplus accepts your_db as service name but DBA studio needs your_db.world? but I migh be on a wrong track here. Will check into it.
Setting TNS_ADMIN is done in My Computer | Properties.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2001 07:39 PM
тАО11-02-2001 07:39 PM
Re: Oracle Dba studio connection
check whether you have a entry in the tnsnames.ora file for the new database.
The file is located at $ORACLE_HOME/network/admin directory.
As you are using W2k use Net8 assistant to configure you local net service name.
provide a service name to connect to the machine with database.
else
open your tnsnames.ora file and add entry like the below.
"database-sid".world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
protocoltype
>>> (PROTOCOL = TCP)
host machine ip-address or hostname.check whether you hostname is resolving properly.
>>> (Host = xx.xx.xx.xx)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = xx.xx.xx.xx)
(Port = 1526)
)
)
>>>database-sid name.
(CONNECT_DATA = (SID = "database-sid name")
)
)
Also check your listener.ora file on the database server to check whether you have configured a listener for the database.
Else use NET8 configuration assistant for listener configuration.
(SID_DESC =
(GLOBAL_DBNAME = "database-name")
(ORACLE_HOME = "ORACLE-home")
(SID_NAME = "database-name")
)
check in the control Panel----->services
and check for the listener service whether it is started properly on the server.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2001 02:53 AM
тАО11-05-2001 02:53 AM
Re: Oracle Dba studio connection
pinged my machine ok.
net start showed me that listener is running.
When I run tnsping service_name I get TNS - 03505 Failed to resolve service_name.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2001 03:02 AM
тАО11-05-2001 03:02 AM
Re: Oracle Dba studio connection
With this tnsnames.ora it connects -
AWGCDP1.mag.co.uk =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2.mag.co.uk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = awgcdp1.mag.co.uk)
)
)
Whereas,this does not!
AWGCDP1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2.mag.co.uk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = awgcdp1.mag.co.uk)
)
)
I had actually been shuffling around with the combinations before with no success but obviously looking back at my older copies of tnsnames I see I had not made an exact match as above. So service_name and the actual bit before the description (and the host) must be similar?
Andreas the way I was asking to set TNS_ADMIN was also correct.
Thank you all for your assistance!!!
Now I shall start with configuring this database on windows 95 and NT - wish me luck!!!!