entry 'string' does not exist in directory 'string'
Fix: List the parent directory (asmcmd ls -l +DATA//) to see the real names, and use find to locate the file.
ASMCMD 1
INS 1
Environment does not meet minimum requirements
Fix: Install on a certified OS release, or set CV_ASSUME_DISTID to a release the installer knows before starting it, and apply the latest Release Update, which adds support for newer OS...
ORA 12
unique constraint (string.string) violated
Fix: Find the constraint and its columns in DBA_CONS_COLUMNS, then either skip the duplicate row, update the existing row instead (MERGE), or take the key from a sequence / identity col...
string: invalid identifier
Fix: Check the spelling and case against DESCRIBE table. To filter or group on an alias, repeat the expression or wrap the query in an inline view and filter the outer query. Aggregate...
ORACLE not available
Fix: Check which instances run (ps -ef | grep pmon) and that ORACLE_SID matches one of them, including case. If the instance is down, start it with STARTUP as SYSDBA and read the alert...
cannot insert NULL into (string)
Fix: Supply a value for that column in the INSERT, or give the column a DEFAULT (ALTER TABLE ... MODIFY col DEFAULT ...). For generated keys, use a sequence or an identity column.
no data found
Fix: Handle it where a missing row is a normal case: add an EXCEPTION WHEN NO_DATA_FOUND block, or select COUNT(*) / use a cursor loop instead of SELECT INTO.
single-row subquery returns more than one row
Fix: Use IN / ANY / EXISTS instead of =, or make the subquery return one row (an aggregate such as MAX, a tighter WHERE, or FETCH FIRST 1 ROW ONLY) — whichever matches what the query is...
integrity constraint (string.string) violated - parent key not found
Fix: Insert the parent row first (or in the same transaction, before the child), correct the foreign-key value, or check which parent table the constraint references in DBA_CONSTRAINTS...
PL/SQL: numeric or value error
Fix: Read the rest of the message and the line number in the error stack, then enlarge the variable (anchor it with %TYPE to the column) or fix the value being converted.
Unable to create audit trail file
Fix: Create the directory named in AUDIT_FILE_DEST (from the pfile/spfile, or the default $ORACLE_BASE/admin//adump) with the right owner, and check free space.
TNS:listener does not currently know of service requested in connect descriptor
Fix: Run lsnrctl status and compare the services listed with SERVICE_NAME in tnsnames.ora. Use the full name including the domain, or register the instance: check LOCAL_LISTENER and run...
TNS:no listener
Fix: Start the listener (lsnrctl start, or srvctl start listener on Grid Infrastructure), check the HOST and PORT in tnsnames.ora against lsnrctl status, and open the port in the firewa...
member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
Fix: Clear the remote LOG_ARCHIVE_DEST_n on both databases (keep the local destination), then add the database to the broker again. Set transport options through broker properties such...
PRCD 1
The resource for database string could not be found.
Fix: Register the database with srvctl add database (with its DB_UNIQUE_NAME, Oracle home, spfile and role), and add instances on RAC, then manage it with srvctl.
PRCR 1
Resource string does not exist
Fix: Check the registered resources with crsctl stat res -t or srvctl config database, and register the missing database with srvctl add database.
PRVF 3
Both 'search' and 'domain' entries are present in file "/etc/resolv.conf" on the following nodes: string
Fix: Remove the domain line (keep search) on all nodes, making sure NetworkManager does not write it back.
Sufficient physical memory is not available on node "string"
Fix: Add memory to the node. In a lab, where less memory is a deliberate choice, the check can be ignored in the installer.
Sufficient swap size is not available on node "string"
Fix: Add a swap file or partition on each node, or ignore the check in a lab environment.
PRVG 4
The IP address "string" is on multiple interfaces "string" on nodes "string"
Fix: If you do not use libvirt on the nodes, remove the default network so virbr0 disappears; otherwise the warning can be ignored as virbr0 is not a cluster interface.
no response for name "string" from the DNS server
Fix: Add the node names to DNS, or, in a lab that uses /etc/hosts and has no DNS, ignore the check.
Name "string" was not resolved to an address of the specified type by name servers
Fix: Make the node names resolvable in DNS with the right address type, or ignore it in a lab that resolves names from /etc/hosts only.
Oracle 19c RAC Installation Part III - Grid Installation
Fix: With the Clusterware stack down on that node, remove the leftover files, then run the check again.
RMAN 1
warning: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
Fix: Nothing needs fixing — it is a warning and the files are created in the target disk group with OMF names. To avoid it, convert only the disk group (e.g. '+DATA/PRIM', '+DATA/STBY')...
No match
Nothing here for that yet. Try searching all articles.