A fresh view on Oracle
If you don’t want to use Guest or External (host) authentication when using VirtualBox Remote Display, one can add an extra external option called VBoxAuthSimple as explained here: http://www.virtualbox.org/manual/ch07.html#vbox-auth . This username/password will be stored in the machine’s XML settings file.
Simple steps for (scott/tiger):
[Read the rest of this entry...]
Sometimes… as Oracle DBA you need to connect to SQL Server (with Oracle SQL Developer and jTDS plug-in installed).
When using ‘SQL Server Management Studio’, the ‘Server name’ is in the format:
SERVERNAME\INSTANCE.
This won’t work in SQL Developer:
Status : Failure -Unknown server host name 'SERVERNAME\INSTANCE'.
This can be solved using the Hostname in the next format in SQL Developer:
SERVERNAME;instance=INSTANCE
For me it worked :)
Wipe-out! Do you have a problem loading Google Calendar in Firefox and getting:
“The page isn’t redirecting properly“, “This problem can sometimes be caused by disabling or refusing to accept cookies.“?
I only removed one cookie for Domain ‘.www.google.com‘ and Path ‘/calendar/‘ and problem was solved!
The dot prefixing the ‘www’ is causing the problem I think.
Happy surfing!
Today I ran into an add-on for FireFox which can create a wget command from a download file dialog box. First thing that came in mind was; Will this work for Metalink / My Oracle Support? Yes is does!
The add-on is called ‘cliget’ and can be downloaded here: cliget add-on for FireFox.
[Read the rest of this entry...]
Sometimes you don’t want to use a lot of disk space on your VirtualBox for install software or any ‘temporary’ need of space.
Adding shared folders from your host to your VirtualBox guest is a good option to use. If you have a Windows guest and a GUI based Host, it it’s very easy; click, click, done.
BUt if you are stuck with only a command line based guest and or host, it a bit more complex. Please use this post a guideline, Linux knowledge is assumed…
[Read the rest of this entry...]
The expdp and impdp utilities are command-line driven, but when starting them from the OS-prompt, one does not notice it. When you want to kill, cancel, start or resume a job, you will and up in the datapump command prompt… now what?!
All command shown here can be used with expdp and impdp datapump.
[Read the rest of this entry...]
When checking for the latest version of Wireshark, I came across their IPv4/IPv6 test page.
Of course a lot more IPv6 test pages can be found here:
http://www.google.com/search?q=ipv6+test
Happy testing!
Last few weeks I have been exporting 10g databases for migrating them to 11g. I knew Export Data Pump was read consistent (I have been running into ORA-01555‘s), but I was surprised to see a ORA-02298 (parent keys not found) when importing:
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39083: Object type REF_CONSTRAINT failed to create with error:
ORA-02298: cannot validate (SCOTT.FK_SCALE_ID) - parent keys not found
Failing sql is:
ALTER TABLE "SCOTT"."SCALE_ID" ADD CONSTRAINT "FK_SCALE_ID" FOREIGN KEY ("SCALE_ID") REFERENCES "SCOTT"."SCALE" ("ID") ENABLE
I thought the expdp had made an consistent database dump, but didn’t! The FK’s present in SALARY were not present as PK’s in the SCALE table, so this could only mean the dump was not database consistent at all!
[Read the rest of this entry...]
The Easy Connect Naming Method allows you to connect to a database service without having to configure Net Service Names.
The most found example on internet is the one with typing the password at the command prompt when starting sqlplus:
sqlplus username/password@[//]host[:port][/service_name]
$> sqlplus system/manager@db_machine:1521/db_servicename
However, this means that the password will be stored in you history of commands (linux). This is not really secure… but sqlplus does not accept it when no password is supplied when using easy connect.
If you want to login with easy connect without typing the password on the command line, you have two options:
[Read the rest of this entry...]