Notifications
Clear all
Topic starter
Hi All -
I thought I had this figured out, when there is no connection to the database for any reason I could go to services and select the oracleservicessut90 services and restart it, my demo would open. I've did that about a million times and it still does not launch "cannot connect to server sut90" message.
Can anyone help, hoping its an easy fix so I won't have to uninstall and re-install and lose all of my forms I've created?
Any help would be appreciated!!!
Posted : December 1, 2014 9:49 am
Did you check your ODBC connection?
and made sure that the Oracle files in the EMR.
C:\Program Files (x86)\Centricity Physician Office\Oracle\network\ADMIN\tnsnames.ora
have the right information for your oracle server?
################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 18-DEC-02
################
SUTrain.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle)
(ARGV0 = oracleSUTRAIN)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA =
(SID = SUTRAIN)
)
)
################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 18-DEC-02
################
murray.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = 10.152.16.221)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = murray)
)
)
the host part?
Posted : December 1, 2014 12:53 pm
Topic starter
Its installed on my local computer.
I compared what you copied and I don't have host or port details as you have listed?
Please pardon my ignorance, but crazy question....can I copy and paste what you have listed here in y file, so it can open?
I have lots of forms here I don't want to lose them?!!!
Thanks again for responding!
Posted : December 1, 2014 3:27 pm
depend,
1st. What version of EMR you have?
Oracle or SQL?.
2nd. i dont remember how the demo install.
what i'm giving you is the information of my Oracle version of EMR. But this used to be production.
I mean: 1 oracle server listening. and clients with this configuration connecting to it.
3rd. Can you copy and paste the content of your Tnsname.ora to see if it using this method to connect to the database?
Posted : December 2, 2014 4:31 am
I am having the same issue with a 9.5 evaluation emr that has been working since 2012 and now it has just stopped working with, “cannot connect to server sut90" I'm not trying to thread hijack just figured since we are having the same issue I could post here. If I need to make a new topic please let me know. Thank You!
################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 29-JUN-95 19:17:19
################
SUTrain.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle)
(ARGV0 = oracleSUTRAIN)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA =
(SID = SUTRAIN)
)
)
################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 29-JUN-95 19:17:19
################
sut90.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle)
(ARGV0 = oraclesut90)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA =
(SID = sut90)
)
)
Posted : February 27, 2015 5:10 am
I checked services and my "oracleservicessut90" service was disabled. It is now working 🙂
Posted : February 27, 2015 5:26 am
How/Where do you check services for the demo? Thanks!
Posted : April 14, 2015 12:47 am
Bump for how to check services for the demo!
Posted : August 15, 2015 12:45 pm
