Oracle Management – Page 2

Poor Yum Repo: OracleLinux6

I’m now working on an Oracle Linux 6U1 x64 box, planning to inst new 11R2 image.

Problem hit here.

# yum install unixODBC-devel.i686
...
--&gt; Running transaction check
---&gt; Package unixODBC.i686 0:2.2.14-11.el6 will be installed
--&gt; Processing Dependency: libc.so.6(GLIBC_2.7) for package: unixODBC-2.2.14-11.el6.i686
...
---&gt; Package glibc.i686 0:2.12-1.25.el6 will be installed
...--&gt; Processing Dependency: glibc-common = 2.12-1.25.el6 for package: glibc-2.12-1.25.el6.i686
---&gt; Package ncurses-libs.i686 0:5.7-3.20090208.el6 will be installed
---&gt; Package nss-softokn-freebl.i686 0:3.12.9-3.el6 will be installed
--&gt; Finished Dependency Resolution
Error: Package: glibc-2.12-1.25.el6.i686 (ol6_u1_base)
           Requires: glibc-common = 2.12-1.25.el6
           Installed: glibc-common-2.12-1.25.el6_1.3.x86_64 (@ol6_latest)
               glibc-common = 2.12-1.25.el6_1.3
           Available: glibc-common-2.12-1.25.el6.x86_64 (ol6_u1_base)
               glibc-common = 2.12-1.25.el6
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

# yum install unixODBC-devel.i686

...

--> Running transaction check

---> Package unixODBC.i686 0:2.2.14-11.el6 will be installed

--> Processing Dependency: libc.so.6(GLIBC_2.7) for package: unixODBC-2.2.14-11.el6.i686

...

---> Package glibc.i686 0:2.12-1.25.el6 will be installed

...--> Processing Dependency: glibc-common = 2.12-1.25.el6 for package: glibc-2.12-1.25.el6.i686

---> Package ncurses-libs.i686 0:5.7-3.20090208.el6 will be installed

---> Package nss-softokn-freebl.i686 0:3.12.9-3.el6 will be installed

--> Finished Dependency Resolution

Error: Package: glibc-2.12-1.25.el6.i686 (ol6_u1_base)

Requires: glibc-common = 2.12-1.25.el6

Installed: glibc-common-2.12-1.25.el6_1.3.x86_64 (@ol6_latest)

glibc-common = 2.12-1.25.el6_1.3

Available: glibc-common-2.12-1.25.el6.x86_64 (ol6_u1_base)

glibc-common = 2.12-1.25.el6

You could try using --skip-broken to work around the problem

You could try running: rpm -Va --nofiles --nodigest

we can see that glibc.i686 <tip: just add arch. tag to install related pkg.> cannot be resolved for glibc-common label check failure.

it’s funny but not worse, ORCL even doesn’t provide glibc-common.i686 package…
http://public-yum.oracle.com/repo/OracleLinux/OL6/1/base/x86_64/

It should be a bug here….

WorkAround:

1. pull glibc package from weburl glibc-2.12-1.25.el6.i686.rpm.
2. # yum localinstall glibc-2.12-1.25.el6.i686.rpm
3. # yum install unixODBC-devel unixODBC-devel.i686
4. continue…

Notes….
Poor Yum repo…especially on x64 platform day’s, mixing with i686 libs.

where is the whereis

Today when I’m applying some scripts on Solaris 11Express nodes, a interesting error comeup,

  -bash: whereis: command not found

1	-bash: whereis: command not found

As on Solaris 10, we use cmd whereis(/usr/ucb/whereis) as a standard component.
(On Linux, it’s also a part of the util-linux-ng package )

Solaris 11X doesn’t include this command in default set, so turn to documents for help:

  Changes the Directory to /usr/ucb For a live CD installation, the path /usr/ucb does 
not exist by default. It can be added, along with many of the standard /usr/ucb tools by 
installing the 'compatibility/ucb' package from the repository.
  Note though that support for legacy plotters has been removed and this sees the 
removal of the following files (PSARC/2009/540):
...
...
  Other than these changes all of the commands available in /usr/ucb in Oracle Solaris 10 
continue to be available in Oracle Solaris 11 through the compatibility/ucb package.

Changes the Directory to /usr/ucb For a live CD installation, the path /usr/ucb does

not exist by default. It can be added, along with many of the standard /usr/ucb tools by

installing the 'compatibility/ucb' package from the repository.

Note though that support for legacy plotters has been removed and this sees the

removal of the following files (PSARC/2009/540):

...

Other than these changes all of the commands available in /usr/ucb in Oracle Solaris 10

continue to be available in Oracle Solaris 11 through the compatibility/ucb package.

Very lucky the command whereis is the rest for kept in compatibility/ucb package as optional.
But it’s no longer suggested to use such cmds in further SOLs, I finally gave up refresh the toolkits.

[Refrence:]
Oracle Solaris 11 ISV Adoption Guide
Solaris 11 Express Changes: Where is /usr/ucb ?
PSARC/2009/540*
*this arc shows the discussion on some port specific /usr/ucb commands,
the abandon of those codes speed up the far and away of those BSD like code.

From this point, SOL’s running faster than Linux….

ORA-28055: the password will expire within 7 days

ORA-28055: the password will expire within * days
Cause: The enterprise user's password is about to expire.
Action: Change the password in the directory or
        contact the directory administrator.

ORA-28055: the password will expire within * days

Cause: The enterprise user's password is about to expire.

Action: Change the password in the directory or

contact the directory administrator.

hit this issue, under scott/tiger schema, fix, to change passwd

SQL&gt; alter user scott identified by tiger;

User altered.

SQL> alter user scott identified by tiger;

User altered.

The more…

SQL&gt; SELECT profile
  2    FROM dba_users
  3   WHERE username = 'SCOTT';

PROFILE
------------------------------
DEFAULT

SQL> SELECT profile

2 FROM dba_users

3 WHERE username = 'SCOTT';

PROFILE

------------------------------

DEFAULT

Double check the table dba_profiles, and to change password_life_time parameter if necessary

SQL&gt;  SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES WHERE 
      PROFILE='DEFAULT' and RESOURCE_NAME LIKE '%PASSWORD%' ;

RESOURCE_NAME			 LIMIT
----------------------- ------------------------ 
PASSWORD_LIFE_TIME		 180
PASSWORD_REUSE_TIME		 UNLIMITED
PASSWORD_REUSE_MAX		 UNLIMITED
PASSWORD_VERIFY_FUNCTION	 NULL
PASSWORD_LOCK_TIME		 1
PASSWORD_GRACE_TIME		 7

6 rows selected.

SQL> SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES WHERE

PROFILE='DEFAULT' and RESOURCE_NAME LIKE '%PASSWORD%' ;

RESOURCE_NAME LIMIT

----------------------- ------------------------

PASSWORD_LIFE_TIME 180

PASSWORD_REUSE_TIME UNLIMITED

PASSWORD_REUSE_MAX UNLIMITED

PASSWORD_VERIFY_FUNCTION NULL

PASSWORD_LOCK_TIME 1

PASSWORD_GRACE_TIME 7

6 rows selected.

[PL/SQL Notes] PRAGMA AUTONOMOUS_TRANSACTION

自治事务，在PL/SQL语句内部执行。
在声明部分使用编译指示说明的，就标为自治，

Create or replace procedure Autonomous AS
    PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
  ...
    COMMIT; -- should be finished by commit/rollback, 
            -- or ora-6519 errno.
END Antomomouns

Create or replace procedure Autonomous AS

PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN

...

COMMIT; -- should be finished by commit/rollback,

-- or ora-6519 errno.

END Antomomouns

嵌套块不可以声明为自治，
只有包中的单独子程序可以标记为自治，包本身不能标记自治。
or,PLS-710

java.io.FileNotFoundException: datamodeler.log on sqldeveloper

sqldeveloper reported warning on datamodeler.log.

after check on OS,the sqldeveloper failed to create logs for priviledge issues.

# cd /opt/sqldeveloper/sqldeveloper/
# mkdir -p extensions/oracle.datamodeler/log
#chown user_to_run_ide  extensions/oracle.datamodeler/log

# cd /opt/sqldeveloper/sqldeveloper/

# mkdir -p extensions/oracle.datamodeler/log

#chown user_to_run_ide extensions/oracle.datamodeler/log

[suse@suse-pc ~]$ sqldeveloper

Oracle SQL Developer
Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.

log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: ../extensions/oracle.datamodeler/log/datamodeler.log (No such file or directory)
at java.io.FileOutputStream.openAppend(Native Method)
at java.io.FileOutputStream.&lt;init&gt;(FileOutputStream.java:177)
at java.io.FileOutputStream.&lt;init&gt;(FileOutputStream.java:102)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:273)
at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:156)
at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:152)
at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:247)

[suse@suse-pc ~]$ sqldeveloper

Oracle SQL Developer

log4j:ERROR setFile(null,true) call failed.

java.io.FileNotFoundException: ../extensions/oracle.datamodeler/log/datamodeler.log (No such file or directory)

at java.io.FileOutputStream.openAppend(Native Method)

at java.io.FileOutputStream.<init>(FileOutputStream.java:177)

at java.io.FileOutputStream.<init>(FileOutputStream.java:102)

at org.apache.log4j.FileAppender.setFile(FileAppender.java:273)

at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:156)

at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:152)

at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:247)