emctl status dbconsole command gives error “Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name”. How to fix this error? Add environment variable.
Go to Start > Control Panel > System
On the left press Advanced System Options
Go to Environment Variables…
Enter Variable name “ORACLE_UNQNAME” and Variable value “orcl”. Variable value you can find in Control Panel > Services list. Find service OracleServiceXXX, where suffix XXX is your Oracle service name. This suffix goes as environment variable value.
In New System Variable dialog box press OK. In Environment variables window press OK. In System Properties window press OK. Close System window in Control Panel.
One client asked us: “Is it possible to hide/show folders in repository physical layer depending on user‘s GROUP? One company departament sees just Forecast dababase (also related bussines layer and presentation), other Paint, etc.”.
As much as I know, it is not possible. Is this right?
Recently I could not answer one question. Since Oracle Download page gives one setup file for Standard Edition One 11g, Standard Edition 11g, Enterprise Edition 11g, how can I install Standard Edition One 11g only?
During setup I will not choose any options, is this enough? I don’t think so. In Oracle My Support I found some clues for version 9 [ID 139642.1]. But it says just to drop some system users like MDSYS.
One of Oracle Business Intelligence Standard Edition One requirements (or limitations) is max 2 socket server. How to determine that? On windows machines I run WinAudit program. In summary page “Number of processors” it shows physical number of CPU, that means physical number of sockets. However, I know that I have two cores 🙂 So, I think program shows correct information.
I liked one feature of old good Oracle Designer – it automatically generated alias and title text from table name. I always have dilemma, what alias give for table when designing relational data warehouse.
Does anyone knows any tools like this online or open source?
Below there is the Europe map, where events will take place. England and Germany are the countries where the biggest number of events is planned. Does it mean, that in these countries have the biggest clients? Or, are they the most geographically convenient?
It would be so nice, that at least one event happened in Lithuania or in one of Baltic states.
In Oracle Warehouse Builder 10g R2 you can schedule ETL mapping without Oracle Workflow server. Though, in tutorials in Oracle Library the only examples of scheduling ETL was through Process Flows, which are implemented in Oracle Workflow server. To schedule ETL mapping you should create Calendar and assign it to Mapping Object in Project Explorer. Details can be found in these blogs: