oracle标签安全,未配置Oracle 12c中的Oracle标签安全性(Oracle label security in Oracle 12c not configured)...
未配置Oracle 12c中的Oracle标签安全性(Oracle label security in Oracle 12c not configured)
我在win x64 server 2012上安装了Oracle 12c release1(12102)企业版，并使用DBCA创建了一个数据库，并选择了OLS组件(帐户LBACSYS也已解锁)。
完成后，我尝试使用OLS，但它说没有配置此功能。 运行chopt启用lbca但此选项不可用。
PS C:\Users\Administrator> chopt enable lbac
Incorrect option name: lbac
usage:
chopt
options:
dm = Oracle Data Mining RDBMS Files
ode_net = Oracle Database Extensions for .NET
olap = Oracle OLAP
partitioning = Oracle Partitioning
rat = Oracle Real Application Testing
e.g. chopt enable rat
I installed Oracle 12c release1 (12102) Enterprise Edition on win x64 server 2012 and created a database using DBCA with OLS component selected (account LBACSYS also unlocked).
After finished, I tried to use OLS but it said that this feature is not configured. Running chopt enable lbca but this option is not available.
PS C:\Users\Administrator> chopt enable lbac
Incorrect option name: lbac
usage:
chopt
options:
dm = Oracle Data Mining RDBMS Files
ode_net = Oracle Database Extensions for .NET
olap = Oracle OLAP
partitioning = Oracle Partitioning
rat = Oracle Real Application Testing
e.g. chopt enable rat
原文：https://stackoverflow.com/questions/45994266
更新时间：2019-12-27 16:11
最满意答案
检查是否从sqlplus启用了OLS：
SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';
检查是否配置了OLS：
select name, status, description from dba_ols_status;
NAME STATUS DESCRIPTION
-------------------- ------ ------------------------ -------------
OLS_CONFIGURE_STATUS FALSE Determines if OLS is configured
OLS_DIRECTORY_STATUS FALSE Determines if OID is enabled with OLS
OLS_ENABLE_STATUS FALSE Determines if OLS is enabled
以SYS用户或已被授予LBAC_DBA角色的用户身份登录数据库实例。
如果尚未配置OLS，请运行以下过程以配置OLS：
SQL> EXEC LBACSYS.CONFIGURE_OLS;
运行以下过程以启用OLS：
SQL> EXEC LBACSYS.OLS_ENFORCEMENT.ENABLE_OLS;
重启数据库。
CONNECT SYS AS SYSOPER
Enter password: password
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;
对于Oracle Real Application Cluster(Oracle RAC)环境或多租户环境，请对禁用Oracle Label Security的每个Oracle RAC节点或PDB重复这些步骤。
Check if OLS is enabled from sqlplus:
SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';
Check if OLS is configured:
select name, status, description from dba_ols_status;
NAME STATUS DESCRIPTION
-------------------- ------ ------------------------ -------------
OLS_CONFIGURE_STATUS FALSE Determines if OLS is configured
OLS_DIRECTORY_STATUS FALSE Determines if OID is enabled with OLS
OLS_ENABLE_STATUS FALSE Determines if OLS is enabled
Log into the database instance as user SYS or a user who has been granted the LBAC_DBA role.
If OLS is not yet configured, run the following procedure to configure OLS:
SQL> EXEC LBACSYS.CONFIGURE_OLS;
Run the following procedure to enable OLS:
SQL> EXEC LBACSYS.OLS_ENFORCEMENT.ENABLE_OLS;
Restart the database.
CONNECT SYS AS SYSOPER
Enter password: password
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;
For Oracle Real Application Cluster (Oracle RAC) environment or a multitenant environment, repeat these steps for each Oracle RAC node or PDB on which you disabled Oracle Label Security.
2017-09-01
相关问答
1、关闭所有ORACLE服务。 2、在安装目录下，找到 deinstall.bat 文件并执行。 如：D:\app\u01\product\12.1.0\dbhome_1\deinstall 3、等待上述执行结束，重启电脑即可。
按照标签安全管理员指南和Database Vault管理员指南进行操作 ： 检查是否从sqlplus启用了OLS： SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';
检查是否配置了OLS： select name, status, description from dba_ols_status;
NAME STATUS DESCRIPTION
-------------------- ---
...
这是因为您是属于dba组的用户进行身份验证。 尝试去用户组并删除您的用户。 当您认证为sysdba或sysoper时，Oracle首先验证您的用户是否属于dba组。 That's because you're authenticating as a user belonging to the dba group. Try going to the users groups and remove your user. When you authenticate as sysdba or sysope
...
这是以前版本的Oracle Enterprise Pack for Eclipse中的一个已知问题。 要解决此问题，请从Eclipse Marketplace安装Oracle Coherence Tools或只更新到解决此问题的最新版本的OEPE(12.1.2.1.1)。 This is a known issue in some past versions of Oracle Enterprise Pack for Eclipse. To workaround, install Oracle C
...
您是否看过有关安装的oracle文档？ 它非常简单，包含几个场景： http://docs.oracle.com/database/121/HTMIG/overview.htm#CEGEGBAE Have you taken a look at the oracle documentation regarding the installation? It's pretty much straight forward and contains several scenarios: http://do
...
正如贾斯汀所说，这样做是不明智的。 但它可以这样做。 select cast(substr('123456789',1,4) as integer) from dual;
但这不适用于以下场景。 你在号码前有0 。 在第4位之前有一个十进制数字(ex 123.4) As suggested by Justin, it is not sensible to do so. But it can be done like this. select cast(substr('123456789',1,4
...
您必须使用sqoop将oracle数据转换为hive。 您可以阅读此内容以获取更多信息 You must use sqoop for transform your oracle data to hive. You can read this for more info
也许这对你有用： 来自： http : //ccm.net/faq/4405-linux-installing-oracle-11g-on-ubuntu#installing-packages-needed-for-pre-installation 简单来说，你必须安装外星人，然后为oracle-db创建组和用户(参见指南)， 然后你可以用外星人来安装oracle，这似乎不是一个漂亮的方式，也许在将来会流浪可以帮助我们。 有更多的细节和步骤的其他指南： http : //tutorialforli
...
您可以创建一个触发器，在任何insert语句上将触发一个函数将整个列转换为大写。 更新客户设置FirstName = UPPER(FirstName) You can create a trigger that upon any insert statement will fire a function to convert the entire column to uppercase. UPDATE Customers SET FirstName = UPPER(FirstName)
一个小小的谷歌搜索给了我这个： http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.System.html#Appendix.Oracle.CommonDBATasks.KillingSession begin
rdsadmin.rdsadmin_util.kill(
sid => sid,
serial => serial_numb
...