Gaurav Masand This is a legacy note for Oracle 10g R2. The old companion-disk workflow is specific to that release and should not be treated as the installation method for current Oracle Database versions. Oracle 10g R2 workflow Install the sample-schema components supplied for the 10g R2 release. Connect as a suitably privileged database user. Run the … Read more
A no. of errors are encountered while importing dump files in Oracle database.
Some of them are due to
1. Tablespace not found.
2. User/Role not found.
3. Incorrect database charset
If correct parameters are not provided to the person doing the import, it a more of HIT/TRIAL methdology.
Try using this query to identify the approach to attack invalid objects in the schema select referenced_name, count(referenced_name) cnt from user_dependencies where referenced_name in (select distinct object_name from user_objects where status = ‘INVALID’) group by referenced_name order by cnt desc This will list down the objects in descending order on which maximum no. of invalid objects … Read more
Not able to connect to the DB.
Error Messages encountered:
TNS-03505:
Failed to resolve name
ORA-12154:
TNS:could not resolve the connect identifier specified
The possible solutions can be
For modern Oracle environments, use Data Pump rather than the legacy exp utility when you need to exclude tables or other object types from an export. Data Pump EXCLUDE expdp system@database \ schemas=SCOTT \ directory=DATA_PUMP_DIR \ dumpfile=scott.dmp \ logfile=scott.log \ exclude=TABLE:”IN (‘TABLE1′,’TABLE2’)” The exact quoting can vary by shell, so parameter files are often easier … Read more
After changing a disk partition table, Linux may not immediately notice the new layout. A reboot is the cleanest option, but on some systems you can ask the kernel to re-read the partition table. Check current block devices Ask the kernel to re-read partitions Replace /dev/sdX with the whole disk, not a partition. For example, … Read more
Linux file permissions control who can read, write or execute a file. This is one of the first things to check when a script does not run, a service cannot read a file, or a user cannot access a directory. View permissions A typical output line looks like this: The first character shows the type … Read more
Network printers are usually easier to manage when you know the printer IP address, queue name and protocol being used. On Linux systems, printing is commonly handled through CUPS. Useful checks These commands show configured printers and the device URI used by each printer. Check CUPS service When troubleshooting, confirm that the printer is reachable … Read more
When a service cannot start because a port is already in use, the first step is to identify which process is listening on that port. Using ss This lists listening TCP ports and the process information where available. Using lsof Replace 8080 with the port you are checking. Older systems ss is generally preferred on … Read more
Name resolution is the process of turning a hostname into an IP address. When a Linux machine cannot reach a host by name, check DNS settings before assuming the network itself is down. Check resolver configuration This shows the name servers currently being used by the system. On many modern distributions this file may be … Read more