Sitemap

Amicuk Programming Answers

Strange Database issues while trying to create new user through EM...

2015-10-11   Views:0

Advertisement

I'm attempting to configure my local Oracle 11g database in order to create a Content Server user in order to setup a Fatwire installation. I'm getting some strange issues with my database that I was hoping maybe someone could help me out with. The g

I'm attempting to configure my local Oracle 11g database in order to create a Content Server user in order to setup a Fatwire installation. I'm getting some strange issues with my database that I was hoping maybe someone could help me out with.
The guide I'm following starts with this:
+1. Determine the Console Server port:+
a. Open the emoms.properties file in a text editor. The file is located in:
+<ora_home>/<servername>_<SID>/sysman/config/+
b. Find the line,
oracle.sysman.emSDK.svlt.ConsoleServerPort
and make a record of the port number value at the end of the line.
When I open the emoms.properties file in Notepad++, I'm unable to read the contents - it's all symbols/jibberish.
The next step says this:
+2. Log in to the Oracle Enterprise Manager console:+
a. Execute the following command: emctl status dbconsole
When I execute that command I get the following error:
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
The third step says this:
Open a browser and go to the URL highlighted in bold in step a above. If you see
a “Security Mismatch” error, ignore it (the error appears if you are using a selfsigned
certificate).
I skipped to this step because I'm assuming the link it wants me to go to is my EM console (https://localhost:1158/em/console/aboutApplication), however when I browse to that URL I get the following error:
503 Service Unavailable
Service is not initialized correctly. Verify that the repository connection information provided is correct.
Clearly, something isn't right here. What's going on? Any help would be appreciated.

The replay answer
Advertisement
Alfonso Vicente wrote:
Did you try what I suggested?Yes, thanks for the advice. Now I'm having some additional issues. When I run emctl status dbconsole I get the following error:
OC4J Configuration issue. C:\app\john.smith\product\11.2.0\dbhome_1/oc4j/j2ee/OC4
J_DBConsole_ORCL-SMITH.company.com_localhost_orcl not found.
This is appearing after I made the appropriate changes to the emoms.properties file and set ORCL_UNQNAME to "localhost_orcl" <-- is that correct? the path to my emoms.properties is:
C:\app\john.smith\product\11.2.0\dbhome_1\localhost_orcl\sysman\config
Here is my emoms.properties file, does this look right?
#Mon Mar 19 17:56:05 EDT 2012
oracle.sysman.emSDK.svlt.ConsoleServerName=localhost\:1158_Management_Service
oracle.sysman.eml.mntr.emdRepPwd=2ad171ddf6ce91aebf1c2f2c371ee5a315591a1be21f37965a88d54126d7528aa1091f543569e58b
emdrep.ping.pingCommand=/bin/ping -c 3 -w 30 <hostname>
em_oob_shutdown=false
LargeRepository=false
oracle.sysman.eml.mntr.emdRepPort=1521
em_email_address=
oracle.sysman.eml.mntr.emdRepPwdSeed=8622625238442107993
em_oob_crash=false
em.oms.dumpModules=omsThread,repos
oracle.sysman.emRep.dbConn.statementCacheSize=50
oracle.sysman.db.isqlplusUrl=%ISQLPLUS_PROTOCOL%\://%ISQLPLUS_HOST%\:%ISQLPLUS_PORT%/isqlplus/dynamic
em_oob_startup=false
oracle.sysman.emSDK.svlt.ConsoleServerPort=4889
em_from_email_address=_NOT_AVAILABLE_
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
oracle.sysman.db.isqlplusWebDBAUrl=%ISQLPLUS_PROTOCOL%\://%ISQLPLUS_HOST%\:%ISQLPLUS_PORT%/isqlplus/dba/dynamic
oracle.sysman.emSDK.svlt.ConsoleServerHost=localhost
em_from_email_name=_NOT_AVAILABLE_
oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=1159
em_email_gateway=
oracle.sysman.eml.mntr.emdRepServer=localhost
oracle.sysman.eml.mntr.emdRepSID=NO_VALUE
oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=localhost)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=orcl)))
oracle.sysman.emkeyfile=C:\app\john.smith\product\11.2.0\dbhome_1\localhost_orcl\sysman\config\emkey.ora
em.ip.ui.enable=true
oracle.sysman.eml.mntr.emdRepUser=sysman
oracle.sysman.emSDK.svlt.PublicServletEnabled=true

Go to See the other 15 answers

Strange Database issues while trying to create new user through EM...

Category:DefaultRelease time:2015-10-11Views:130

I'm attempting to configure my local Oracle 11g database in order to create a Content Server user in order to setup a Fatwire installation. I'm getting some strange issues with my database that I was hoping maybe someone could help me out with. The g[More]

Strange import issue .. no longer works in 2.6 or Beta 3

Category:DefaultRelease time:2015-10-11Views:130

Strange import issue. I use LR-2.6 everyday but have only played around with the LR-3 for a limited amount of time so the other day I decided check it out and tried to import a handful of RAW(canon) files on a SDxc-8g card via a USB card reader. I se[More]

Access database issue in SQL Plus

Category:DefaultRelease time:2015-10-11Views:130

Hi Friends, I download a oracle 10g to install sql Plus without create database. (I download client and does not find SQL Plus) I can ping database server from client PC and also set up a TNS. However I got a error ORA 12504 --TNS:listener was not st[More]

Strange Printing Issue With New HP & Pages

Category:DefaultRelease time:-0001-11-30Views:130

Hello! I have a very strange printing issue with a new HP printer. I have written pages documents heavy in Texts which are located within tables. The documents print fine on a Cannon and Epson printer and look great but when I print the document on m[More]

What is the "No database index" means when you Creating Secondary Indexes?

Category:DefaultRelease time:2015-10-11Views:130

HI,    I'm Creating Secondary Indexes in the maintenance screen of the table(se11)    There are three options under "Non-unique Index":    1.Index on all database systems    2.For selected database systems    3.No database index My questions is[More]

Strange performance issue with 3510/3511 SAM-FS disk cache

Category:DefaultRelease time:2015-10-11Views:130

Hi there! I'm running a small SAM-QFS environment and have some strange performance issue on the disk storage part, which somebody here might be able to explain. Configuration: one 3510, dual controller, RAID-5 9+1, one hot spare and one disk not con[More]

Database issue in TM

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Can someone throw light how we access or find out if there is any  database issue or where fine tuning is required for improving ABAP performance using tcode sdf/mon. Currently when I enter into transaction and select SQL trace etc we only get in[More]

Cloud Database issue:-Timeoutexpired. The Timeout perion elapsed prior to completion of the operation or the server is not responding

Category:DefaultRelease time:-0001-11-30Views:130

I am facing following issue in cloud database Issue:  Altering any stored procedure in cloud database, Application throwing time out issue. If same stored procedure running in backend(SQL),it's executing without delay i.e. executing in 3 sec, not sur[More]

CO-PA for good issue documents are not created

Category:DefaultRelease time:-0001-11-30Views:130

Dear All We are using both account & cost based CO-PA , actually the problem is this that when we are doing the sales cycle, after billing my CO-PA document created  but the same when I do delivery COGS document not created  ,actually for sales I am[More]

Database issue? Client issue?

Category:DefaultRelease time:-0001-11-30Views:130

very similar sql statements. if it returns less than 100 rows, it takes 1 second, which is acceptable. But when it returns 1000+ rows, it takes 10+ seconds, which is not acceptable. My question is, is it the database issue? or because of the network/[More]

Strange Catalog Issue or bug. Help, photos disappeared help?

Category:DefaultRelease time:-0001-11-30Views:130

My images disappeared in the catalog. They are not missing, they are just not visable. I think there is a bug in the Fliter section. Let me explain. I have one Main folder with 5 Sub folders. All those folders contain random amounts of images. (i.e.[More]

Hot
The HD was getting errors back in December, so I cloned it on a new, larger drive. Now it's 2+ months later, and I had a hard failure of the original drive. DIskWarrior brought it back, but I've now swapped to the new drive that was cloned in Decembe [More]
Hi, I have written the below query which is having CASE statement in ORDER BY clause. Please let me know what mistake i have done in the query because am getting "Missing Keyword" Error. SELECT opn_quest_id, seq_nbr FROM opinion_question order b [More]
Hi Friends, Customer sends 2 IDoc DEBMAS, ADRMAS. The conditions is when both the IDocs is having the same customer no we need to send to the outside system.  (DEBMAS - E1KNA1M - KUNNR) equals to (ADRMAS - E1ADRMAS - OBJ_ID). I have designed BPM for [More]
  I' have a problem with my map loader and I hope someone can help me. When I try to open map loader on my PC it gives me an error saying: '' unhandled exception has occured in a component in yr application. If u click continue the application will i [More]
Hey guys. Im trying to output a report a HTML file. I know this is possible because i've read a good bit over white papers talking about the functionality, but I haven't been able to find a source that details the step by step instructions on how to [More]
When i try to install Ms SQL server 2000 for SAP  it is giving me a message , "unable to validate product key" Pls let me know how to solve itDear, When u install original sql server, might be it should not ask for product key. In sql source the [More]
Hello- Running FCP7 on Mac Duo Quad Core Nehalem, OS 10.6. Hopefully really simple solution to this. Doing a Canon 5D workflow in FCP. So bring in via Log and Transfer. I've got the plug-in installed. Up to this point it's been going smooth - open up [More]
This is on a Windows server 2008 r2. I am trying to allow users to watch help videos at a vendor site. If I remote desktop using the Administrator, I can play the videos and if I check the "manage add-ons", I see Windows Media Player as an exten [More]
please answer soonMaren, I won't rule out the update, but I have seen the servers for the store get overloaded/bogged down during high volumes times where it may take as much as a day before you can get in. I know this doesn't help a lot, but be just [More]
Hello After spending a whole morning working on a presentation, Keynote '08 suddenly quit, with the normal message. Now the file I was working on will not open, no matter what computer (we have three in the office) or what I do. I have searched throu [More]