miercuri, 8 iunie 2016

Oracle DB expdp ORA-39071: Value for SCHEMAS is badly formed solved

If you receive this error ORA-39071: Value for SCHEMAS is badly formed, you can get rid of it by logging in with the schema that you want to export.
Example: Let's say you want to export schema test with the password 1234. You can write:
expdp test/1234
The value for SCHEMAS will be by default test and you will not receive ORA-39071 anymore.

vineri, 3 iunie 2016

Windows check if another's computer/machine port is open

If you want to see if antoher's computer/machine port is accesible from your Windows computer/machine type:
telnet <full_machine_name_or_ip> <port>

Example (scenario: test if the default port for Remote Desktop Connection on test_comp computer is open for your computer/machine ):
telnet test_comp 3389

marți, 5 aprilie 2016

Chrome save/bookmark all opened tabs

If you have many tabs opened in your Chrome browser and you need to close the browser (if you need to shutdown/restart your computer) you probably want to save this opened tabs in order to open them later. To save the opened tabs, you can follow these steps:
1. Right click on one of the opened tabs -> choose Bookmark all tabs
2. In the windows that appears give a name to the folder and click Save. Now you have saved your tabs and you can close the browser.
3. Open Chrome and click the button that looks like this = (but with 3 sticks) in top-right -> Bookmarks -> Bookmark manager








4. In the window that appears right click the folder you created at step 2 and choose Open all bookmarks. Now all the tabs should be restored.

Windows set proxy

If you want to setup a a proxy in Windows, you can follow these steps:
1. Open Internet Explorer (I chose this browser because every Windows comes with it)
2. When you are in browser press Alt (to see the Menu bar)
3. Go to Tools -> Internet options -> choose Connections tab -> LAN settings -> check 'Use a proxy server for your LAN' and fill the fields 'Address' and 'Port'.
If you want to set advanced options click on the Advanced button and fill the fields that you need.

Outlook 2013 disable/stop autocorrect

If you are trying to write an e-mail in Outlook 2013 and you don't want that your text to be autocorrected automatically you should follow this advice:
Go to File -> Options -> Mail (second in top-left) -> Spelling and Autocorrect -> AutoCorrect Options -> and here you can uncheck what you don't need. In my case, I unchecked 'Replace text as you type' because it was annoying me.

SQL Developer see/check/kill sessions

If you want to check/kill opened sessions with the database, you can follow the steps below (your user must be DBA):
1. In SQL Developer go to View -> Reports. This will show you the window with the reports.
2. In the Reports window go to Data Dictionary Reports -> Database Administration -> Sessions -> Sessions . Here you can see informations about each session. If you need to kill a session you have to select a field of the row you want to delete then right click -> Kill Session

marți, 29 martie 2016

Windows The remote session was disconnected because there are no Remote Desktop client access licenses available

If you get this message "The remote session was disconnected because there are no Remote Desktop client access licenses available for this computer" when you are trying to establish a remote desktop connection, you should follow these steps:
1. Open Run
2. Type regedit and press Enter
3. Now you need to backup the registry key that you will delete. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing, right-click it and choose Export. Choose a location on your computer where you want to keep this backup.If you will need to restore this backup you have to select HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft, click File (top left) -> Import and indicate the file from your system where you saved the backup.



4. Delete the registry key that you backed up at step 3
5. Right-click Remote Desktop Connection and choose Run as Administrator. Now, you should not receive the error anymore and if you check in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft you should see that the registry key MSLicensing was created.