Oracle « Różności …

Różności …

3 maja 2016

PS-00027: internal error You configured a generic WLS LDAPAuthenticator

Zaszufladkowany do: ADF,Oracle,Programowanie,WebLogic — Tagi: , — Jacek @ 07:38

Oracle/Middleware/user_projects/domain/domain_name/config/ and open config.xml.

<sec:authentication-provider xsi:type=”wls:ldap-authenticatorType”>

manually change authenication-provider type to “wls:active-directory-authenticatorType”.

Source:

http://www.codeconfuse.com/2014/08/oraclesecurityjpsjpsruntimeexception.html

JPS-00027: internal error

Zaszufladkowany do: ADF,Oracle,Programowanie,WebLogic — Tagi: , — Jacek @ 07:18

So the admin server cannot be started because of the wrong authenticator type. But here is how to manually change the authenticator type. Target

$Domain_HOME/config/config.xml

Source:

http://jjzheng.blogspot.com/2012/09/manully-change-weblogic-security.html

2 maja 2016

weblogic.common.ResourceException: DataSource PRD already exists

Zaszufladkowany do: ADF,Oracle,Programowanie,WebLogic — Tagi: , — Jacek @ 12:07

Application->Application Properties. Expand the Deployment tree, click Weblogic. There is an “auto generate and synchronize WebLogic JDBC Descriptors during deployment” checkbox.

30 kwietnia 2016

weblogic: The task cannot be processed further until the current edit session is activated

Zaszufladkowany do: WebLogic — Tagi: — Jacek @ 10:43

That message is not an error. It means that you need to connect to the WebLogic Server Console and activate the changes.

Solution

Access the WebLogic Server Console and click on Activate Changes.

Confirm if your application shows in the WebLogic Server Console under “Deployments”.

Source:

https://community.oracle.com/message/10753255#10753255

17 października 2015

global cache blocks lost

Zaszufladkowany do: Oracle — Tagi: , — Jacek @ 08:06

global cache blocks lost–This statistic reveals any block losses during transfers and high values may indicate network problems. When using an unreliable IPC protocol such as UDP, the value for ‘global cache blocks lost’ may be non-zero. If this is the case, then the ratio of ‘global cache blocks lost’ divided by ‘global cache current blocks served’ plus ‘global cache cr blocks served’ should be as small as possible. A non-zero value for ‘global cache blocks lost’ does not necessarily indicate a problem, because Oracle retries the block transfer operation until it is successful. Unlike TCP/IP, UDP/IP is considered unreliable because UDP/IP provides very few error recovery services.

3 września 2015

Oracle BI – import metadata connection failed – windows

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 09:00

1. Edit registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\<Oracle_Home> to make sure NLS_LANG key is set to a valid characterset for the Oracle Client used as the DSN.

2. Please edit the file %OBIEE_Client_Home%\\oraclebi\orahome\bifoundation\server\bin\bi_init.bat to set %ORACLE_HOME%\bin as first entry in the PATH.

3. Please add TNS_ADMIN entry to the bi_init.bat file to point to your Oracle client tnsnames.ora home directory path (in case exists) or to your OBIEE tnsadmin %OBIEE_Client_Home%\Oracle_BI1\network\admin.
e.g.
set TNS_ADMIN=C:\oracle\product\11.2.0\client_1\network\admin
OR
set TNS_ADMIN=C:\Oracle\OracleBIEE11g\Oracle_BI1\network\admin

https://community.oracle.com/thread/2267972

11 marca 2015

Unable to reserve the .lok file for Integrated WebLogic Server (IntegratedWebLogicServer).

Zaszufladkowany do: Oracle,WebLogic — Tagi: — Jacek @ 09:18

Oracle JDeveloper 11.1.2.1

When JDeveloper closes unexpected without shutting down IntegratedWebLogicServer, trying to start IntegratedWLS next time, gives “Unable to reserve the .lok file for Integrated WebLogic Server (IntegratedWebLogicServer).”

First Solution is to kill the process in Task Manager. Open Task Manager & check for java.exe process for higher memory consumption. End the process.

IF above does not help then go to C:\Users\RRA\AppData\Roaming\JDeveloper\system11.1.2.1.38.60.81\DefaultDomain . Delete the edit.lok file.

http://adfblogspot.blogspot.com/2012/11/unable-to-reserve-lok-file-for.html

13 sierpnia 2014

VirtualBox to VMware

Zaszufladkowany do: Oracle,VMware — Tagi: , — Jacek @ 13:37

In this tutorial I’ll show you how to convert a VirtualBox image to a VMware image.

I’m sure that there were many situation when you need to migrate a VirtualBox machine to a VMware one.

Tools used are VMware OVF Tool(ovftool.exe is a nice tool that will help you migrate from VirtualBox to VMware) and WMware vCenter Converter Standalone.

So, let’s convert ova image to vmx:

C:\PROGRA~1\VMware\VMware OVF Tool>ovftool.exe D:\IOU_VM.ova D:\IOU_VM.vmx
Opening OVA source: D:\IOU_VM.ova
Opening VMX target: D:\IOU_VM.vmx
Info:    License agreement for the virtual system
License: FREE and Only for PERSONAL use
Accept end-user license agreement?
Write ‘yes’ or ‘no’ (write ‘read’ to reread the EULA):
yes
Error: OVF Package is not supported by target:
- Line 39: Unsupported hardware family ‘virtualbox-2.2′.
Completed with errors


If you get Unsupported hardware family ‘virtualbox-2.2′ error you should try to use –lax argument.

This will transform the Unsupported hardware family ‘virtualbox-2.2′ error into a warning and convert ova file to vmx:

C:\PROGRA~1\VMware\VMware OVF Tool>ovftool.exe –lax D:\IOU_VM.ova D:\IOU_VM.vmx
Opening OVA source: D:\IOU_VM.ova
Opening VMX target: D:\IOU_VM.vmx
Info:    License agreement for the virtual system
License: FREE and Only for PERSONAL use
Accept end-user license agreement?
Write ‘yes’ or ‘no’ (write ‘read’ to reread the EULA):
yes
Warning:
- Line 39: Unsupported hardware family ‘virtualbox-2.2′.
- Line 80: OVF hardware element ‘ResourceType’ with instance ID ’5′: No support
for the virtual hardware device type ’20′.
Writing VMX file: D:\IOU_VM.vmx
Transfer Completed
Warning:
- No manifest entry found for: ‘IOU VM-disk1.vmdk’.
- No manifest file found.
Completed successfully
C:\PROGRA~1\VMware\VMware OVF Tool>


After that you use WMware vCenter Converter Standalone and get a working vmware machine.

From now you can deploy VirtualBox machines on VMware ESXi hosts.

Source

http://www.linuxexpert.ro/Virtualization-Tutorials/convert-virtualbox-image-to-vmware.html

17 lipca 2014

table to csv

Zaszufladkowany do: Bazy danych,Linux,Oracle,Oracle — Tagi: — Jacek @ 18:19

#!/usr/bin/bash

FILE=”emp.csv”

sqlplus -s scott/tiger@XE <

SET PAGESIZE 50000
SET COLSEP ","
SET LINESIZE 200
SET FEEDBACK OFF

SPOOL $FILE

SELECT * FROM EMP;

SPOOL OFF
EXIT
EOF

- See more at: http://www.theunixschool.com/2012/12/shell-script-how-to-dump-oracle-table-into-csv-file.html

SET PAGESIZE 50000 => Set this to a much bigger value. This value indicates the number of lines per page. The header line will get printed in every page. In order to avoid this, set it to a bigger value so that the header appears only once.

SET COLSEP “,” => Setting the column separator to “,”. With this setting, the list displayed by the SELECT clause will be comma separated. This is the most important setting of this script.

SET LINESIZE 200 => The number of characters per line. The default is 80 which means after 80 characters, the rest of the content will be in the next line. Set this to a value which is good enough for the entire record to come in a single line.

SET FEEDBACK OFF => When a select query is executed, a statement appears at the prompt, say “25 rows selected”. In order to prevent this from appearing in the CSV file, the feedback is put off.

SPOOL $FILE => Spool command records the session queries and results into the file specified. In other words, this will write the results of the query to the file.

SELECT * FROM EMP => The query which gives the entire table contents of EMP. If only a part of the table is desired, the query can be updated to get the desired result.

SPOOL OFF => To stop writing the contents of the sql session to the file.

- See more at: http://www.theunixschool.com/2012/12/shell-script-how-to-dump-oracle-table-into-csv-file.html#sthash.XLJ9iSpO.dpuf

ovm cdrom boot problem

Zaszufladkowany do: Oracle — Tagi: , — Jacek @ 12:27

Its funny how things work in Oracle VM ..

I made some changes in configuration file and its working for me.. But I think this needs to be corrected.

xvdb is replaced with hdc..

Before

disk = ['file:/OVS/Repositories/0004fb0000030000aa8563ec6175dcfb/VirtualDisks/0004fb000012000095516dd08c3b253f.img,hda,w', 'file:/OVS/Repositories/0004fb0000030000aa8563ec6175dcfb/ISOs/slampp.iso,xvdb:cdrom,r']

After

disk = ['file:/OVS/Repositories/0004fb0000030000aa8563ec6175dcfb/VirtualDisks/0004fb000012000095516dd08c3b253f.img,hda,w', 'file:/OVS/Repositories/0004fb0000030000aa8563ec6175dcfb/ISOs/slampp.iso,hdc:cdrom,r']

I didn’t upload the iso using OVM managers import option ..Instead i have uploaded the iso file to ISO folder.refreshed repository from Manager..

ISO was reflected in Manager.

Hope this will be helpful for other guys facing similar issue.

———————————————————————————

So you broke lilo. Well done.

Insert your Slackware install DVD or CD1 and boot with defaults.
Once booted:

mkdir /foo
mount /dev/sda1 /foo
mount –bind /proc /foo/proc
mount –bind /sys /foo/sys
mount –bind /dev /foo/dev
chroot /foo
vi /etc/lilo.conf
lilo
exit
reboot

where /dev/sda1 is your installed / partition. Adjust as necessary.

lilo -F -r /mnt/sda2 -b /dev/sda -C /etc/lilo.conf

2 czerwca 2014

Oracle on Solaris 10 : Fixing the ‘ORA-27102: out of memory’ Error

Zaszufladkowany do: Bazy danych,Oracle,Oracle,Solaris — Tagi: , — Jacek @ 21:12

https://blogs.oracle.com/mandalika/entry/oracle_on_solaris_10_fixing

vbox snapshot

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 21:10

https://www.virtualbox.org/ticket/7461

ASM

Zaszufladkowany do: Bazy danych,Oracle,Oracle — Tagi: — Jacek @ 17:48

http://blog.sina.com.cn/s/blog_4ea0bbed0100zd6d.html

http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG94156

4 marca 2014

Oracle read consistency.

Zaszufladkowany do: Oracle,Programowanie,SQL — Tagi: , — Jacek @ 06:44

Read consistency is an automatic implementation. It keeps a partial copy of the database in
the undo segments. The read-consistent image is constructed from the committed data in the
table and the old data that is being changed and is not yet committed from the undo segment.
When an insert, update, or delete operation is made on the database, the Oracle server takes
a copy of the data before it is changed and writes it to an undo segment.
All readers, except the one who issued the change, see the database as it existed before the
changes started; they view the undo segment’s “snapshot” of the data.

The relationship between the EMPLOYEES and DEPARTMENTS tables is
an equijoin; that is, values in the DEPARTMENT_ID column in both tables must be equal.
Often, this type of join involves primary and foreign key complements.
Note: Equijoins are also called simple joins or inner joins.

SELECT e.employee_id, e.last_name, e.department_id,
d.department_id, d.location_id
FROM
employees e, departments d
WHERE e.department_id = d.department_id;

SELECT d.department_id, d.department_name, l.city
FROM
departments d, locations l
WHERE
d.location_id = l.location_id
AND d.department_id IN (20, 50);

NATURAL JOIN
SELECT department_id, department_name,
location_id, city
FROM
departments NATURAL JOIN locations ;

USING
SELECT employee_id, last_name,
location_id, department_id
FROM
employees JOIN departments USING (department_id) ;

ON
SELECT e.employee_id, e.last_name, e.department_id,
d.department_id, d.location_id
FROM
employees e JOIN departments d
ON
(e.department_id = d.department_id);

NONEQUIJOINS
SELECT e.last_name, e.salary, j.grade_level
FROM
employees e, job_grades j
WHERE e.salary
BETWEEN j.lowest_sal AND j.highest_sal;

SELECT e.last_name, e.salary, j.grade_level
FROM
employees e JOIN job_grades j
ON
e.salary BETWEEN j.lowest_sal AND j.highest_sal;

The outer join operator is the plus sign (+)
SELECT e.last_name, e.department_id, d.department_name
FROM
employees e, departments d
WHERE e.department_id(+) = d.department_id ;

SELECT e.last_name, d.department_id, d.department_name
FROM
employees e RIGHT OUTER JOIN departments d
ON
(e.department_id = d.department_id) ;

Self join
SELECT worker.last_name || ‘ works for ‘
|| manager.last_name
FROM
employees worker, employees manager
WHERE worker.manager_id = manager.employee_id ;

UNDO
(5 minut temu)

select * from testable as of timestamp (SysDate – 5/1440)

select * from testtable as of timestamp(’08-Aug-2011 5:00:00 PM’,'DD-MON-YYYY HH:MI:SS AM’);

flashback table testtable to before drop;

12 lutego 2014

NVL NULL, to_date, to_char

Zaszufladkowany do: Oracle,SQL — Tagi: , — Jacek @ 06:47

to_char

22 stycznia 2014

OVM and VMWare comparison.

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 22:59

http://www.oracle.com/us/technologies/virtualization/oraclevm/comparisons/index.html

Migrate from vSphere into Oracle VM 3.0

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 21:49

By Steen Schmidt on Dec 06, 2011

I have had so many question “Can we do an import of vmware VM into Oracle VM 3.0″, and the answer is yes. But as you properly have found out I like to see how it works.

So I just took a vmware image of a Linux converte into a ova (Open Virtualization Archive) file, then I was able to do a import through the OVM manager. When this assemblies had been loaded, it was unpack and the next step was to create a Clone from my new Template.

And “voila”, I had a running VM with Linux in Oracle VM 3.0, imported from VMware.

So it could not be more simple, and it works.

source:
https://blogs.oracle.com/theredstack/entry/migrate_from_vsphere_into_oracle

This article covers the steps to migrate a VMware ESX virtual machine over to an Oracle Virtual Machine. These steps should work with either OVM 2.x or 3.x

Step 1.
Download and install “VMware OVFTOOL 1.0” from the VMware site. You must register to get it.

Step 2.
Unzip your VMware appliance into a directory on your windows or linux machine.

Step 3.
Run the following command to export the vmx file to ovf

C:Program FilesVMwareVMware OVF Tool>ovftool.exe –skipManifestCheck c:temp
opsview-applianceopsview-appliance.vmx c:tempjohn.ova
Opening VMX source: c:tempopsview-applianceopsview-appliance.vmx
Opening OVA target: c:tempjohn.ova
Writing OVA package: c:tempjohn.ova
Disk Transfer Completed

Step 4.
Import the charliebrown.ovf into OVM 3.x as an assembly. Once charlie has been imported create a vm from the template as usual.

Step 5.
Grab a glass of milk and a cookie.

Source:

http://www.davemalpass.com/how-to-migrate-vmware-appliances-to-ovm-3/

ORACLE – archive log mode.

Zaszufladkowany do: Bazy danych,Oracle,Oracle — Tagi: — Jacek @ 20:49
SQL> startup mount
ORACLE instance started.

Total System Global Area  184549376 bytes
Fixed Size                  1300928 bytes
Variable Size             157820480 bytes
Database Buffers           25165824 bytes
Redo Buffers                 262144 bytes
Database mounted.

SQL> alter database archivelog;
Database altered.

5 grudnia 2013

ORA-12514: TNS:listener does not currently know of service

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 17:58
[oracle@vmlnx01 admin]$ oerr ora 12514
12514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"
// *Cause:  The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a service name for a service (usually a database service)
// that either has not yet dynamically registered with the listener or has
// not been statically configured for the listener.  This may be a temporary
// condition such as after the listener has started, but before the database
// instance has registered with the listener.
// *Action:
//  - Wait a moment and try to connect a second time.
//  - Check which services are currently known by the listener by executing:
//    lsnrctl services
//  - Check that the SERVICE_NAME parameter in the connect descriptor of the
//    net service name used specifies a service known by the listener.
//  - If an easy connect naming connect identifier was used, check that
//    the service name specified is a service known by the listener.
//  - Check for an event in the listener.log file.

lsnrctl services

i dodać odpowiedni service do tnsnames.ora

28 października 2013

sqlplus – zmienna

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 22:11

export LD_LIBRARY_PATH=”/usr/lib/oracle/12.1/client64/lib/”

Starsze wpisy »

Strona startowa: www.jaceksen.pl